Individuals with a basic understanding of Power BI, who want to create (model) efficient data sets and reports that provide important data discoveries with a user-friendly experience.

• Understand how to build a data model that optimizes performance.
• Troubleshoot data models using out-of-the-box tools.
• Shape data for visualizations in reports and communications.
• Build complex DAX functions.
• Create visualizations that help identify trends and patterns.
• Use techniques to increase Power BI report adoption among report consumers.

This course explains the necessary foundations for a data analyst using Microsoft Power BI. It covers the following:

Star schema

• Learn about dimension tables and fact tables and how efficiently using them can improve the performance of your reports
• Understand query folding
• Gain an understanding of normalization and denormalization and how it affects performance
• Create surrogate keys to improve filter propagations
• Learn about creating relationships and cardinality
• Review role-playing dimensions, when you need them and how to use them

Optimize model performance

• Learn how to use Performance Analyzer to identify bottlenecks
• Discover the benefits of using variables in DAX
• Learn about improving performance by reducing cardinality levels in columns and implementing data granularity

Identifying patterns and trends

• Gain an understanding of using out-of-the-box visuals with build in AI to identify trends and outliers
• Experience using custom visuals to help understand your data better and to better tell your story
• Use some advanced DAX functions with a discussion about Dax patterns to improve the ability to recognize anomalies and trends

Building datasets and Power BI reports that users will use (user adoption)

• Review techniques on shaping data for end users and visualizations
• See a story unfold
• Learn methods to report viewers to perform some customization, through personalization and Q&A
• Review report delivery methods that reduce complexity and allow for built-in “help”

Familiarity with data collection and data handling is required. Prior completion of Power BI – Introduction or equivalent experience is recommended.