Quick Start to Dashboards for Data Analytics

---

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
• Introduction 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)