No products in the cart.
Course Schedule
Overview
Using fundamental concepts of Self-Service Data Model Design, students will use Power Query to extract, transform, and load data to create manageable and scalable data models. This course is designed for Report Builders who are ready to create custom data models. Students will also receive an introduction to the M Language as well as Data Analytic expressions (DAX).
Prerequisites:
The knowledge and skills that the learner should have before attending this course are as follows:
- Data Analysis using Power BI Desktop – Level 1 – Report Builder
Course content
Lesson 1: Understanding Power BI Data Queries
- Overview of Power BI Queries
- Power Query
- Data Sources
Lesson 2: Creating and Transforming Data Models
- Understanding a Basic Data Model
- Creating the Initial Data Query
- Converting Raw Data into a Data Model
Lesson 3: Data Transformations
- Query Editor Transformations
- Altering the Data
- Creating new Data
- Refreshing Data
Lesson 4: Accessing Additional Data Sources
- Using an Access database
- Creating a Hybrid Data Model
- Working with Data
Lesson 5: DAX Calculated Columns and Measures
- Review of Calculated Columns
- Power BI Measures
- Evaluation Context
- Optimize Model Performance
- Date Tables
Lesson 6: Introduction to the M Language
- Power BI Functions: M Language
- M Language Syntax
- Adding Columns
FAQ
What if I have to reschedule my class due to conflict?
Ten (10) business days’ notice is required to reschedule a class with no additional fees. Notify TOPTALENT LEARNING as soon as possible at 469-721-6100 or by written notification to info@toptalentlearning.com to avoid rescheduling penalties.
How do I enroll for this class?
Please contact our team at 469-721-6100; we will gladly guide you through the online purchasing process.
What happens once I purchase a class?
You will receive a receipt and an enrollment confirmation sent to the email you submitted at purchase. Your enrollment email will have instructions on how to access the class. Any additional questions our team is here to support you. Please call us at 469-721-6100.
What is your late policy?
If a student is 15 minutes late, they risk losing their seat to a standby student. If a student is 30 minutes late or more, they will need to reschedule. A no-show fee will apply. Retakes are enrolled on a stand-by basis. The student must supply previously issued courseware. Additional fees may apply.
What happens when I finish my class?
You will receive a ‘Certificate of Completion’ once you complete the class. If you purchased an exam voucher for the class, a team member from TOPTALENT LEARNING will reach out to discuss your readiness for the voucher and make arrangements to send it.