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 needed to create dynamic and interactive reports using Microsoft Power BI , one of the industry's leading data visualization tools. It is intended for 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

Objectives of the DP-605 training

• Identification and connection of the data source
• Data recovery optimization
• Data cleansing and transformation
• Advanced data management
• Designing semantic models in Power BI
• Implementation of measures in Power BI models
• Creating calculated tables and columns
• Power BI report design
• Configuring Power BI report filters
• Managing workspaces and semantic models in Power BI

Course content DP-605

Module 1 Introduction to creating with Power BI

• Use Power BI
  
• Power BI building blocks
  
• A tour of the Power BI service and its uses
  

Module 2: Obtaining Data in Power BI

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

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

• Form of the initial data
  
• Simplifying the data structure
  
• Evaluating and changing column data types
  
• Combining several tables into one
  
• Generating data profiles in Power BI
  
• Using the Advanced Editor to modify the M code
  
• Exercise: Loading data into Power BI Desktop

Module 4 Designing a semantic model in Power BI

• Use of tables
  
• Create a table of dates
  
• Use of dimensions
  
• Definition of data granularity
  
• Working with relationships and cardinality
  
• Solving modeling challenges
  
• Exercise: Data Modeling in Power BI Desktop

Module 6: Power BI Report Design

• Analytical report design specification
  
• Design visually appealing reports
  
• Report objects
  
• Selection of report visuals
  
• Selection of report visuals adapted to the report design
  
• Format and configuration of visualizations
  
• Use of 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 the data
  
• Create reports with Copilot for Power BI
  
• Create summaries with Copilot for Power BI

Module 8 Introduction to comprehensive analysis with Microsoft Fabric

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

Prerequisites

You should be familiar with analysis and data concepts.

Language

• Course: English / Spanish