DP-605: Develop Dynamic Reports with Microsoft Power BI

Course DP-605: Develop Dynamic Reports with Microsoft Power BI

Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.

This course is designed to provide participants with the skills and knowledge needed to create dynamic and interactive reports using Microsoft Power BI, one of the industry's leading data visualization tools. It is aimed at data professionals, business analysts, and anyone interested in leveraging Power BI to transform raw data into engaging visual stories.

Intermediate - Data Analyst - Microsoft Fabric - Power BI

DP-605 Training Objectives

• Data source identification and connection
• Data retrieval optimization
• Data cleaning and transformation
• Advanced data handling
• Designing semantic models in Power BI
• Implementing measures in Power BI models
• Creating calculated tables and columns
• Designing Power BI reports
• Configuring Power BI report filters
• Managing workspaces and semantic models in Power BI

DP-605 Course Content

Module 1 Introduction to creating with Power BI

• Using Power BI
  
• Power BI building blocks
  
• Tour and use of the Power BI service
  

Module 2 Getting data into Power BI

• Getting data from files
  
• Getting data from relational data sources
  
• Creating dynamic reports with parameters
  
• Getting data from a NoSQL database
  
• Getting data from online services
  
• Selecting a storage mode
  
• Getting data from Azure Analysis Services
  
• Fixing performance issues
  
• Resolving data import errors
  
• Exercise: Data preparation in Power BI Desktop

Module 3 Cleaning, transforming, and loading data in Power BI

• Initial data shape
  
• Simplifying data structure
  
• Evaluating and changing column data types
  
• Combining multiple tables into one
  
• Data profiling in Power BI
  
• Using the Advanced Editor to modify M code
  
• Exercise: Loading data into Power BI Desktop

Module 4 Designing a semantic model in Power BI

• Using tables
  
• Creating a date table
  
• Using dimensions
  
• Defining data granularity
  
• Working with relationships and cardinality
  
• Resolving modeling challenges
  
• Exercise: Data modeling in Power BI Desktop

Module 6 Designing Power BI reports

• Specifying analytical report design
  
• Designing visually appealing reports
  
• Report objects
  
• Selecting report visuals
  
• Selecting report visuals tailored to report design
  
• Formatting and configuring visualizations
  
• Using key performance indicators
  
• Exercise: Designing a report in Power BI Desktop

Module 7 Creating interactive reports with Copilot for Power BI

• Preparing your data for use with Copilot for Power BI
  
• Using Copilot for Power BI to model data
  
• Creating reports with Copilot for Power BI
  
• Creating summaries with Copilot for Power BI

Module 8 Introduction to end-to-end analytics with Microsoft Fabric

• Exploring end-to-end analytics with Microsoft Fabric
  
• Data teams and Microsoft Fabric
  
• Enabling and using Microsoft Fabric

Prerequisites

You should be familiar with analytics and data concepts.

Language

• Course: English / Spanish