UEN No.: 198802365N

Dashboards using Power Query

COURSE details

Course Duration

8 HRS

Mode of Training

Classroom

COURSE OVERVIEW

This introductory course empowers participants to unlock the full capabilities of Excel for data integration and visualisation. Gain hands-on experience with Power Query for efficient data gathering and learn preparation essentials of data visualisation and dashboard design. By the end of the course, you’ll be able to create dynamic dashboards using Excel’s advanced tools such as Pivot Tables, Pivot Charts, and various chart types, including Sparklines for mini-chart
visualisations. Equip yourself with the skills to craft insightful, interactive dashboards that drive informed business decisions

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

  • Understand the fundamentals of Power Query as a data preparation tool.
  • Apply techniques to clean and transform raw data effectively, making it
    suitable for analysis.
  • Construct interactive dashboards using Excel’s Power Query and PivotTable.
  • Apply various visualization objects such as Charts and Sparklines

Learning Unit 1: Definitions
• What Is Data Visualisation
• What Is A Dashboard

Learning Unit 2: How-To Guide
• Steps In Designing A Dashboard

Learning Unit 3: Introduction To Power Query
• Understand What is Power Query
• Learn how to use Power Query to Get Data From Different Worksheets and/or Different
• Workbooks
• Learn how to use Power Query to Prepare Data

Learning Unit 4: Create Dashboard
Shapes / SmartArt
• Illustrate Key Metrics such as Total Revenue, Market Share in Percentage
Pivot Table & Pivot Chart
• Display Key Summary such as Sales by Product, Sales by Region
• Filter Multiple Summaries with a Slicer or a Timeline
Excel Charts
• Visualise data using different Excel Charts such as Column / Line / Pie / Bar / Combo
• Chart
Sparklines
• Visualise data using Mini-Charts

This course is suitable for participants who need to create Management reports on Dashboard using  Excel’s advanced tools including Power Query.

  • Learners must be able to read, write, speak and listen to English at
    secondary school level.
  •  Learners must be able to operate a personal computer, use keyboard and
    mouse.
  • Learners should have a working knowledge of Microsoft Excel 2016 &
    above.
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored / Self Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$380.00 $34.20 $414.20

REGISTER TODAY

Select a date below

Looking at in-house training or have an enquiry? Contact us!

Related Courses

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration