Quick Start to Dashboards for Data Analytics

Training Modes
 Virtual: Zoom
 In-Class

Course Code
 
OK6QSD
Duration
 
7 Hours (1 Day)
Course Fee
 
$449.40 inclusive of GST
Funding
 
None
This Course is For
 
Learners who have basic MS Excel knowledge and application and would like to expand their knowledge by including dashboard creation for reporting purposes.

Preferred Date

You can also register by:

  1. Form: Click here to download. Email back to us.
  2. Ministries on HRP / ACE: Inform your Training Coordinator the Course Code, Course Date and the Training Provider is Oaks Training c/o GIL Consultancy.
    IMPORTANT NOTE: OAKS TRAINING begins with the letter O and not the symbol @ in HRP
  3. PHONE: Call +65 6423 1183.


Understand the relationship between Dashboards and Data Analytics

Dashboards are a form of “progress report” for the respective stakeholders to understand a particular organizational performance at-a-glance through the presentation of relevant KPIs from you and your team members.

This one-day workshop is focused at equipping you with the knowledge and skills to effectively organize, clean, analyze, and interpret data to result in the creation of relevant dashboards for your superiors to have insight into the situation as well as make informed decisions.


Course Objectives

  • Understand the relationship between Excel Dashboarding and data analytics
  • Appreciate the simplicity of Excel Dashboard
  • Learn the basics before building the Dashboard
  • Identify and Apply the appropriate Dashboard’s relevant Excel features
  • Apply the DASH approach to build your first Excel Dashboard

Course Outline

  • How data analytics and excel dashboard benefit you
  • Know what is an Excel dashboard
  • What are the steps pre-dashboard using DASH methodology?
    [Import data into Excel, Clean the data, Set up the workbook, Understand the requirements]
  • Know basic Dashboard concepts
  • How the DASH concept is applied for preparing the first simple Excel Dashboard
    • Define Information Needs
    • Acquire and Arrange data
    • Specify end-user requirements
    • How to create simple an effective dashboard
  • ntroduction to additional Excel dashboard concepts and methods
  • What’s next? Data Visualization and Presentation

Methodology

Experiential learning, individual work, class discussions, reflection.


For Your Delight

• A Certificate of Attendance will be given subject to 90% attendance.


Trainer

Daniel Kam has at least 20 years of corporate leadership experience under his belt around Business Development, Sales and Marketing, General Management and Organization Development work including 7 years of senior management role as a Director of Asian market in the most recent corporate job. He brings relevant experience, wisdom and practical insights in his soft-skills based programs such as leadership, high performance team work, personal development as well as business development and management. He brings relevant experience, wisdom and practical insights into his exciting courses.

He holds a degree in Business Administration with specialization in Marketing. He is a certified professional trainer, qualified ACTA facilitator as well as an executive coach. He is also certified as a trainer for Brian Tracy range of sales leadership courses.

A passionate trainer with great empathic considerations, Daniel is able to relate well with diverse groups of multi-cultural and multi-generational learners. An engaging facilitator, Daniel encourages active participation from learners of his workshops and courses, ensuring effective internalization and subsequent application of new learned knowledge.


Subsidy

Currently Not Applicable


Special Request

If the dates listed are not suitable for you and you have a group interested in the same course, you can contact us to arrange a date of your choice, subject to our trainer availability.

Evening classes or to be conducted in Mandarin are also available on request. Contact us for arrangements.

Group discounts are also available. Request a quote from us.


Reviews

Excellent Trainer... learning is fun and interactive.
Sylvia Teo (WSHC)

Trainer is friendly, humorous and knowledgeable.
Danny Yap (MOL)

Trainer is patient and knowledgeable. Excellent too. Thank you!
Lim Wee Chin (MOF)