DP-605: Develop Dynamic Reports with Microsoft Power BI

DP-605 Course: 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 necessary 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 compelling visual stories.

Intermediate - Data Analyst - Microsoft Fabric - Power BI

DP-605 Training Objectives

• Identifying and connecting the data source
• Optimizing data recovery
• Data cleansing and transformation
• Advanced data management
• Designing semantic models in Power BI
• Implementing measures in Power BI models
• Creating tables and calculated columns
• Power BI Report Design
• 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
  
• Power BI Service Tour and Usage
  

Module 2 Getting data into Power BI

• Obtaining data from files
  
• Getting data from relational data sources
  
• Creating dynamic reports with parameters
  
• Getting data from a NoSQL database
  
• Obtaining data from online services
  
• Select a storage mode
  
• Get data from Azure Analysis Services
  
• Fix performance issues
  
• Resolving data import errors
  
• Exercise: Preparing data in Power BI Desktop

Module 3: Clean, transform, and load data into Power BI

• Form of the initial data
  
• Simplifying the 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
  
• Create a date table
  
• Using dimensions
  
• Defining data granularity
  
• Working with relationships and cardinality
  
• Solving modeling challenges
  
• Exercise: Data Modeling in Power BI Desktop

Module 6: Power BI Report Design

• Specifying the analytical report design
  
• Designing visually appealing reports
  
• Report objects
  
• Selecting report visuals
  
• Selecting report visuals tailored to the report design
  
• Format and configuration of displays
  
• Using key performance indicators
  
• Exercise: Designing a Report in Power BI Desktop

Module 7: Creating Interactive Reports with Copilot for Power BI

• Prepare your data for use with Copilot for Power BI
  
• Use Copilot for Power BI to model your data
  
• Create reports with Copilot for Power BI
  
• Create summaries with Copilot for Power BI

Module 8 Introduction to End-to-End Analysis 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 data and analytics concepts.

Language

• Course: English / Spanish