Australian Consulting group for Artificial Intelligence and Innovation
Business Intelligence with Power BI
This course provides a comprehensive introduction to Microsoft Power BI, one of the most widely used data analytics and business intelligence tools in the industry. Through interactive sessions and hands-on projects, participants will learn to connect, transform, model, and visualise data effectively. The course is designed to help learners build insightful dashboards and share actionable business insights using Power BI tools.
In this course, you will:
1. Learn how to load and clean data using Power Query Editor.
2. Create relationships and build robust data models.
3. Develop interactive dashboards using a range of Power BI visualisations.
4. Write custom calculations and metrics using DAX (Data Analysis Expressions).
5. Learn how to publish and share reports securely via Power BI Service.
This course is beginner-friendly and does not require prior experience in data analysis. Familiarity with Excel or basic data handling is helpful but not necessary.
Build practical skills in data visualisation, reporting, and decision-making using Power BI.
Topics
Power BI Modules
Skills & Tools
Introduction to Power BI
Connecting to Excel, CSV, SQL
Data Cleaning with Power Query
Merge, Append, Transformations
Data Modelling
Relationships, Star Schema
Introduction to DAX
Calculated Columns, Measures
Visualisations in Power BI
Charts, Slicers, Maps, Cards
Interactive Dashboards
Filters, Drill-down, Bookmarks
Advanced DAX
Time Intelligence, KPI Measures
Publishing to Power BI Service
Workspaces, Sharing Reports
Security and Access Control
Row-Level Security
*Course content may be adjusted to reflect the latest Power BI updates.
This 2-day course includes 3-hour sessions. Each session combines a 1-hour interactive lecture with a 2-hour guided hands-on lab. Participants are encouraged to bring their own laptops with Power BI Desktop installed.
Open for enrolment throughout the year. Our next intake begins on Saturday 9th August, 2025.
Please email us the enrolment form at info@acaii.com.au to reserve your spot.
Enrolment Fee (non-refundable) - $100 per person
In-person group sessions (minimum group size: 5) - $999 per person
Online session (minimum group size: 5) - $999 per person
Course Completion Certificate - Participants will receive a certificate upon course completion.
The course is delivered both in-person and online. In-person classes run on Saturdays from 9:00AM to 12:00PM. Online sessions are available on weekday evenings after 5:00PM with flexible scheduling options.