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.
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
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.