Power BI Made Simple with AI – One Day to a Dashboard

Funding Validity Period

Course Overview

This course is designed for learners who want to quickly master how Power BI works and discover how AI assistance can make creating dashboards faster and easier. It will also equip you with the practical skills to use Power BI as a powerful tool for data analytics, with a special focus on integrating Copilot Chat.

Skills Acquired

By the end of this course, learners will be able to:

Understand Power BI's interface and core functionalities, from data ingestion to basic visualisation.
Learn how to clean and shape raw data using Power Query and create a robust data model for accurate analysis.
Master the art of designing visually appealing and interactive dashboards that tell a clear story with data.
Explore how to use Copilot Chat as an AI assistant to generate queries.
Understand the steps involved in publishing your reports to the Power BI Service.

Learning Modules

Learning Unit 1: Introduction

What is Power BI Desktop
Key Features of Power BI
Installing Power BI Desktop

Learning Unit 2: Orientation & AI in Power BI

Navigating Around Power BI Desktop
Refresh in Power BI Desktop
The Power BI Workflow
Setting Up Default Font and Font Size
Power BI Page View Options
Default Page Size in Power BI
Power BI Settings – Why They’re Needed
Where AI Fits in Power BI

Learning Unit 3: Import & Transform Data with AI

Importing & Transforming Data
Data Cleaning (Power Query Editor)
Using AI Feature – Generate Email Address
Using AI Feature – Split a Name into First Name and Last Name
Add Year Column Using Date Tools in Power Query

Learning Unit 4: Build Your First Measures

Creating Basic Measures
Quick Measures in Power BI

Learning Unit 5: Visuals Made Simple

Introduction to Visuals
Basic Visuals
Building a Simple Visual
Formatting Basics
Interactivity Between Visuals
Building Your First Dashboard
Aligning Visuals in Power BI
Let’s Try It!
Dashboard Assembly in a Minute
Refresh in Power BI Desktop

Learning Unit 6: AI Assistance in Action

AI Features in Power BI (Built-In)
a. Generate Column from Examples
b. AI-Assisted Data Transformation
c. Q&A Natural Language
d. Smart Narratives
e. Decomposition Tree
Using Chat Interface
a. Build & Explain Visuals Using Natural Language
b. Prompt AI to Create DAX Measures
c. Ask AI to Suggest Formulas or KPIs

Learning Unit 7: Sharing & Publishing Your Dashboard

Power BI Analysis Services
Create Reports on Workplace
Creating a Dashboard in Power BI Service

No data was found

Who is this course is for

This course is ideal for business professionals, those who are familiar with Microsoft Excel and wish to enhance their skill with AI, and anyone who needs to create, analyse, and share data insights at work.

Academic prerequisites

Course Fees

Fees	Company / Self Sponsored
Full Fee	$400
GST	$36
Nett Fee Payable (incl. GST)	$436