course-banner-img Data Analytics-5

Introduction to Quantitative Data Analysis and Visualization

Topic:Data Analytics & Visualisation

Course Type:Short & Modular Courses

Register interest
Download PDF for print


  • Course Date:

  • Registration Period:

  • Time:

    16 hours / 2 day, Monday and Tuesday
  • Mode of Training:

    Facilitated Learning (F2F)
  • Venue:

    Singapore Polytechnic
  • Funding:

    Eligible for SkillsFuture Credit

*Please note that once the maximum class size is reached, the online registration will be closed.
You may register your interest, and would be notified if there is new run

Course Objective

Data handling, analysis and visualization are critical skills that are necessary in managing the challenges in a variety of modern-day data-driven businesses. In today's era of big data where the computers and networks are everywhere and business processes may be translated to data, this means that data manipulation, analysis and visualization skills are much needed to make insightful decisions. Knowledge in data analysis and visualization provides one with the necessary skills that form the basis for deeper quantitative reasoning needed for data and predictive analytics work.

This course aims to equip participants with the skills to clean data, perform simple analysis and create useful visualizations for presentation and recommendations to stakeholders. Participants will learn how to achieve this using Excel and Power BI software.

Course Outline

Course Learning Outcomes
By the end of the course, participants 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
• Carry out essential statistical analysis and inference on data meaningfully using excel
• Prepare and manipulate data for visualization using Power BI
• Visualize data using Power BI

Topics to be covered

Part 1: Handling Your Data
Collecting and Managing Business Data
• Getting external data from various sources
• Preparing data using text manipulation
• Extracting data with Essential Formulae/Functions
• Formatting and conditional formatting
• Tapping into real data from Internet for business analysis

Building Dashboard using Pivot Tables and Pivot Charts
• Understanding and use of Excel tables
• Creating Pivot Tables to analyse worksheet data
• Creating dashboards using Pivot Charts for visual presentation
• Adding Slicers and Timelines for interactive display
• Introducing multi-table Pivot Tables and data model

Decision making using What-If Analysis 
• Building Data Tables
• Building charts from Data Tables
• Using Scenario Manager for reporting different scenarios
• Exploring Data Analysis tools

Part 2: Understanding your Data
Descriptive Statistics 
• Using statistical functions and formulae
• Plotting different types of charts
• Customising charts for presentations
Inferential Statistics
• Probability Distribution 
• Estimation and Confidence Intervals 
• Hypothesis Testing

Part 3: Visualising your Data
Building dashboard
• Basic visuals
• Data preparation
• Layout planning
• Building functions using DAX

Minimum Requirements

Basic communication skills in English language. Experience in working with data would be an advantage.

Participants are required to bring their own laptops for this training and installed with Microsoft Office 365 or Office 2019.

Certification / Accreditation

• Certificate of Attendance (electronic Certificate will be issued)
A Certificate of Attendance will be awarded to participants who meet at least 75% attendance rate

• Certificate of Performance (electronic Certificate will be issued)
A Certificate of Performance will be awarded to participants who pass the assessment and meet at least 75% attendance rate

Suitable for

Data Analyst, Business Professionals and Academics with a need to analyse and visualise data, Business and Quantitative Analysts

Course Fees

Full Fees (before GST): $480.00

Applicants/Eligibility SkillsFuture Funding GST Subsidised Fee (after GST)
Singapore Citizens aged 40 and above¹ $432.00 $12.96 $60.96
Singapore Citizens aged below 40 $336.00 $12.96 $156.96
Singapore Permanent Residents and LTVP+ Holders $336.00 $12.96 $156.96
SME-sponsored Singapore Citizens, Permanent Residents and LTVP+ Holders² $432.00 $12.96 $60.96
Others (Full fees payable) $0.00 $43.20 $523.20

Singaporeans aged 25 years and above may use **SkillsFuture Credit balance to offset respective course fees.

¹ Under the SkillsFuture Mid-career Enhanced Subsidy. For more information, visit the SkillsFuture website here
² Under the Enhanced Training Support for Small & Medium Enterprises (SMEs) Scheme. For more information of the scheme, click here. To view SP’s list of similar funded courses, click here. Please submit the attached “Declaration Form for Enhanced Training Support Scheme for SME” together with your online application.

Funding Incentives

Please click here for more information on funding incentives.

Application Procedure

1. For self-sponsored applicant, please click on the “Register” button to apply for the course. You will be directed to STEP portal to manage all your course activities. Please note that you will be prompted to sign in with Singpass/Student ID.
2. For company-sponsored applicant, please approach your company's Human Resource (HR) team to put in the application through the company portal using CorpPass.  You may only apply after receiving the registration link from your company's HR.
3. Your application does not guarantee acceptance into the course. Your acceptance into the course is dependent on meeting the course requirements and course vacancy.
4. All successful applicants will be notified with a letter of confirmation via email.
6. PACE Academy course schedules, including course trainer, course fees and course availability are subject to change.

7. PACE Academy reserves the right to cancel or postpone any course at short notice; & at its absolute discretion without assigning any reason for such cancellation/postponements. In the event that the applicant’s chosen course is cancelled prior to its commencement, PACE Academy will make a full refund of course fees already paid by the applicant.

8. The data provided to Singapore Polytechnic will be kept strictly confidential and will be used for the purpose of course administration. The data may be passed on to the relevant organisations that require the information related to the course.  

Courses that may also interest you