DP-605: Develop Dynamic Reports with Microsoft Power BI

Course Description:

Overview

• Develop dynamic reports and dashboards using Microsoft Power BI
• Connect to and transform data from a wide variety of sources
• Design semantic models, measures, and calculated columns
• Apply advanced filtering and visualization techniques
• Manage workspaces and configure report sharing and performance

Audience Profile

• Data analysts and business intelligence professionals
• IT specialists and Power BI users seeking advanced reporting skills
• Managers and team leaders using Power BI to make data-driven decisions

Prerequisites

• Familiarity with basic data concepts and terminology
• Some exposure to Power BI is helpful, but not required

Module 1: Get 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
• Exercise — Prepare data in Power BI Desktop

Module 2: Clean, 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
• Exercise — Load data in Power BI Desktop

Module 3: Design a semantic model in Power BI

• Work with tables
• Create a date table
• Work with dimensions
• Define data granularity
• Work with relationships and cardinality
• Resolve modeling challenges
• Exercise — Model data in Power BI Desktop

Module 4: Add measures to Power BI Desktop models

• Create simple measures
• Create compound measures
• Create quick measures
• Compare calculated columns with measures
• Check your knowledge
• Exercise — Create DAX Calculations in Power BI Desktop

Module 5: Add calculated tables and columns to Power BI Desktop models

• Create calculated columns
• Learn about row context
• Choose a technique to add a column

Module 6: Design Power BI reports

• Design the analytical report layout
• Design visually appealing reports
• Report objects
• Select report visuals
• Select report visuals to suit the report layout
• Format and configure visualizations
• Work with key performance indicators
• Exercise — Design a report in Power BI Desktop

Module 7: Configure Power BI report filters

• Apply filters to the report structure
• Apply filters with slicers
• Design reports with advanced filtering techniques
• Consumption-time filtering
• Select report filter techniques
• Case study — Configure report filters based on feedback

Module 8: Create and manage workspaces in Power BI

• Distribute a report or dashboard
• Monitor usage and performance
• Recommend a development life cycle strategy
• Troubleshoot data by viewing its lineage
• Configure data protection

Module 9: Manage semantic models in Power BI

• Use a Power BI gateway to connect to on-premises data sources
• Configure a semantic model scheduled refresh
• Configure incremental refresh settings
• Manage and promote semantic models
• Troubleshoot service connectivity
• Boost performance with query caching (Premium)

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation