Address
Level 8/25 Restwell Street, Bankstown NSW 2200, Australia
Business Hours
Monday to Friday: 10AM - 6PM
Weekend: CLOSED
PL-300T00: Design and manage analytics solutions using Power BI
This intermediate course shows data analysts how to design and manage analytics solutions with Microsoft Power BI. You’ll learn to connect to and prepare data with Power Query, build and optimise semantic models with DAX, and create interactive reports and dashboards that tell a clear story. It also covers managing workspaces, security and data refresh, and using Copilot to speed up your work. It prepares you for the Microsoft Certified: Power BI Data Analyst Associate (PL-300) exam.
Duration
24 hours (3 days)
Modules
5 Modules
Course type
Microsoft
Course Overview
This intermediate-level course is designed for data professionals and business intelligence practitioners who want to learn how to model, visualize, and analyze data using Power BI. Learners will explore data preparation from various sources, build effective data models, design impactful reports, and manage report distribution and security. The course prepares candidates for the Power BI Data Analyst Associate certification.
Before You Begin
- Experience with data analysis and visualization concepts
- Familiarity with Microsoft Excel or similar tools
- Basic understanding of databases and data models
- Interest in business intelligence and reporting
Key outcomes
- Connect & Transform Data Integrate and shape data from multiple sources.
- Model with DAX Build relationships and use DAX for calculations.
- Design & Visualize Reports Create advanced visuals for impactful storytelling.
- Secure & Share Content Manage access and deploy dashboards organization-wide.
Tools you’ll use
Power Query Editor
DAX (Data Analysis Expressions)
Skills you’ll gain
- Data Preparation Techniques
- Power BI Modeling
- Report Design Strategy
- Interactive Visuals Creation
- Row-Level Security
- Data Governance Controls
- Content Sharing Management
- Power BI Optimization
What You’ll Learn
5 modules
1Lesson 1: Get Started with Microsoft Data Analytics
Module 1: Discover Data Analysis Module 2: Get Started Building with Power BI Module 3: Introduction to End-to-End Analytics Using Microsoft Fabric Module 4: Get Started with Copilot in Power BI
2Lesson 2: Prepare Data for Analysis with Power BI
Module 1: Get Data in Power BI Module 2: Clean, Transform, and Load Data in Power BI Module 3: Choose a Power BI Model Framework
3Lesson 3: Model Data with Power BI
Module 1: Configure a Semantic Model Module 2: Write DAX Formulas for Semantic Models Module 3: Create DAX Calculations in Semantic Models Module 4: Modify DAX Filter Context in Semantic Models Module 5: Use DAX Time Intelligence Functions in Semantic Models Module 6: Create Visual Calculations in Power BI Desktop Module 7: Optimize a Model for Performance in Power BI
4Lesson 4: Design Effective Reports in Power BI
Module 1: Scope Report Design Requirements Module 2: Design Power BI Reports Module 3: Enhance Power BI Report Designs for the User Experience Module 4: Perform Analytics in Power BI
5Lesson 5: Manage and Secure Power BI
Module 1: Manage Workspaces in Power BI Service Module 2: Manage Semantic Models in Power BI Module 3: Choose a Content Distribution Method Module 4: Create Dashboards in Power BI Module 5: Secure Data Access in Power BI
Certification & Credentials
Certificate track
24 hours (3 days)
Target Audience
Intended roles
- Business Intelligence Analyst
- Data Analyst
- Finance Analyst
- Supply Chain Analyst
Frequently asked questions
Is this course suitable for beginners?
No, it’s intended for users with basic data analysis experience.
What certification does this course support?
It supports the Power BI Data Analyst Associate certification.
Will I learn DAX in this course?
Yes, DAX is covered for data modeling and calculations.
Are hands-on labs included?
Yes, labs are integrated throughout the course.
Can I take this course online?
Yes, both instructor-led and self-paced formats are available.
| Duration | 24 hours (3 days) |
|---|---|
| Modules | 5 Modules |
| Course type | Microsoft |
| Category | Microsoft |
| Intended roles | Business Intelligence Analyst, Data Analyst, Finance Analyst, Supply Chain Analyst |
| Prerequisites | Experience with data analysis and visualization concepts, Familiarity with Microsoft Excel or similar tools, Basic understanding of databases and data models, Interest in business intelligence and reporting |
Be the first to review “PL-300T00: Design and manage analytics solutions using Power BI”
Reviews
There are no reviews yet.