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.
Course info
Rating
(15)
Level
Beginner
Updated
Mar 29, 2019
Duration
4h 57m
Table of contents
Course Overview
Using the Query Editor to Prepare a Power BI Data Model
Exploring Additional Techniques in the Power BI Query Editor
Enhancing a Power BI Model with Relationships and Hierarchies
Improving the Data Model for Reporting
Using DAX to Enhance a Power BI Model
Working with Dates and Time in Power BI
Applying Evaluation Context
Description
Course info
Rating
(15)
Level
Beginner
Updated
Mar 29, 2019
Duration
4h 57m
Description

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.

About the author
About the author

Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections conferences, and various SQL Saturday and Microsoft-related events worldwide.

More from the author
Building Your First Power BI Report
Beginner
1h 37m
Jun 3, 2019
More courses by Stacia Misner Varga
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello. I'm Stacia Varga, and welcome to the Modeling Data in Power BI course. I work with data all the time as a consultant, helping my clients use and understand their data and as an instructor and author, teaching people how to build data solutions and work with data effectively. The whole point of using Power BI is to enable the exploration and visualization of data whether you're doing this for yourself or for others. Because data in its raw form is not often suitable for this purpose, you need to create a data model that refines and enriches this data to make it more useful and understandable. There are a lot of steps involved in data modeling for Power BI, and Power BI is certainly packed with lots of features for data modeling. In this course, I'll show you how to start with a set of files and incrementally refine and enhance that data to produce a better data model. We'll start by loading data into a model and then shaping and cleansing the data, and we'll learn how the structure of the data model affects how the data displays and see how incremental changes improve the model structure, not only for reporting, but also to take advantage of special Power BI features for geospatial analysis and natural language queries. We'll also learn how to enhance the model with various types of calculations that transform raw data into information. By the end of this course, you'll know how to apply a variety of techniques in Power BI to model your own data. From here, you can continue learning more about Power BI by viewing other Pluralsight courses on Power Query, DAX, and several other courses covering different aspects of using Power BI. Although you don't need to know any programming or data query languages before you start this course, some familiarity with basic data analysis is helpful. Let's get started on this Power BI journey with the Modeling Data in Power BI course here, at Pluralsight.