Modeling Data in Power BI
Learn how to work with data that comes from different sources and is structured in different ways by using Power BI transformations to combine, reshape, cleanse, and enhance that data to create a model that supports reporting and analytics.
Data in its raw form is rarely useful for reporting and analysis. In this course, Modeling Data in Power BI, you’ll learn how to use Power BI to transform raw data into meaningful insights. First, you’ll learn how to gather data and apply transformations to easily blend multiple sources together, reduce the data to its most useful elements, and prepare the data for exploration. Next, you’ll discover how to configure the model to support Power BI features for insightful visualizations, geospatial analysis, and natural language queries. Finally, you’ll explore the basics of DAX, Power BI’s expression language, to add calculations to your model. When you’re finished with this course, you’ll have the skills and knowledge of Power BI data modeling that you can use to build your own models that support a variety of analytical requirements and take full advantage of Power BI’s capabilities.
Author Name: Stacia Misner Varga
Author Description:
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.
Table of Contents
- Course Overview
2mins - Loading Data
42mins - Exploring Additional Techniques in the Power Query Editor
64mins - Enhancing a Power BI Model with Relationships and Hierarchies
39mins - Improving the Data Model for Reporting
38mins - Using DAX to Enhance a Power BI Model
45mins - Working with Dates and Time in Power BI
29mins - Applying Evaluation Context
35mins
There are no reviews yet.