DP-605 | Prepare and visualize data with Microsoft Power BI
 
Power BI allows you to easily connect to and present your data in an interactive report, so you can make data-driven decisions. Learn how to connect to data, transform and shape data, and create interactive visuals in a Power BI report.
 
Prerequisites
Before starting this learning path, you should be familiar with data and analytics concepts.
 
Role
Data Analyst
 
Course Outline
Module 1: Get started building with Power BI
Learn about Power BI, the building blocks and flow of Power BI, and how to create compelling, interactive reports.
Introduction
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
Knowledge check
Summary
Module 2: Get data in Power BI
You'll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data.
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
Check your knowledge
Summary
Module 3: Clean, transform, and load data in Power BI
Power Query has an incredible number of features that are 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 that you know which columns have the valuable data that you’re seeking for deeper analytics.
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
Check your knowledge
Summary
Module 4: Design a semantic model in Power BI
The process of creating a complicated semantic model in Power BI is straightforward. If your data is coming in from more than one transactional system, before you know it, you can have dozens of tables that you have to work with. Building a great semantic model is about simplifying the disarray. A star schema is one way to simplify a semantic model, and you learn about the terminology and implementation of them in this module. You will also learn about why choosing the correct data granularity is important for performance and usability of your Power BI reports. Finally, you learn about improving performance with your Power BI semantic models.
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
Check your knowledge
Summary
Module 5: Design Power BI reports
Because Power BI includes more than 30 core visuals, it can be challenging for a beginner to select the correct visual. This module will guide you through selecting the most appropriate visual type to meet your design and report layout requirements.
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 visualizations
Work with key performance indicators
Exercise - Design a report in Power BI desktop
Check your knowledge
Summary
Module 6: Create interactive reports using Copilot for Power BI
Copilot for Power BI uses Generative AI to simplify data visualization and create reports, making Power BI more insightful and accessible.
Introduction
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
Knowledge check
Summary
Module 7: Introduction to end-to-end analytics using Microsoft Fabric
Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Learn about Microsoft Fabric, how it works, and identify how you can use it for your analytics needs.
Introduction
Explore end-to-end analytics with Microsoft Fabric
Data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Knowledge Check
Summary
 
Descargue el temario para conocer el detalle completo de los contenidos.
 
Debido a las constantes actualizaciones de los contenidos de los cursos por parte del fabricante, el contenido de este temario puede variar con respecto al publicado en el sitio oficial, sin embargo, Netec siempre entregará la versión actualizada de éste.