Prepare and visualize data with Microsoft Power BI (DP-605)

Course Outline

1) Get started building with Power BI
• How Power BI services and applications work together
• Explore how Power BI can make your business more efficient
• How to create compelling visuals and reports

2) Get data in Power BI
• 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
• Lab: Prepare data in Power BI Desktop

3) Clean transform and load data in Power BI
• Resolve inconsistencies, unexpected or null values, and data quality issues
• Apply user-friendly value replacements
• Profile data so you can learn more about a specific column before using it
• Evaluate and transform column data types
• Apply data shape transformations to table structures
• Combine queries
• Apply user-friendly naming conventions to columns and queries
• Edit M code in the Advanced Editor
• Lab: Load data in Power BI Desktop

4) Design a semantic model in Power BI
• Create common date tables
• Configure many-to-many relationships
• Resolve circular relationships
• Design star schemas
• Lab: Model data in Power BI Desktop

5) Design Power BI reports
• Learn about the structure of a Power BI report
• Learn about report objects
• Select the appropriate visual type to use
• Lab: Design a report in Power BI desktop

6) Create interactive reports using Copilot for Power BI
• Design semantic model
• Create visuals and reports
• Create summaries

7) Introduction to endtoend analytics using Microsoft Fabric
• Describe end-to-end analytics in Microsoft Fabric