Data Model Design using Power BI Desktop - Level 2
Guaranteed to Run
Price
$650.00
Duration
1 Day
Delivery Methods
Virtual Instructor Led Private Group
Delivery
Virtual
ESTDescription
Prerequisites
Content
Course Description
This is the second course in the custom Power BI Desktop training series. What makes Power BI for such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Power BI Report Users.
Course Prerequisites
Data Analysis using Power BI Desktop – Level 1 – Report Builder
Course Content
Module 1: Power BI Queries
- Overview of Power BI queries
- Power Query fundamentals
- Connecting to data sources
Module 2: Building Data Models
- Basics of data models
- Creating initial data queries
- Converting raw data into structured models
Module 3: Transforming Data
- Query Editor transformations
- Altering and shaping data
- Creating new data fields
- Refreshing and maintaining data
Module 4: Working with Data Sources
- Using Access databases
- Creating hybrid data models
- Managing multiple data sources
Module 5: DAX for Analysis
- Calculated columns and measures
- Evaluation context
- Model performance optimization
- Date tables
Module 6: M Language Essentials
- Functions in M
- M syntax and expressions
- Adding and customizing columns
Do You Need Help? Please Fill Out The Form Below