Effective Data Analysis using Excel
TGS-2023020187
Course Overview
This course provides practical data analysis skills using Excel, teaching learners to utilise formulas, functions, and Power Pivot to connect to multiple data sources. Key areas covered include data modelling and visualisation, DAX language for data summarisation, statistical techniques for dashboard creation, and data protection guidelines. Learners will also master techniques for cleaning datasets and performing comprehensive data analysis
Training Type
Full Time
Who Should Attend
This training is relevant to PMETs who are aspiring to move away from just creating spreadsheets onto a data analytics scale using a tool that they are relatively familiar with.
Course Duration
2 Days
Total Training Duration (Hour)
16
Course Outline
Learning Unit 1 – Understanding Data Modelling and Visualization to Perform Data Analysis
- Create Data Models using Power Pivot
- Create Pivot Tables and Pivot Charts for Forecasting and Recognizing Patterns and Trends.
Learning Unit 2 – Using Excel Functions to Apply Techniques on Data Sets for Data Analysis
- Introduction to Advanced Excel Functions and Features for Data Analysis
Learning Unit 3 – Using Power Pivot for Data Modelling and Applying Data Integrity
- Using Power Pivot Models to Create Business Insight Reports
- Applying Data Protection Rules in Excel
Learning Unit 4 – Using DAX for Analysis to Provide Business Insights
- Using DAX to summarize data for analysis and business insights
Learning Unit 5 – Using Statistical Techniques and Data Analysis Tool Pak for creation of Dashboard reports
- Introduction to Statistical Formulas and Techniques for Dashboard Reports
- Data Analysis Tool Pak for Business Insight Reports
Learning Unit 6 – Using Excel Functions and Queries to Extract Data for Data Analysis
- Joining Multiple Tables to Extract Data for Data Analysis and Visualization
Learning Unit 7 – Transforming Data for Data Analysis using Excel Functions and Formulae
- Data cleaning and validation of Required Dataset for Visuals
Course Learning Outcome
By the end of this course, learners will be able to:
- Apply principles of data modelling and visualization to create data models to identify and predict trends and patterns.
- Use data science techniques to perform data analysis on data sets.
- Apply data protection and legal guidelines to support the creation of business insight reports
- Apply DAX language to summarize data to provide business insights from data source.
- Apply statistical techniques and formulas to produce analytical dashboards and insight reports.
- Join multiple tables using unions to extract data analysis aligned to the domain context.
- Create clean required dataset with functions and formulas to visualize data.
Pre-requisites
- Learners are required to have basic excel knowledge.
- Learners must be able to read, write, speak and listen to English at secondary school level
- Learners to have minimum GCE ‘O’ level or ITE certificate education
- Learner should have at least 1 year’s working experience in any industry.
- Be able to operate a computer.
Funding Information
17 Apr 2027 To 16 Apr 2027
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $480.00 | $523.20 |
| Individual Pricing (Fee payable to Training Provider) | Before GST | With GST (9%) |
| Individual (Baseline) | $240.00 | $283.20 |
| Individual (MCES) | $144.00 | $187.20 |
| Corporate Pricing (Fee payable to Training Provider) | ||
| SME | Before GST | With GST (9%) |
| Corporate (SME) | $144.00 | $187.20 |
| Non-SME | Before GST | With GST (9%) |
| Corporate (Non-SME, Baseline) | $240.00 | $283.20 |
| Corporate (Non-SME, MCES) | $144.00 | $187.20 |
Company Sponsored Funding Types
- SME
- Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
- 70% of course fee funded
- Non-SME (Baseline)
- Non-SME companies, employee is Singaporean or PR aged below 40
- 50% of course fee funded
- Non-SME (MCES)
- Non-SME companies, employee is Singaporean aged 40 years and above
- 70% of course fee funded
Absentee Payroll Funding for Companies:
- $4.50 per training hour capped at $100,000 per enterprise per calendar year
------------------------------------------------------------------------
Self-sponsored Funding Types
- MCES
- Singaporean aged 40 years and above
- 70% of course fee funded
- Normal
- Singaporean / PR aged 21 years and above
- 50% of course fee funded
