Grow your profits through data analytics and data modelling

Who Should Attend

This course is targeted to those who are currently working in

• Sales, Marketing, 
• Supply Chain, 
• Finance,
• HR and/or
• running your own business.

An intermediate level of Excel skills is recommended. It is okay if you have little or no prior experience in Pivot Table. You should be interested in upgrading your knowledge and skills from Excel to Data Analytics. You should be keen to learn how to extract and analyse financial and non-financial information to identify areas of growth in revenue and areas of wastage in cost.

What do our past participants say?

Understand how data can be presented in the manner I need

Learning Objectives

Upon completion of the course, participants will be able to:

1. Understand data management cycle to better handle information the organisation works with.
2. Generate reports on trends and identify potential risks that affect organisation’s productivity.
3. Collect appropriate data for analysis in an effective and efficient manner.
4. Extract and validate data to ensure data accuracy and reliability.
5. Identify trends and patterns across multiple datasets.
6. Analyse data to derive insights and help organisation to make actionable business decisions 
7. Evaluate the effectiveness of data analysis methods and approaches.

Course Outline

The course is divided into 4 main sections

SECTION 1: BUSINESS UNDERSTANDING

• What is Data?
• How does Data flow from into your business and convert to insights?
• Where is your data now and how to analyze it further?

SECTION 2: DATA ACQUISITION

• Why you should protect your business data?
• What tools are available in the market and how to choose the right one?
• How you should handle your data and why it is important to get it right from the start?
• What is Extract, Transform and Load (ETL)?
• Acquire practical skills in ETL through Power Query

SECTION 3: DATA MODELLING

• Integrate information from multiple datasets
• Combine data sets horizontally, similar but better than using VLOOKUP
• Combine data sets horizontally, an automate way to copy and paste countries data together
• Perform powerful calculations that you wish you can do with Pivot Table.

SECTION 4: BUSINESS INSIGHTS

• 6 different techniques you can use to analyze your business data
• Identify patterns across different data sets
• How to evaluate your data analytics performance

Program Dates

• 28 – 30 Dec 2020 (Mon to Wed)
• 18 – 20 Jan 2021  (Mon to Wed)
• 03 – 05 Mar 2021 (Wed to Fri)
• 27 – 29 Apr 2021 (Tue to Thu)
• 17 -19 May 2021 (Mon to Wed)
• 21 – 23 Jun 2021 (Wed to Fri)
• 14 – 16 Jul 2021 (We to Fri)
• 16 – 18 Aug 2021 (Mon to Wed)
• 15 – 17 Sep 2021 (Wed to Fri)
• 11 – 13 Oct 2021 (Mon to Wed)
• 24 – 26 Nov 2021 (Wed to Fri)

Mode of Delivery

• Face-to-Face

Course Duration

• 3 days (8 hours each day) – 9 am to 6pm

Price

Course Fee after Training Grant: S$400 per pax (Can be offset with SFEC or SFC)

Check your training grant eligibility below

Fundings and Support you can Apply to Defray the Cost of the Training

Self Sponsored

• SSG Training Grant – up to 90% of the course fees
• NTUC Union Training Assistance Programme (UTAP)  – up to 50% of the course fees or $250/$500 per year
• NTUC Self Employed Person (SEP) Training Fund – up to $11 per hour
• Skills Future Credit (SFC) – $500 Top Up on 1 Oct 2020 plus Opening Skills Future Credit of $500

Company Sponsored

• SSG Training Grant – up to 90% of the course fees
• Skills Future Enterprise Credit (SFEC) – up to $10,000
• Enhanced Absentee Payroll – Up to $7.50 per hour

(Click on the individual Funding Types to find out more.)

________________________

If you need further clarifications, please send us a message using the form here and we will reply you ASAP.

[NOTE: The form is not a registration form. You have to contact us via email to register.]