DP-605T00: Prepare and Visualize with Microsoft Power BI
Price
$900.00 (AUD) $900.00 (NZD)
Duration
1 Day
Modality
Live Online
Course code
DP-605T00
Course Overview
This one-day instructor-led course is designed for data professionals who aim to develop dynamic reports using Microsoft Power BI. Participants will learn to connect to various data sources, transform and shape data, design semantic models, create interactive visualisations, and effectively distribute reports.
Target Audience
xxxxx
Prerequisites
There are no prerequisites for taking this course however, familiarity with data and analytics concepts. Completion of the 'Get Started with Microsoft Data Analytics' module is recommended.
Target Audience
xxxxx
Prerequisites
There are no prerequisites for taking this course however, familiarity with data and analytics concepts. Completion of the 'Get Started with Microsoft Data Analytics' module is recommended.
Module Breakdown - For a course module breakdown click here
Module 1: Get Data in Power BI
Connect to data from files, relational databases, NoSQL databases, and online services.
Select appropriate storage modes.
Address performance issues and resolve data import errors.
Module 2: Clean, Transform, and Load Data in Power BI
Utilise Power Query to clean and prepare data.
Simplify data models, change data types, and pivot data.
Profile columns to identify valuable data.
Module 3: Design a Semantic Model in Power BI
Organise complex data into intuitive structures using semantic models.
Implement star schemas and define data granularity.
Improve performance with optimised semantic models.
Module 4: Add Measures to Power BI Desktop Models
Create simple and complex measures using DAX.
Understand the differences between calculated columns and measures.
Module 5: Add Calculated Tables and Columns to Power BI Desktop Models
Add calculated tables and columns to enhance data models.
Describe row context and its application in calculated columns.
Module 6: Design Power BI Reports
Design visually appealing and easy-to-understand reports.
Incorporate interactive objects and filtering mechanisms.
Select appropriate visuals to meet report requirements.
Module 7: Configure Power BI Report Filters
Apply various filtering techniques at design and consumption time.
Design reports that allow intuitive data exploration for end-users.
Module 8: Create and Manage Workspaces in Power BI
Navigate the Power BI service to create and manage workspaces.
Distribute reports and dashboards to users.
Monitor usage and performance metrics.
Module 9: Manage Semantic Models in Power BI
Utilise Power BI gateways to connect to on-premises data sources.
Configure scheduled and incremental refresh settings.
Manage and promote semantic models within the Power BI service.
Class Schedule
Looking for other dates? Prefer a quote? Let us know:
