fbpx

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?

Desmond // Group Director

Able to merge multiple files easily for analysis, and no need to re-do the data transformation every time

Swee Kiang // Accounts Assistant

for my account receivable file can help to sort by customer, team, job code and date. save time for manual insert or delete.

Angelia

I am now able to do my monthly commission payout in a short time

Nehemiah Lai

Save tremendous amount of time and effort for routine monthly sales reports.

Moon // Centre Manager

Solve the issue for identify the frequency of our live web class attendees

Katherine // Int'l BD Mgr

Time savings and able to explore and generate more reports for analysis and business making decisions

Kathleen // L & D

Time saving The slicer that helps simply retrieval of information from huge database and shows clarity in presentation.

Wendy // L&D

Helped to make working on excel data easier and faster

Patrick  // CEO 

Understand how data can be presented in the manner I need

Jennifer Tan // Accountant

The course teaches me how to create a consolidated report in a fast and efficient way.

Unidentified

Learning how to save time by using pivot table and power pivot table as well as power query to "clean up" data in order to be able to generate relevant information for analysis

Loo Looi Leong 

More time efficient solutions by automating the reporting and analysis work for my job.

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

Before Subsidy: S$1,600 per pax

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

Self Sponsored

Company Sponsored

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

________________________

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

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