DP-605: Develop Dynamic Reports with Microsoft Power BI
Length: 1 Day(s) Cost:$895 + GST
= Scheduled class
= Guaranteed to run
= Fully booked
Click on the date to book online
Please wait as we are loading the schedules...
| LOCATION | March | April | May | June |
|---|---|---|---|---|
| Auckland | ||||
| Hamilton | ||||
| Christchurch | ||||
| Wellington | ||||
| Virtual Class |
Learn how to transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.
This course is for Data Analysts.
Basic understanding of Data Analytics and Power BI.
After completing this course, students will be able to:
- Build with Power BI
- Get data in Power BI
- Cleanse, transform, and load data in Power BI
- Design a semantic model in Power BI
- Design Power BI reports
- Create interactive reports using Copilot for Power BI
- Discover end-to-end analytics using Microsoft Fabric.
Build with Power BI
- Understand how Power BI apps and services work together.
- Explore how Power BI can make your business more efficient.
- Create engaging visuals and reports.
Get data in Power BI
- Log in and connect to a data source.
- Get data from a relational database, such as Microsoft SQL Server.
- Get data from a file, such as Microsoft Excel.
- Get app data.
- Get data from Azure Analysis Services.
- Select a storage mode.
- Troubleshoot performance issues.
- Fix data import errors.
Cleanse, transform, and load data in Power BI
- Resolve inconsistencies, unexpected or null values, and data quality issues.
- Apply user-friendly value overrides.
- Profile data to learn more about a specific column before using it.
- Evaluate and transform column data types.
- Apply data shape transformations to table structures.
- Combine queries.
- Apply user-friendly naming conventions to columns and queries.
- Edit M code in the Advanced Editor.
Design a semantic model in Power BI
- Create common date tables.
- Set up many-to-many relationships.
- Resolve circular relationships.
- Design star schematics.
Design Power BI reports
- Learn about the structure of a Power BI report.
- Learn about report objects.
- Select the appropriate type of visual to use.
Create interactive reports using Copilot for Power BI
- Design a semantic model.
- Create visuals and reports.
- Create summaries.