PL-300T00: Design and Manage Analytics Solutions Using Power BI
Price
$2,700.00 (AUD) $2,700.00 (NZD)
Duration
3 Days
Modality
Live Online
Course code
PL-300T00
Course Overview
This course is designed for data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using 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.
Skills Gained:
Ingest, clean, and transform data
Model data for performance and scalability
Design and create reports for data analysis
Apply and perform advanced report analytics
Manage and share report assets
Create paginated reports in Power BI
Target Audience
Data analysts, business intelligence professionals, and power users who are responsible for analysing data, building visual reports, and delivering insights using Power BI.
Specific roles include:
Data Analysts
BI Developers
Reporting Specialists
Power Users in business units using self-service BI tools
Professionals preparing for the PL-300 certification exam
Prerequisites
Before attending this course, learners should have a foundational understanding of data concepts and some experience working with data in the cloud:
Understanding of core data concepts
Experience with data modelling, basic data analysis, and working with relational data
Familiarity with cloud-based data services and tools
Basic proficiency in Microsoft Excel or similar tools is helpful but not required
Target Audience
Data analysts, business intelligence professionals, and power users who are responsible for analysing data, building visual reports, and delivering insights using Power BI.
Specific roles include:
Data Analysts
BI Developers
Reporting Specialists
Power Users in business units using self-service BI tools
Professionals preparing for the PL-300 certification exam
Prerequisites
Before attending this course, learners should have a foundational understanding of data concepts and some experience working with data in the cloud:
Understanding of core data concepts
Experience with data modelling, basic data analysis, and working with relational data
Familiarity with cloud-based data services and tools
Basic proficiency in Microsoft Excel or similar tools is helpful but not required
Module Breakdown - For a course module breakdown click here
Module 1: Get Started with Microsoft Data Analytics
Explore the role of a data analyst and how Power BI tools transform data into impactful reports and dashboards
Module 10: Implement Row-Level Security
Configure row-level security with both static and dynamic methods
Module 2: Prepare Data in Power BI
Identify and retrieve data from various data sources.
Understand the options for connectivity and data storage.
Module 3: Clean, Transform, and Load Data in Power BI
Profile and understand the condition of the data.
Perform data cleaning and transforming steps to prepare the data for loading into the model.
Module 4: Design a Data Model in Power BI
Design and develop a data model for proper performance and scalability.
Understand and tackle common data modeling issues, including relationships, security, and performance.
Module 5: Create Model Calculations using DAX in Power BI
Learn about aggregations and the concepts of Measures, calculated columns and tables, and Time Intelligence functions.
Module 6: Optimise Model Performance in Power BI
Understand steps, processes, concepts, and data modelling best practices necessary to optimize a data model for enterprise-level performance.
Module 7: Create Reports in Power BI
Design and build a report, including selecting the correct visuals, designing a page layout, and applying basic but critical functionality.
Module 8: Enhance Reports for Usability and Storytelling in Power BI
Learn about paginated reports, including what they are and how they fit into Power BI.
Build and publish a report.
Module 9: Manage Workspaces and Datasets in Power BI
Create and manage workspaces in Power BI.
Distribute reports and dashboards.
Monitor usage and performance.
Class Schedule
Looking for other dates? Prefer a quote? Let us know:
