Microsoft DP-605T00 - Prepare and Visualise Data with Microsoft Power BI

DP-605T00: Prepare and Visualise Data with Microsoft Power BI is an instructor-led training course designed for professionals who want to develop practical skills in data preparation, modelling, visualisation, and reporting using Microsoft Power BI. The course provides hands-on experience working with business data, enabling participants to transform raw information into meaningful insights that support informed decision-making and business performance improvement.

As organisations increasingly rely on analytics and reporting to drive growth and operational efficiency, Power BI has become one of the leading business intelligence platforms for data analysis and visualisation. This course equips participants with the knowledge required to prepare data, build effective data models, and create interactive reports that deliver actionable business insights.

A major focus of the training is data acquisition and preparation using Power Query. Participants learn how to connect to multiple data sources, including spreadsheets, databases, cloud services, and business applications. Through practical exercises, learners gain experience cleaning, transforming, combining, and shaping data to ensure accuracy and consistency before analysis.

The course also covers data modelling fundamentals within Power BI. Participants learn how to create relationships between tables, build semantic models, develop hierarchies, and apply best-practice modelling techniques to support scalable and reliable reporting environments.

Data Analysis Expressions (DAX) are introduced throughout the curriculum, enabling participants to create calculated measures, business metrics, and analytical calculations that support deeper insights. These skills help organisations track performance, monitor trends, and measure key business outcomes.

Visualisation and report design are key components of the course. Learners discover how to build interactive dashboards, reports, and visual experiences using Power BI Desktop. Topics include selecting appropriate visualisations, implementing drill-through functionality, applying filtering options, improving report usability, and designing reports that communicate information effectively to stakeholders.

The training also explores analytical capabilities within Power BI, including data exploration, trend analysis, interactive reporting, and AI-powered features. Participants gain an understanding of how modern analytics tools help organisations uncover patterns, identify opportunities, and support evidence-based decision-making.

Managing and sharing Power BI content is another important area of study. Participants learn how to publish reports to the Power BI Service, manage workspaces, configure refresh schedules, share content securely, and implement governance controls such as Row-Level Security (RLS) and permissions management.

Through instructor-led demonstrations, guided labs, and practical business scenarios, participants develop real-world Power BI skills that can be applied immediately within reporting, analytics, and business intelligence roles. The course also provides a strong foundation for professionals pursuing advanced Power BI and Microsoft analytics certifications.

This course is ideal for Data Analysts, Business Analysts, Reporting Specialists, Business Intelligence Professionals, Finance Analysts, Operations Professionals, Power BI Users, and anyone responsible for preparing data and creating reports. Training is available across Melbourne, Sydney, Brisbane, Adelaide, Perth, and Canberra, as well as through live online delivery throughout Australia. A Certificate of Attendance is included upon completion.