Develop Dynamic Reports With Microsoft Power BI DP605 Course - United States

Develop dynamic reports with Microsoft Power BI (DP-605) Course Outline

Module 1: Get Data in Power BI

• Introduction
• 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

• Introduction
• 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

• Introduction
• 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

• Introduction
• Create Simple Measures
• Create Compound Measures
• Create Quick Measures
• Compare Calculated Columns with Measures
• Check your Knowledge

Module 5: Add Calculated Tables and Columns to Power BI Desktop Models

• Introduction
• Create Calculated Columns
• Learn about Row Context
• Choose a Technique to Add a Column

Module 6: Design Power BI Reports

• Introduction
• 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 Visualisations
• Work with Key Performance Indicators
• Exercise - Design a Report in Power BI Desktop

Module 7: Configure Power BI Report Filters

• Introduction to Designing Reports for Filtering
• Apply Filters to the Report Structure
• Apply Filters with Slicers
• Design Reports with Advanced Filtering Techniques
• Consumption-Time Filtering
• Select Report Filter Techniques

Module 8: Create and Manage Workspaces in Power BI

• Introduction
• 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

• Introduction
• 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)

Who Should Attend this Develop dynamic reports with Microsoft Power BI (DP-605)?

This course is tailored for professionals who aim to leverage the robust capabilities of Microsoft Power BI in their organisation’s data management and analysis efforts. However, this training will be especially beneficial for:

• Business Analysts
• Data Analysts
• Project Managers
• BI and Reporting Managers
• IT Professionals
• Marketing Managers
• Financial Analysts

Prerequisites of the Develop dynamic reports with Microsoft Power BI (DP-605) Course?

Delegate should have a basic understanding of data management and Microsoft Excel functions. Familiarity with business intelligence tools and database structures is beneficial.

Develop dynamic reports with Microsoft Power BI (DP-605) Course Overview

Develop Dynamic Reports with Microsoft Power BI (DP-605) is a focused training program designed to empower professionals with the capabilities to build and manage interactive reports using Microsoft Power BI. This course emphasises the vital skills needed to transform raw data into compelling visual narratives that drive business decisions. Through this training, organisations can expect to see an enhancement in their ability to understand complex data through accessible and actionable reports. For individuals, it provides a robust foundation in data visualisation techniques and the strategic use of Power BI tools, improving their analytical skills and career prospects.   

During this training course, delegates will learn to master the functionalities of Power BI, from data integration and real-time dashboard creation to developing comprehensive dynamic reports that adapt to evolving business needs.  Delegate will engage in practical exercises to gain hands-on experience in report design and deployment, ensuring they can apply their skills immediately in their professional roles. This training will be delivered by seasoned experts in data visualisation and business intelligence, providing a learning experience grounded in real-world applications.

Course Objectives

• To acquire skills in sourcing data from diverse origins
• To master data cleaning, transforming, and loading processes
• To develop advanced data modeling and semantic models
• To create and manage dynamic and interactive reports
• To implement data analysis expressions and measures
• To design and customise powerful data visualisations
• To effectively manage and optimise Power BI environments

After attending this training, delegates will be equipped to handle the end-to-end process of data reporting with Power BI. They will be able to extract and integrate data from various databases and online services, transform raw data into a structured form, and create meaningful visual representations that provide actionable insights. Delegates will also learn to design reports that are not only visually appealing but also interactive, with the ability to apply advanced filtering and slicer techniques for tailored data exploration.

What’s included in this Develop dynamic reports with Microsoft Power BI DP605 Course?

• World-Class Training Sessions from Experienced Instructors
• Develop dynamic reports with Microsoft Power BI DP605 Course Certificate
• Digital Delegate Pack