May 2020

Problem Solving with Data Analytics(LIVE Stream)

Course Information

Start Date4 May 2020, Monday
End Date5 May 2020, Tuesday
Time9am to 5pm
Venue100 Orchard Road, Concorde Hotel Singapore 238840
Fee$1,200 (excluding GST) Inclusive of refreshments, lunch, and course materials
ContactRoshini | 6720 3333 | training.aventis@gmail.com
Register Now
Get Group Quote
LIVE Stream

Course Schedule

24 & 25 Feb 2020 Confirmed Run

4 & 5 May 2020

27 & 28 Jul 2020

26 & 27 Oct 2020

(Click on the dates above to register)


In recent years, data analytics has gained significant buy-in from senior management. However, many organisations find it challenging to get data analytics off the ground and on the right track due to a combination of technical, cultural, and capabilities factors. One of the key factors is the lack of analytics skills among the employees. While many organisations may hire specialists to jump start its analytics journey or work in specific analytics projects, the potential of data analytics can only be sustained if the organisation is able to build data analytics capabilities and culture throughout the organisation. This course aims to address such capability gaps especially among professionals and managers in non-analysts’ roles but are required to work with or make sense of data and analyses in their daily works.

Course Highlights

By the end of the course, you will:

  • Understand what data analytics is, and the different approached to data analytics for different problem-solving situations
  • Develop analysis framework through problem definition, hypotheses development and identification of data requirement
  • Understand the principles to building sustainable analytics culture in an organization
  • Gain exposure to various data analytics and visualization techniques and tools
  • Gain practical data analysis skills through descriptive and predictive analysis exercises with MS Excel
Target Audience

This course is designed for professionals and individuals with an interest to learn and improve their understanding and skills in data analytics, particularly in applying analytics to problem solving. This course is suitable for participants across all industries and job functions.


Participants are required to have basic Microsoft Excel and computer skills. No prior knowledge of data analytics is required. Participants are required to bring a laptop with Microsoft Excel (version 2010 or later).

Course Outline

Understanding Data Analytics, Big Data & Artificial Intelligence

  • A general introduction of the concept of analytics, including the general utilities and potential of analytics to inform, explain and guide decision making
  • Introduction to Big Data and Artificial Intelligence; types & examples of machine learning
  • Case studies – See how some notable organisations have successfully deployed analytics to great effect (Walmart, Target, Google, Jetblue)


Practicing and Sustaining Data Analytics at Work

  • Data Analytics Value Chain & Components
    • What does it take to progress along the maturity curve?
    • Recipe for successful data analytics
    • Case study – how analytics changed the game for Oakland Athletics in professional baseball
  • Building Analytics Culture
    • Leadership for analytics
    • Data analytics competency framework
    • Organisation design
    • Data Analytics Maturity Model
    • Class survey
    • Group Exercise: Fill in the success recipe book


Translating Data into Insights

  • Understand Your Problems
    • Complexity theory and Cynefin Framework
    • Group exercise: making sense of your problems
  • Building an Analysis Framework
    • 6-step framework from problem to data, insights and decision
    • Group exercise: building an analysis framework
    • Analytics techniques to connect-the-dots


Statistical Analysis Concepts for Business Users

  • Common analysis techniques, including trends analysis, regression analysis, survival analysis etc.
  • Class exercise: MS Excel analysis (pivot table, descriptive, correlation, multiple regression)
  • Data visualisation and storytelling
    • Principles of storytelling with data
    • Data visualisation tools & techniques
    • Demo of visualisation platforms
    • Class exercise: build your own dashboard (MS Excel)


Bringing all together: Capstone Business Case Exercise

  • The participants will work on a capstone business case exercise with the concepts and techniques they have acquired in this course
  • The final presentation, which should include the following: problem statement, summary of findings (each supported by facts & analysis) and recommendations
  • Group presentation & discussion
Data Expert: Michael Lee

Michael is an associate of FYT Consulting Pte Ltd. An IT professional by training with more than 25 years of consulting & practical experience across many functions (sales, client management, business operations & customer service) throughout various roles (Vendor, Systems Integrator, Distributor and Enduser) in both the public & private sector.

Prior to joining FYT Consulting, Michael has done consultancy and process re-engineering for several SMEs. He has also conducted numerous training sessions on Virtual Teaming for international banks and corporations. In addition, he has made many speaking engagements in Customer & Partner events, as well as in major international Sales Conferences. Michael holds a bachelor’s degree in Computer Science & Mathematics as well as an MBA from the National University of Singapore.


“This workshop has a lot of case studies used which is helpful to understand the pitfalls of misinterpretation of data & usefulness of data analysis to problem solving. A good trainer, very clear in delivering concepts and very experienced. Overall this workshop is useful. Perfect & good communicator”
IP Academy

“Michael is very clear in his explanation and guides us very well. His materials are interesting and he uses real life problems to bring the context in.”
Leong Mok Kam, Rosyth School

“Good knowledge on data analysis. Understand regression model and use it to gain insights. Overall the trainer is knowledgeable and engaging. A good trainer, very clear in delivering concepts and very experienced.”
Government Technology Agency