Course Description: 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-leading data visualization tools. It is aimed at data professionals, business analysts, and developers. and anyone interested in leveraging Power BI to transform raw data into engaging visual stories.

Intermediate - Data Analyst - Microsoft Fabric - Power BI

Goals

• 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
• Setting up Power BI report filters
• Managing workspaces and semantic models in Power BI

Items in this collection

Getting data into Power BI

You will learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data warehouses. You will also learn how to improve performance during data retrieval.

Clean, transform and load data in Power BI

Power Query has a wealth of features dedicated to helping you clean and prepare your data for analysis. You'll learn how to simplify a complicated model, change data types, rename objects, and pivot data. You'll also learn how to profile columns so you know which columns have the important data you're looking for to perform deeper analysis.

Designing a semantic model in Power BI

The process of creating a complex semantic model in Power BI is straightforward. If your data comes from more than one transactional system, before you know it you’ll have dozens of tables to work with. Getting a good semantic model is all about simplifying that clutter. A star schema is one way to simplify a semantic model, and in this module you’ll learn its terminology and implementation. You’ll also discover the importance of choosing the right data granularity for the performance and usability of your Power BI reports. Finally, you’ll learn how to improve performance with your Power BI semantic models.

Add measures to Power BI Desktop models

In this module, you will learn how to work with implicit and explicit measures. You will start by creating simple measures, which summarize a single column or table. Next, you will create more complex measures based on other measures in the model. In addition, you will learn about the similarities and differences between a calculated column and a measure.

Adding tables and calculated columns to Power BI Desktop models

By the end of this module, you will be able to add tables and calculated columns to a semantic model. You will also be able to describe the context of a row, which is used to evaluate formulas in calculated columns. Since columns can be added to a table using Power Query, you will also learn when it is best to create calculated columns instead of Power Query custom columns.

Power BI Report Design

As Power BI comes with over 30 core visuals, it can be difficult for a beginner to select the right one. This module will guide you through selecting the most suitable visual type to meet your report design requirements.

Setting up Power BI report filters

Report filtering is a complex topic because there are many techniques available to filter a Microsoft Power BI report. But complexity brings control, allowing you to design reports that meet requirements and expectations. Some filtering techniques are applied at design time, while others are appropriate at report consumption time (in reading view). The important thing is that the design of the report allows consumers to intuitively focus on the data points they are interested in.

Creating and managing workspaces in Power BI

Learn how to navigate the Power BI service, create and manage workspaces and related items, and distribute reports to users.

Managing semantic models in Power BI

With Microsoft Power BI, you can use a single semantic model to build many reports. Further reduce administrative overhead with scheduled semantic model updates and resolving connectivity errors.

Prerequisites

No requirements

Language

• Course: English / Spanish
• Labs: English / Spanish