Quantitative AnalystPublic Service Officer (non-ICT&SS)ICT&SS ProfessionalDigital Service ManagerDigital Business AnalystData Engineer
Overview
Acquire critical data wrangling, analysis, and visualisation skills essential to overcome the challenges in a variety of modern-day data-driven businesses. In today's era of big data where the computer and network are everywhere and business process may be translated to data, data manipulation and visualisation skills are much needed to make insightful decisions. Knowledge in data analysis and visualisation provides one with the necessary skills that form the basis for deeper quantitative reasoning needed for data and predictive analytics work. Data may be in abundance; however, making it comprehensible and meaningful to stakeholders require a data driven skillsets.
This programme enables the skills to turn raw datasets into interactive and dynamic visualisations and dashboards providing the platform to draw insights for decision making. This programme aims to equip you with the skills to clean data, perform simple analysis and create useful and interactive visualisations and dashboards for presentation and recommendations to stakeholders. You will learn how to achieve this using Excel and Tableau software.
Key Takeaways
At the end of this programme, you will be able to:
Prepare, clean, format and manage data using Excel for analysis
Summarise and represent data meaningfully using Excel for further analysis and decision-making
Prepare and manipulate data for visualisation using Tableau
Visualise data using Tableau basics
Apply advanced visualisation using charting capabilities in Tableau
Build Interactive Dashboards using Tableau
Who Should Attend
Please refer to the job roles section.
Prerequisites
Basic communication skills in the English language. Experience in working with data would be an advantage.
Programme Structure
This programme will cover the following topics:
Part 1: Collecting and Managing Business Data
Getting external data from various sources (CSV files, text files, database files, web data, etc.)
Preparing and cleaning data using text manipulation (trimming spaces, extracting parts of the cell to create a new column, replacing values etc.)
Extracting data with essential formulae/functions
Formatting and conditional formatting
Tapping into real data from the internet for business analysis
Data format required for analysis
Part 2: Understanding your Data
Data Calculations and Management
Using functions and formulae for calculations and data preparations
Exploring data using AutoFilter and Excel tables
Summarising and analysing worksheet data using PivotTables
Visualising summary report using PivotCharts
Decision making using What-If Analysis
Using Goal Seek to find desired output
Building Data Tables for sensitivity analysis
Using Scenario Manager for reporting different scenarios
Part 3: Prep your Data with Tableau Prep
Tableau Prep Introduction
Tableau Prep Interface and Options
Tableau Prep Cleaning Options
Reading multiple sheets and files
Data aggregation
Workflow and joining files
Pivot data with Tableau Prep
Part 4: Visualising your Data
Tableau Basics
Visual Analytics Principles
Intro to Tableau software
Basic data import
Basic chartsBasic sorting
Basic filtering and paging
Using ShowMe
Basic Dashboarding
Tableau Story Design
Advanced Tableau Charting
Geographical maps
Histograms, scatter plots, box plots
Calculated fields
Clustering using Tableau
Sharing charts and dashboards
Interactive Dashboarding
Action filters
KPIs and Parameter controls
Groups and Sets
Fees
Full Fee
Full programme fee
S$650
9% GST on nett programme fee
S$58.50
Total nett programme fee payable, including GST
S$708.50
With effect from 1 Jan 2024
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 here.
Step 3
The learning partner will inform you whether you have been successful in enrolment.
Learning how to use Tableau for visualisation purposes, as well as basic Excel functions such as vlookup, were most useful as I need them in my current area of work.
,
It was beneficial to learn how to present better to stakeholders using data and analytics. The shared recordings were particularly important for me.
,
It was particularly useful learning about the different Excel shortcuts and applications as they are very useful for filtering data. Tableau is also very effective in creating aesthetically pleasing charts and interactive charts that allow for easy viewing.