XYZ AI
JL3000: AI in BioTech
DP-203T00: Data Engineering on Microsoft Azure
AI-900T00: Microsoft Azure AI Fundamentals
AZ-400T00: Designing and Implementing Microsoft DevOps Solutions
AZ-204T00: Developing Solutions for Microsoft Azure
AZ-104T00: Microsoft Azure Administrator
AZ-900T00: Microsoft Azure Fundamentals
PL-300T00: Design and Manage Analytics Solutions Using Power BI
This course will discuss how to manage data sources, clean and transform data, create reports and dashboards, and manage workspaces and datasets. You will also learn how to design and create data models, and how to use DAX to create calculations and measures. This course will prepare you for the Microsoft Power BI Data Analyst Associate certification exam.
Prices exclude taxes. Early bird discounts available. Contact us for group pricing.
Upcoming Schedules
Request for More Information
Corporate / Onsite Training
Deliver this course at your location or virtually for your team. Customizable content, flexible dates, and volume discounts available.
- Dedicated instructor
- Customized agenda
- Hands-on labs included
- Post-training support
- Certification guidance
- Team progress reports
Course Instructors
Related Courses
Course Outline
- Get Started with Microsoft Data Analytics – Overview of Power BI, data roles, and the analytics process.
- Prepare Data in Power BI – Connect to data sources, clean and transform data using Power Query.
- Model Data in Power BI – Design a data model, create relationships, and implement star schema.
- Create DAX Calculations – Write measures, calculated columns, and use time intelligence functions.
- Create Reports – Build interactive reports, apply filters, and use advanced visuals.
- Create Dashboards – Design dashboards, pin tiles, and configure mobile views.
- Create Paginated Reports – Introduction to paginated reports and Power BI Report Builder.
- Perform Advanced Analytics – Use AI visuals, key influencers, and decomposition trees.
- Create and Manage Workspaces – Publish content, manage access, and use deployment pipelines.
- Manage Datasets and Dataflows – Configure refresh, gateways, and dataflows.
Course Curriculum
- Overview of data analysis and Power BI
- Roles in data analytics
- Power BI ecosystem and tools
- Lab: Explore Power BI Desktop
- Get data from various sources
- Clean and transform data with Power Query
- Combine and shape data
- Lab: Prepare data for analysis
- Design a data model
- Create relationships and hierarchies
- Optimize model performance
- Lab: Create a star schema model
- Introduction to DAX
- Create calculated columns and measures
- Time intelligence functions
- Lab: Write advanced DAX formulas
- Design interactive reports
- Apply filters, slicers, and bookmarks
- Create dashboards and mobile layouts
- Lab: Build a complete report
- Publish and share content
- Configure workspaces and apps
- Manage dataset refresh and gateways
- Lab: Deploy and manage content
Student Reviews
Excellent course! The instructor explained DAX concepts very clearly and the hands-on labs were extremely helpful. I cleared the PL-300 exam on my first attempt.
Very practical and well-structured. The corporate training for our team was customized perfectly. Highly recommended for anyone serious about Power BI.
Great content and real-world examples. The only suggestion would be to add more advanced visualization techniques. Overall a solid course.
Best Power BI training I have attended. The instructor was knowledgeable and patient. Labs covered everything from data modeling to deployment.