The course is part of this learning path
Power BI has changed the business intelligence (BI) landscape forever, enabling BI professionals and regular Excel users alike to work with big data and build beautiful and insightful dashboards. Integral to the Power BI platform is the data model.
This course discusses fundamental concepts of data modeling design within Power BI. We explore Microsoft's recommended best practices as well as common data modeling complications and the solutions to them. This course will prepare learners to develop data models strategically to achieve the best performance.
Learning Objectives
- Identify the primary components of data models and describe flat schemas and star schemas
- Diagnose common Power BI data modeling issues within models and recommend appropriate solutions to them
- Identify common challenges in Power BI data models, implement smart solutions, and avoid common mistakes
Intended Audience
- Business professionals whose job requires them to design and build data models in Power BI
- Anyone preparing to take the Microsoft DA-100 exam
Prerequisites
To get the most out of this course, you should be familiar with preparing data using Power BI.
There is a whole language of functions in Power BI. But before we are ready to deep-dive into the world of DAX there's a neat feature that will help us make our measures called Quick Measures. Let's say we wanna calculate the profit of each sale by subtracting the cost from the gross sale amount. We can create a Quick Measure by selecting the table where we want this measure to live and find Quick Measure on the ribbon or we can right click any field and choose New Quick Measure.
In the Quick Measure window, let's scroll to the Mathematical group and select Subtraction. In the Fields pane, let's expand the FactSales table so we can find our GrossSaleAmount and drag it into the Base Value box. Drag the Sale Cost field into the Value to Subtract box and just notice that each of these fields are gonna be aggregated by Sum and that sum is gonna happen before the subtraction happens. We'll select Okay. And there it is. Notice the new measure has a calculator icon next to it. This is how you can visually identify them. That was easy, Quick Measures are that easy.
Chelsea Dohemann is a Senior Technical Trainer and Microsoft Certified Master with almost a decade of experience in technology training. She has taught an array of applications from Microsoft products including Office 365 web apps, Microsoft Office Suite, Power BI, VBA for Excel, and SharePoint to Adobe Acrobat Pro and Creative Cloud. Being a persistent learner herself, Chelsea is acutely in-tune with the challenges of learning. She presents her topics in plain language, with real-world examples, reducing complex concepts down to their simple parts.