Skills you will learn

  • Building and Structuring Data Models in Power BI
  • Writing DAX Formulas and Calculations
  • Creating Measures, Calculated Columns, and Tables with DAX
  • Optimizing Power BI Model Performance
  • Data Visualization and Analysis in Power BI
  • Designing Interactive Dashboards and Reports
  • Applying Best Practices for Power BI Data Modeling

Who should learn

  • Data Analysts
  • BI Professionals
  • Power BI Developers
  • Students
  • Business Analysts
  • Data Scientists

What you will learn

  • Learn Power BI Data Modeling with DAX

    • Lesson 01: Course Introduction

      01:48
      • Course Introduction Mastering Power BI Data Modeling DAX Calculations Performance Optimization and Data Visualization
        01:48

    • Lesson 02: Data Modeling

      01:03:29
      • 2.01 Learning Objectives
        02:27
      • 2.02 Design and Implement a Data Model
        04:32
      • 2.03 Identifying Dimensions and Facts
        02:20
      • 2.04 Star Schema or Snowflake Schema
        04:00
      • 2.05 Configuring Table and Column Properties
        05:20
      • 2.06 Demo Configuring Table and Column Properties in Power BI
        06:57
      • 2.07 Implementing Role Playing Dimensions
        06:54
      • 2.08 Defining Relationship Cardinality
        04:54
      • 2.09 Cross Filter Direction
        02:24
      • 2.10 Demo Configuring Relationship Cardinality and Cross Filter Direction
        08:11
      • 2.11 Introduction to Date Tables in Power BI
        03:45
      • 2.12 Creating Date Tables and Relationships in Power BI
        03:39
      • 2.13 Implementing Security Roles and Permissions
        01:11
      • 2.14 Row Level Security in Power BI
        05:41
      • 2.15 Key Takeaways
        01:14

    • Lesson 03: Model Calculations with DAX

      01:23:31
      • 3.01 Learning Objectives
        01:54
      • 3.02 Introduction to Data Analysis Expressions DAX
        03:26
      • 3.03 DAX Formulas and Operators
        04:28
      • 3.04 Introduction to Measures in Power BI
        04:58
      • 3.05 Creating Single Aggregation Measures
        05:12
      • 3.06 Using DAX Functions
        04:39
      • 3.07 Using CALCULATE to Manipulate Filters
        06:02
      • 3.08 Understanding Row Contexts
        00:46
      • 3.09 Demo Analyzing Sales Data with DAX and Filter Context
        12:04
      • 3.10 Time Intelligence Functions
        06:38
      • 3.11 Time Series Analysis
        03:43
      • 3.12 Using Basic Statistical Functions
        05:49
      • 3.13 Creating Measures Using Quick Measures
        05:33
      • 3.14 Demo Creating Quick Measures in Power BI for Healthcare Data
        09:20
      • 3.15 Creating Calculated Tables
        04:15
      • 3.16 Example Creating a Calculated Table
        02:39
      • 3.17 Using Calculated Tables in Relationships​
        01:02
      • 3.18 Key Takeaways
        01:03

    • Lesson 04: Optimize Model Performance

      01:20:34
      • 4.01 Learning Objectives
        04:41
      • 4.02 Improve Performance​ Identify and Remove Unnecessary Rows and Columns​
        01:38
      • 4.03 Common Performance Issues in Power BI
        04:16
      • 4.04 Analyzing Data Usage
        03:22
      • 4.05 Identifying Redundant Data
        06:19
      • 4.06 Removing Unnecessary Data to Improve Query Performance
        01:50
      • 4.07 Techniques to Improve Query Performance in Power BI
        05:31
      • 4.08 Understanding Performance Analyzer
        02:49
      • 4.09 Using Performance Analyzer to Identify Performance Bottlenecks
        05:38
      • 4.10 Optimizing Measures Relationships and Visualizations
        05:43
      • 4.11 Improve Performance by Choosing Optimal Data Types​​
        02:22
      • 4.12 Data Types and Their Implications
        02:23
      • 4.13 Avoiding Unnecessary Data Conversions
        05:16
      • 4.14 Demo Optimizing Power BI Query Performance Through Data Cleansing
        12:40
      • 4.15 Improve Performance by Summarizing Data​
        05:43
      • 4.16 Best Practices for Summarization
        05:37
      • 4.17 Understanding Aggregations
        03:37
      • 4.18 Key Takeaways
        01:09

    • Lesson 05: Visualize and Analyze the Data

      01:50:30
      • 5.01 Learnining Objectives
        01:37
      • 5.02 Create Reports
        03:28
      • 5.03 Visualization Types
        06:12
      • 5.04 Apply and Customize a Theme
        02:18
      • 5.05 Conditional Formatting
        05:25
      • 5.06 Configure the Report Page
        03:21
      • 5.07 Paginated Report
        04:18
      • 5.08 Paginated Reports in Power BI Creation Use Cases and Comparison with Traditional Reports
        05:37
      • 5.09 Demo Create Visualizations Part 1
        07:35
      • 5.10 Demo Create Visualizations Part 2
        07:20
      • 5.11 Enhance Reports for Usability and Storytelling​ Bookmarks
        03:13
      • 5.12 Enhance Reports for Usability and Storytelling​ Tooltips
        03:56
      • 5.13 Edit and Configure Interactions Between Visuals​
        03:40
      • 5.14 Enhance Reports for Usability and Storytelling Configure Interactions
        03:37
      • 5.15 Enhance Reports for Usability and Storytelling​ Sorting
        01:51
      • 5.16 Enhance Reports for Usability and Storytelling Sync Slicers
        01:24
      • 5.17 Enhance Reports for Usability and Storytelling Selection Pane
        02:20
      • 5.18 Enhance Reports for Usability and Storytelling Tab Order and Drill Through
        01:19
      • 5.19 Exporting Reports
        01:50
      • 5.20 Design Reports for Mobile Devices
        06:35
      • 5.21 Demo Creating a Mobile Layout
        06:54
      • 5.22 Identifying Patterns and Trends​​
        03:45
      • 5.23 Grouping
        02:51
      • 5.24 Binning
        01:04
      • 5.25 Clustering
        02:26
      • 5.26 Introduction to AI Visuals
        01:12
      • 5.27 Using AI Visuals to Analyze Key Drivers and Metrics
        05:54
      • 5.28 Using AI Visuals to Detect Anomalies and Explore Data Insights
        04:04
      • 5.29 Reference Lines and Error Bars in Power BI Visuals
        02:18
      • 5.30 Forecasting
        01:34
      • 5.31 Key Takeaways
        01:32
      • Knowledge Check
About the Course

If you’re looking to get better at Power BI, this course is a great fit. You’ll learn how to build solid data models, write DAX calculations, speed up your models, and create visuals that help you understand your data. Whether you’re a data analyst or a business professional who wants to use data more effectively, you’ll get plenty of practical, hands-on experience. By the end, you’ll feel ready to build efficient and impressive Power BI reports and dashboards.

Topics

Read More

For Business

Get your team a Digital Skilling Library with
unlimited access to live classes.

Explore Our Solutions
People Frame

Get a Completion Certificate

Share your certificate with prospective employers and your professional network on LinkedIn.

FAQs

  • Is this course free?

    Yes, this course is free. You can access all lessons for free and still receive a professional certificate upon successful completion.

  • Is this course suitable for beginners?

    This course is best suited for learners who have a basic familiarity with Power BI. It covers intermediate to advanced topics such as DAX calculations, data modeling, and performance optimization, so some prior exposure to Power BI will help you get the most out of the course.

  • Are there any prerequisites for this course?

    A basic understanding of Power BI and familiarity with data concepts such as tables, relationships, and basic formulas is recommended before taking this course, as it dives into intermediate and advanced topics from the start.

  • What topics are covered in this course?

    This course covers Power BI data modeling, DAX calculations including measures and calculated columns, model performance optimization, and data visualization and analysis using interactive Power BI dashboards and reports.

  • What is DAX and why is it important in Power BI?

    DAX, which stands for Data Analysis Expressions, is the formula language in Power BI for creating calculations, measures, and custom columns that power your reports and dashboards. It is one of the most important skills for any Power BI developer, and Lesson 03 is fully dedicated to helping you master it.

  • What is data modeling in Power BI and why does it matter?

    Data modeling in Power BI involves organizing and structuring your data tables and relationships to support accurate calculations and high-performing reports. A well-built data model is the foundation of every great Power BI report, and Lesson 02 covers it in comprehensive detail.

  • Does this course cover performance optimization?

    Yes, Lesson 04 is fully dedicated to optimizing model performance, covering techniques to improve DAX query speed, reduce model size, and apply best practices to ensure your Power BI reports perform efficiently even with large and complex datasets.

  • Will I learn how to create dashboards and visualizations in this course?

    Yes, Lesson 05 covers data visualization and analysis in Power BI, showing you how to design interactive dashboards, choose the right chart types, use slicers and filters, and communicate data insights effectively through compelling visual reports.

  • What is the difference between a measure and a calculated column in DAX?

    A measure is a dynamic DAX calculation evaluated at query time based on the current filter context, whereas a calculated column is computed row by row during data refresh and stored in the model. Both are covered in detail in Lesson 03.

  • Does this course cover time intelligence in DAX?

    Yes, Lesson 03 covers time intelligence calculations in DAX, including functions that allow you to compare performance across different time periods, such as year-to-date, month-to-date, and same-period last year calculations.

  • How long will it take to complete this course?

    This course has a total duration of approximately 4.5 hours and is fully self-paced, meaning you can complete it at your own schedule and convenience.

  • Is a certificate provided upon completion of this course?

    Yes, upon successful completion, you will receive a free professional certificate that you can add to your resume or LinkedIn profile to demonstrate your Power BI and DAX expertise to potential employers.

  • Can I access this course on my mobile device?

    Yes, this course is accessible on both desktop and mobile devices, so you can learn anytime, anywhere, at your own pace.

  • Can I add this certificate to my LinkedIn profile?

    Yes, once you complete the course and receive your certificate, you can add it to your LinkedIn profile under the Licenses and Certifications section to showcase your Power BI data modeling and DAX skills to recruiters and employers.

  • How is this course different from a basic Power BI course?

    Unlike a basic Power BI course that focuses on getting started with the tool, this course goes deeper into the technical aspects of data modeling, DAX formula writing, and performance optimization, equipping you with the advanced skills to build professional-grade Power BI solutions that are accurate, efficient, and visually impactful.

Related Courses

  • Acknowledgement
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, OPM3 and the PMI ATP seal are the registered marks of the Project Management Institute, Inc.
  • *All trademarks are the property of their respective owners and their inclusion does not imply endorsement or affiliation.
  • Career Impact Results vary based on experience and numerous factors.