Harness the power of data to gain perspectives you never thought available. This programme will provide you with a good foundation to conduct data wrangling, perform data analysis, create effective visualisation charts, build interactive dashboards and compose convincing data-driven stories using Microsoft Excel (Power Query, PivotTables and PivotCharts), along with Tableau or Power BI, which will be used as the visualisation tools on alternate runs, to support data-driven business decisions.
Key Takeaways
At the end of this programme, you will be able to:
apply data cleansing and data transformation techniques using Power Query, a free function within Microsoft Excel
apply mathematical and statistical functions to derive insights from the data
create PivotTables and PivotCharts to calculate, summarise, analyse, and visualise data
apply visualisation principles for creating effective visualisations
create and interpret visualisation charts
build interactive dashboards for monitoring key metrics
create data-driven stories for communicating key insights
Who Should Attend
Please refer to the job roles section.
Ideal for Public Service Officers who work with data in Microsoft Excel and would like to prepare data for analysis, create visualisation charts, dashboards, and data stories using Microsoft Excel (Power Query, PivotTables and PivotCharts) and Tableau/Power BI to support data-driven business decisions. Tableau and Power BI will be used as the visualisation tools on alternate runs.
Prerequisites
You should have basic IT literacy.
This programme will cover the following topics:
Day 1 & Day 2 (Using Microsoft Excel: Power Query, PivotTables and PivotCharts)
Data Collection
Data Wrangling
Data Exploration & Analysis
Data Mining Techniques
Day 3 & Day 4 (Using Tableau/Power BI)
Data Visualisation Principles
Tableau/Power BI 101
Interactive Data Visualisation
Interactive Dashboard
Data-Drive Stories
Full Fee
Full programme fee
S$1140
9% GST on nett programme fee
S$102.60
Total nett programme fee payable, including GST
S$1242.60
3 - 8 Apr 2025 (Thursday - Tuesday): Excel Power Query & Power BI
12 - 17 Jun 2025 (Thursday - Tuesday): Excel Power Query & Tableau
14 - 19 Aug 2025 (Thursday - Tuesday): Excel Power Query & Power BI
9 - 14 Oct 2025 (Thursday - Tuesday): Excel Power Query & Tableau
4 - 9 Dec 2025 (Thursday - Tuesday): Excel Power Query & Power BI
26 - 31 Mar 2026 (Thursday - Tuesday): Excel Power Query & Tableau
NOTE Funding is available for this programme. Please visit the Learning Partner’s website to find out about the updated programme fee funding breakdown, eligibility, terms and conditions.
Apply through your organisation's training request system.
Step 2
Your organisation's training request system (or relevant HR staff) confirms your organisation's approval for you to take the programme. Your organisation will send registration information to the academy.
Organisation HR L&D or or equivalent staff can register directly through the learning partner's registration portal.
Click here to register for 3, 4, 7, 8 Apr 2025 (Excel Power Query & Power BI) run.
Click here to register for 12, 13, 16, 17 Jun 2025 (Excel Power Query & Tableau) run.
Click here to register for 14, 15, 18, 19 Aug 2025 (Excel Power Query & Power BI) run.
Click here to register for 9, 10, 13, 14 Oct 2025 (Excel Power Query & Tableau) run.
Click here to register for 4, 5, 8, 9 Dec 2025 (Excel Power Query & Power BI) run.
Click here to register for 26, 27, 30, 31 Mar 2026 (Excel Power Query & Tableau) run.
Step 3
The learning partner will inform you whether you have been successful in enrolment.
The programme notes for Excel and Tableau were very helpful, especially the step-by-step guide for the exercises. The content and case studies were useful for learning as well.
,
The use cases from the facilitators with years of work experience were very insightful. They were able to foretell what issues we may face and also give historical perspective on how things have evolved as well as the pros and the cons.
,
I learnt how to do data cleansing in Excel, data visualisation via pivot tables/charts and using Tableau to visualise data. The lab work to solve business problems was also important as well, as it got us to think about what questions/stories our charts should tell that are important to address the business problems.
