- Course
- Data
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.
What you'll learn
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.
Table of contents
- Overview | 2m 21s
- Supported Data Sources | 4m 35s
- Exploring Power BI Data Sources | 2m 42s
- Model Requirements | 1m 58s
- Movies Model Data | 2m 35s
- Loading Data: Movies_metadata.csv | 2m 13s
- Loading Data: Names_ak.tsv and Names_lz.tsv | 6m 59s
- Loading Data: Principals.tsv | 2m 11s
- Loading Data: Awards HTML Table | 1m 38s
- Applying Query Changes | 1m 51s
- Reviewing Query Errors | 1m 43s
- Counting Loaded Rows | 3m 58s
- Power Query Editor vs. Power BI Desktop | 4m 44s
- Assessing the State of the Model | 1m 6s
- Summary | 1m 45s
About the author
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.
More Courses by Stacia