Prepare and Visualize Data with Microsoft Power BI DP-605

Module 1Get started building with Power BI

• Use Power BI
• Building blocks of Power BI
• Tour and use the Power BI service

Module 2Get data in Power BI

• Get data from files
• Get data from relational data sources
• Create dynamic reports with parameters
• Get data from a NoSQL database
• Get data from online services
• Select a storage mode
• Get data from Azure Analysis Services
• Fix performance issues
• Resolve data import errors

Module 3Clean, transform, and load data in Power BI

• Shape the initial data
• Simplify the data structure
• Evaluate and change column data types
• Combine multiple tables into a single table
• Profile data in Power BI
• Use Advanced Editor to modify M code

Module 4Configure a semantic model

• Configure relationships
• Configure tables
• Configure columns
• Configure hierarchies
• Configure measures
• Configure parameters

Module 5Design Power BI reports

• Design the analytical report layout
• Design visually appealing reports
• Use report objects
• Select report visuals
• Apply filters and slicers to reports
• Understand filtering techniques and considerations
• Case study - Configure report filters based on feedback

Module 6Get started with Copilot in Power BI

• Use Copilot in Power BI to prepare and model data
• Create reports with Copilot in Power BI
• Get your data ready for AI usage in Power BI

Module 7Introduction to end-to-end analytics using Microsoft Fabric

• Explore end-to-end analytics with Microsoft Fabric
• Explore data teams and Microsoft Fabric
• Enable and use Microsoft Fabric