Classes Data & Analytics
DP-605 Microsoft Technical Partner Delivered
DP-605 Prepare and visualize data with Microsoft Power BI
- 1 days
- 2 upcoming dates
- 2 guaranteed to run
- May qualify for CEU/PDU credit
Upcoming dates
All times shown in the class's own timezone. 2 of 2 are guaranteed to run, meaning they go ahead regardless of enrollment.
| Dates | Starts | Where | Status | Seat | Book |
|---|---|---|---|---|---|
| Thu, Oct 8 | 9:00 AM to 5:00 PM EDT | Live virtual | GUARANTEED | $695 | |
| Mon, Nov 30 | 9:00 AM to 5:00 PM EST | Live virtual | GUARANTEED | $695 |
About this class
We have 2 scheduled dates of DP-605 Prepare and visualize data with Microsoft Power BI, from Thu, Oct 8 through Mon, Nov 30. Every one is guaranteed to run regardless of enrollment. Seats are $695 each over 1 day, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.
This course is designed as an
introduction to Power BI for data analysis and reporting. Skills include connecting to data and basic data preparation tasks using Power Query, designing report pages for optimal user experience, and exploring how Copilot in Power BI aids the report development process.
Course outline
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
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
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
Module 4 Add measures to Power BI Desktop models
- Create simple measures
- Create compound measures
- Create quick measures
- Compare calculated columns with measures
Module 5 Add calculated tables and columns to Power BI
- 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
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
- 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)
Before you attend
Basic understanding of Data Analytics and Power BI
Who this is for
This course is intended for professionals interested in transforming data into interactive reports using Power BI to deliver insights and support decision-making. No prior experience with Power BI is required.
How reserving works. Your card is authorized, not charged. We confirm the seat with the training center, usually within one business day, and take payment only once it is held. If the class turns out to be full we release the authorization and you are not charged.
Request a quote
Tell us how many people and roughly when. We'll come back with dates, seat price, and a total by the end of the next business day.