Effective Data Analysis using Excel (16 hrs)
Course Code: TGS-2023020187 | SSG Funded
*Classroom-based Learning*
This course will equip participants with data analysis skills in Excel, including applying various formulae and functions and using Power Pivot for statistical analysis of multiple data sources.
Participants who fulfil all requirements will receive a Statement of Attainment (SOA) issued by SkillsFuture Singapore (SSG).
- 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.
Understanding data modelling and visualization to perform data analysis
- Create data models using Power Pivot
- Create pivot tables and pivot charts for forecasting and recognising patterns and trends
Using excel functions to apply techniques on data sets for data analysis
- Introduction to advanced excel functions and features for data analysis
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
Using DAX for analysis to provide business insights
- Using DAX to summarise data for analysis and business insights
Using statistical techniques and data analysis ToolPak for creation of dashboard reports
- Introduction to statistical formulas and techniques for dashboard reports
- Data Analysis ToolPak for business insight reports
Using excel functions and queries to extract data for data analysis
- Joining multiple tables to extract data for data analysis and visualization
Transforming data for data analysis using excel functions and formulae
- Data cleaning and validation of required dataset for visuals
Lectures, demonstration and hands-on activities designed to provide practical experiences with skills being taught.
This course is suitable for PMETs who aspire to move beyond creating spreadsheets and onto data analytics using a familiar tool.
Prerequisites
Participants are assumed to:
- Have Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 3
- Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 3
- Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 3
- Have minimum GCE ‘O’ level or ITE certificate education
- Have at least 1 year’s working experience in any industry
- Be able to operate a computer
Duration : 2 days (16 hrs)
Time : 9:00am to 6:00pm
With effect from 1 Jan 2024
| Type | Individuals | |||
| Singapore Citizens and Permanent Residents (Aged ≥ 21 years old) | Employer-sponsored and Self-Sponsored Singapore Citizens aged ≥ 40 years old | SME-sponsored Singapore Citizens and Permanent Residents | Non-SME-sponsored Singapore Citizens and Permanent Residents | |
| Type of Funding | ||||
| SkillsFuture Funding (Baseline) | SkillsFuture Mid-career Enhanced Subsidy | SkillsFuture Enhanced Training Support for SMEs | SkillsFuture Training Support for Non-SMEs | |
| Course Fee | $480.00 | $480.00 | $480.00 | $480.00 |
| Less: SkillsFuture Funding | $240.00 | $336.00 | $336.00 | $240.00 |
| Total Nett Fee | $240.00 | $144.00 | $144.00 | $240.00 |
| Add: GST @ 9% of Course Fee | $43.20 | $43.20 | $43.20 | $43.20 |
| Total Fee Payable to SQC | $283.20 | $187.20 | $187.20 | $283.20 |
Skill Code: ICT-BIN-2104-1.1
Skill Title: Data Analytics-2
Funding valid till 16 Apr 2025
* Please click HERE for detailed information on general terms and conditions.
* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.
(A course in partnership with James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)
- 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.
Understanding data modelling and visualization to perform data analysis
- Create data models using Power Pivot
- Create pivot tables and pivot charts for forecasting and recognising patterns and trends
Using excel functions to apply techniques on data sets for data analysis
- Introduction to advanced excel functions and features for data analysis
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
Using DAX for analysis to provide business insights
- Using DAX to summarise data for analysis and business insights
Using statistical techniques and data analysis ToolPak for creation of dashboard reports
- Introduction to statistical formulas and techniques for dashboard reports
- Data Analysis ToolPak for business insight reports
Using excel functions and queries to extract data for data analysis
- Joining multiple tables to extract data for data analysis and visualization
Transforming data for data analysis using excel functions and formulae
- Data cleaning and validation of required dataset for visuals
Lectures, demonstration and hands-on activities designed to provide practical experiences with skills being taught.
This course is suitable for PMETs who aspire to move beyond creating spreadsheets and onto data analytics using a familiar tool.
Prerequisites
Participants are assumed to:
- Have Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 3
- Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 3
- Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 3
- Have minimum GCE ‘O’ level or ITE certificate education
- Have at least 1 year’s working experience in any industry
- Be able to operate a computer
Duration : 2 days (16 hrs)
Time : 9:00am to 6:00pm
With effect from 1 Jan 2024
| Type | Individuals | |||
| Singapore Citizens and Permanent Residents (Aged ≥ 21 years old) | Employer-sponsored and Self-Sponsored Singapore Citizens aged ≥ 40 years old | SME-sponsored Singapore Citizens and Permanent Residents | Non-SME-sponsored Singapore Citizens and Permanent Residents | |
| Type of Funding | ||||
| SkillsFuture Funding (Baseline) | SkillsFuture Mid-career Enhanced Subsidy | SkillsFuture Enhanced Training Support for SMEs | SkillsFuture Training Support for Non-SMEs | |
| Course Fee | $480.00 | $480.00 | $480.00 | $480.00 |
| Less: SkillsFuture Funding | $240.00 | $336.00 | $336.00 | $240.00 |
| Total Nett Fee | $240.00 | $144.00 | $144.00 | $240.00 |
| Add: GST @ 9% of Course Fee | $43.20 | $43.20 | $43.20 | $43.20 |
| Total Fee Payable to SQC | $283.20 | $187.20 | $187.20 | $283.20 |
Skill Code: ICT-BIN-2104-1.1
Skill Title: Data Analytics-2
Funding valid till 16 Apr 2025
* Please click HERE for detailed information on general terms and conditions.
* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.
(A course in partnership with James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)
Course Application
| Details | Registration |
|---|---|
|
January 16, 2024 - January 17, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
|
February 19, 2024 - February 20, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
|
March 21, 2024 - March 22, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
|
April 8, 2024 - April 9, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
|
May 6, 2024 - May 7, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
|
June 13, 2024 - June 14, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Register Now |
