Getting data into Power BI
You will learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data warehouses. You will also learn how to improve performance during data retrieval.
Clean, transform and load data in Power BI
Power Query has a wealth of features dedicated to helping you clean and prepare your data for analysis. You'll learn how to simplify a complicated model, change data types, rename objects, and pivot data. You'll also learn how to profile columns so you know which columns have the important data you're looking for to perform deeper analysis.
Designing a semantic model in Power BI
The process of creating a complex semantic model in Power BI is straightforward. If your data comes from more than one transactional system, before you know it you’ll have dozens of tables to work with. Getting a good semantic model is all about simplifying that clutter. A star schema is one way to simplify a semantic model, and in this module you’ll learn its terminology and implementation. You’ll also discover the importance of choosing the right data granularity for the performance and usability of your Power BI reports. Finally, you’ll learn how to improve performance with your Power BI semantic models.
Add measures to Power BI Desktop models
In this module, you will learn how to work with implicit and explicit measures. You will start by creating simple measures, which summarize a single column or table. Next, you will create more complex measures based on other measures in the model. In addition, you will learn about the similarities and differences between a calculated column and a measure.
Adding tables and calculated columns to Power BI Desktop models
By the end of this module, you will be able to add tables and calculated columns to a semantic model. You will also be able to describe the context of a row, which is used to evaluate formulas in calculated columns. Since columns can be added to a table using Power Query, you will also learn when it is best to create calculated columns instead of Power Query custom columns.
Power BI Report Design
As Power BI comes with over 30 core visuals, it can be difficult for a beginner to select the right one. This module will guide you through selecting the most suitable visual type to meet your report design requirements.
Setting up Power BI report filters
Report filtering is a complex topic because there are many techniques available to filter a Microsoft Power BI report. But complexity brings control, allowing you to design reports that meet requirements and expectations. Some filtering techniques are applied at design time, while others are appropriate at report consumption time (in reading view). The important thing is that the design of the report allows consumers to intuitively focus on the data points they are interested in.
Creating and managing workspaces in Power BI
Learn how to navigate the Power BI service, create and manage workspaces and related items, and distribute reports to users.
Managing semantic models in Power BI
With Microsoft Power BI, you can use a single semantic model to build many reports. Further reduce administrative overhead with scheduled semantic model updates and resolving connectivity errors.
