Retail Analytics and Market Intelligence (16 hrs)
Course Code: TGS-2023020683 | SSG Funded
*Classroom-based Learning*
The course will help participants to apply data analysis techniques using Microsoft Excel with focus on those in the retail trade. In this course, participants will learn how to use Excel to create formulas and functions that will generate retail KPIs for measurement of performance as well as create visualization of market information for business.
Participants who fulfil all requirements will receive a Statement of Attainment (SOA) issued by SkillsFuture Singapore (SSG).
- Understand company’s data collection and analysis strategy for metrics and measurement based on business products and services.
- Organize data sets for strategic measurement of retail KPIs.
- Aware of trending and emerging data analytics visualization tools and technology.
- Collect measurements and information to determine effectiveness of the tools and technology deployed.
- Create different analytical reports to analyse consumer segmentation, predictive modelling, contextual targeting, churn analysis, revenue growth and cost optimization.
- Conduct data analytics of trending customer activities and behaviours.
- Prepare and update reports and dashboards illustrating trends and insights for business questions and issues.
Metrics and measurements for data analytics
- What are retail analytics?
- What is market intelligence?
- Types of data collection tools and data collection techniques
- How data collected is used for market intelligence?
All about data models and data linkages
- Importing data into Excel (Spreadsheets, CSV, Database)
- Create tables and basic analysis
- Create Pivot Table with aggregation and built-in calculations
- Create calculated items and calculated fields
- Introduction to PowerPivot
- Understanding relationships
- Create data models
- Difference between calculated items and calculated fields
- Importing data from multiple sources
- Create data models with relationships
Data analytics and data visualization trends
- Creating Pivot Charts
- Formatting Pivot Charts
- Creating DAX measures
- Understanding DAX syntax
- Creating pivot charts
- Formatting of pivot charts
- Creating DAX measures in pivot tables
Effectiveness of data analytical tools
- How to evaluate effectiveness of data analytical tools?
- Power Pivot vs Pivot Table
- Excel vs Power BI Desktop
Analysing key performance metrics to manage business performance
- Identifying retail business performance metrics like churn analysis, revenue growth, cost optimization, predictive modelling
- Identifying Excel functions/ DAX measures to generate metrics
Analysing customer activities and behaviour
- Using visualizations to create dashboard with slicers
- Observing business trends based on interactivity of visualization
- How to observe trends? E.g. using trend lines and patterns
- Provide an example and discuss what are the trends observed and if there are any patterns observable?
Address business questions through analysing reports and dashboards
- Identifying types of reports required for retail, e.g. sales analysis, churn analysis, revenue growth, consumer segmentation
- Analysis from market intelligence
Lectures, demonstration and hands-on activities designed to provide practical experiences with skills being taught.
This course is suitable for retail executives, managers, supervisors, and others in the industry seeking knowledge in data analysis and dashboard creation for retail business.
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
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: RET-RAN-2002-1.1
Skill Title: Data Analytics-2
Funding valid till 04 May 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)
- Understand company’s data collection and analysis strategy for metrics and measurement based on business products and services.
- Organize data sets for strategic measurement of retail KPIs.
- Aware of trending and emerging data analytics visualization tools and technology.
- Collect measurements and information to determine effectiveness of the tools and technology deployed.
- Create different analytical reports to analyse consumer segmentation, predictive modelling, contextual targeting, churn analysis, revenue growth and cost optimization.
- Conduct data analytics of trending customer activities and behaviours.
- Prepare and update reports and dashboards illustrating trends and insights for business questions and issues.
Metrics and measurements for data analytics
- What are retail analytics?
- What is market intelligence?
- Types of data collection tools and data collection techniques
- How data collected is used for market intelligence?
All about data models and data linkages
- Importing data into Excel (Spreadsheets, CSV, Database)
- Create tables and basic analysis
- Create Pivot Table with aggregation and built-in calculations
- Create calculated items and calculated fields
- Introduction to PowerPivot
- Understanding relationships
- Create data models
- Difference between calculated items and calculated fields
- Importing data from multiple sources
- Create data models with relationships
Data analytics and data visualization trends
- Creating Pivot Charts
- Formatting Pivot Charts
- Creating DAX measures
- Understanding DAX syntax
- Creating pivot charts
- Formatting of pivot charts
- Creating DAX measures in pivot tables
Effectiveness of data analytical tools
- How to evaluate effectiveness of data analytical tools?
- Power Pivot vs Pivot Table
- Excel vs Power BI Desktop
Analysing key performance metrics to manage business performance
- Identifying retail business performance metrics like churn analysis, revenue growth, cost optimization, predictive modelling
- Identifying Excel functions/ DAX measures to generate metrics
Analysing customer activities and behaviour
- Using visualizations to create dashboard with slicers
- Observing business trends based on interactivity of visualization
- How to observe trends? E.g. using trend lines and patterns
- Provide an example and discuss what are the trends observed and if there are any patterns observable?
Address business questions through analysing reports and dashboards
- Identifying types of reports required for retail, e.g. sales analysis, churn analysis, revenue growth, consumer segmentation
- Analysis from market intelligence
Lectures, demonstration and hands-on activities designed to provide practical experiences with skills being taught.
This course is suitable for retail executives, managers, supervisors, and others in the industry seeking knowledge in data analysis and dashboard creation for retail business.
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
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: RET-RAN-2002-1.1
Skill Title: Data Analytics-2
Funding valid till 04 May 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 4, 2024 - January 5, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
February 1, 2024 - February 2, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
March 12, 2024 - March 13, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
April 1, 2024 - April 2, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
May 2, 2024 - May 3, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
June 6, 2024 - June 7, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Register Now |