Designing a Data Model in Power BI

Focused View

Chelsea Dohemann

43:00

20 View

1. Introduction.mp4

03:10

2. Features of a Good Data Model.mp4

06:20

3. Schemas and Tables.mp4

02:27

4. Relationships.mp4

05:36

5. Resolving Many-to-Many Issues.mp4

08:00

6. Granularity.mp4

01:35

7. Quick Measures.mp4

01:11

8. Creating Common Date Tables.mp4

06:41

9. Field Properties.mp4

03:13

10. Hierarchy Issues.mp4

04:29

11. Conclusion.mp4

00:18

Description

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 lesson 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 lesson 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 lesson, you should be familiar with preparing data using Power BI.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Data Modeling

Chelsea Dohemann

Instructor's Courses

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.

Cloud Academy

View courses Cloud Academy

Join thousands of users in achieving your personal goals through Cloud Academy. Score job-ready tech skills that you can practice in a real environment, without the risk of extra costs or making mistakes. It’s simply the smartest way to gain certifications and get career-ready.