Maxtrain.com - info@maxtrain.com - 513-322-8888 - 866-595-6863
Data Model Design using Power BI Desktop – Level 2
Description
Welcome to the “Data Model Design using Power BI Desktop – Level 2” course, the next step in your journey to becoming a Power BI expert. Building on the foundational knowledge from Level 1, this advanced course will empower you to create custom data models, perform advanced data transformations, and harness the power of Data Analytic Expressions (DAX).
Course Description: In this Level 2 course, you will delve into advanced concepts of Self-Service Data Model Design, with a focus on hands-on learning. Key topics covered include advanced Power Query techniques, data transformation, DAX calculated columns and measures, and an introduction to the M Language.
Upon completing this course, you will be equipped to:
- Understand the intricacies of Power BI Queries.
- Create and transform data models effectively.
- Master Query Editor Transformations.
- Access additional data sources and create hybrid data models.
- Utilize DAX for calculated columns and measures.
- Optimize model performance and work with data tables.
- Explore the M Language for advanced data manipulation.
- Gain insights into storage modes (Import vs. DirectQuery) and Dataverse integration.
Outline
Lesson 1: Understanding Power BI Data Queries
- Overview of Power BI Queries.
- Power Query Essentials.
- Exploring 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
- Mastering Query Editor Transformations.
- Altering the Data for meaningful insights.
- Creating new data for analysis.
- Data refreshing strategies.
Lesson 4: Accessing Additional Data Sources
- Incorporating data from an Access database.
- Creating Hybrid Data Models.
- Working seamlessly with diverse data sources.
Lesson 5: DAX Calculated Columns and Measures
- Review of Calculated Columns.
- Harnessing the power of Power BI Measures.
- Understanding Evaluation Context.
- Strategies to optimize model performance.
- Leveraging Date Tables for time-based analysis.
Lesson 6: Introduction to the M Language
- Exploring Power BI Functions in the M Language.
- Mastering M Language Syntax.
- Adding Columns dynamically.
- Appendices: Understanding Storage Modes (Import vs. DirectQuery) and Dataverse integration.
- Elevate your Power BI skills to the next level with our Level 2 course. Enroll now and unlock the full potential of data modeling and analysis with Power BI Desktop!
PreRequisites
To fully benefit from this course, you should have completed the “Data Analysis using Power BI Desktop – Level 1 – Report Builder” course.
Audience
This course is tailored for Business Analysts and Report Builders who are responsible for creating customized reports using Power BI in conjunction with Excel.
$595.00
|
1 Day Course |