Power BI – Modeling Data
One of the most valuable assets a business owns is data. For most businesses, it is the single most important asset. But data only becomes an asset when it is actionable. What has happened? What is happening? What will happen? What can I do to get the desired outcome? To get to these answers, the data must be transformed. Not changing the data, but instead organizing the data in a way that the data can then speak for itself. Find out how data modeling for a software application is very different than data modeling for business intelligence.
This course focuses on the process of transforming data using the star schema method. We then apply Microsoft Power BI-specific features and tools to improve efficiency and let the data tell the story.
Power BI – Modeling Data builds on the skills covered in the companion course, Power BI – Introduction, which is included in the Data Analysis Certificate.
Belinda Allen is a Microsoft Most Valuable Professional (MVP) for Power BI. Belinda is currently a Microsoft Power Platform (Certified) Trainer (MCT), speaker and co-author of two books on business intelligence and Microsoft Dynamics GP. Belinda is a principal at ... read more
Who Should Attend
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.
Benefits and Learning Outcomes
- 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:
- 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.
Date: Mon, Jan 30; Wed, Feb 1; Mon, Feb 6; Wed, Feb 8
Delivery Method: Live Online
Time: 8:30am - Noon CT
Instructor: Belinda Allen MCT/MVP
Enrollment Limit: 12
Program Number: 5020-14947
Note: Participants will receive instructions and course links prior to the first day of class.
Registration Deadline: Jan 30Registration deadline has passed.