Power BI Data Model Design Using Power BI Desktop
Good Power BI reports need good data. Two of the more important features of Power BI are the data import and clean tools in Power Query and the data Model that holds the imported data. In this course we will explore Power Query and how it connects to over 100 data sources. We will clean and transform the raw data into a form useful for Power Bi Reporting. After this data is imported into the Power Bi Model we will explore DAX formulas to summarize data and to add time intelligence features. If you are using anything more than simple data sources you should consider this an important follow up to the Power BI reporting course.
Retail Price: $595.00
Next Date: 02/10/2025
Course Days: 1
Enroll in Next Date
Request Custom Course
At Course Completion
By the end of this course, participants will:
Understand Power BI’s Power Query for Data Import and Cleaning: Learn the techniques to import, clean and organize data from 100’s of sources.
Understand Power BI Data Modeling: Learn the principles of data modeling and how to apply them within Power BI.
Practical Application: Apply learned concepts through hands-on projects to real-world scenarios, enhancing your capability to make data-driven decisions.
Outline
Get Data in Power BI
- Connect to various data sources
- Enhance data retrieval performance
Clean, Transform, and Load Data in Power BI
- Utilize Power Query for data cleaning and preparation
- Profile columns and transform data types
- Explore the Power Query M Language
Design a Data Model in Power BI
- Develop common date tables
- Configure relationships and star schemas
- Select the appropriate data granularity
Add Measures to Power BI Desktop Models
- Create both simple and complex measures
- Understand the difference between calculated columns and measures
Optimize a Model for Performance in Power BI
- Review and enhance measure and relationship performance
- Optimize data models for improved performance
Manage Datasets in the Power BI Service
- Connect to on-premises data sources using a gateway
- Configure dataset refresh and optimize performance
Implement Row-Level Security in Power BI
- Configure row-level security for precise data access control
Perform Analytics in Power BI
- Explore statistical analysis and data grouping
- Utilize advanced analytics features such as Quick Insights and AI Insights