Opleiding: Develop dynamic reports with Microsoft Power BI (DP-605)
Get started with Power BI reports in one day
Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.
You'll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data.
After completing this module, you will be able to:
- Identify and connect to a data source
- Get data from a relational database, like Microsoft SQL Server
- Get data from a file, like Microsoft Excel
- Get data from applications
- Get data from Azure Analysis Services
- Select a storage mode
- Fix performance issues
- Resolve data import errors
Power Query has an incredible number of features that are 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 that you know which columns have the valuable data that you’re seeking for deeper analytics.
After completing this module, you will be able to:
- Resolve inconsistencies, unexpected or null values, and data …
