Business Analytics and Modelling using MS Excel

Course Information

1 Day Course

Time: 9am – 5pm

Contact: bes@dnb.com.sg 

Course Introduction

Business analytics is the methodology or tool that breaks down past performances to draw the plan for the future and make informed decisions. It essentially comprises of quantitative and statistical analysis, predictive modelling, data mining, multivariate testing, and more. 

This course aims to equip managers and business executives with the tools and framework to make data driven decisions. Participants will learn about visualising the insights in a way that’s relatable, making it easier to see what actions needs to be taken and ultimately how this information can be used in the business. 

Learning Outcome

  • Develop strategic critical thinking and problem-solving skills using data analytics and MS Excel Tools
  • Learn to build business models using MS Excel
  • Learn to tell a story with data to influence human behaviour and improve the decision-making process
  • Build high-performing teams that make better informed decisions as a group rather than as separate individuals
  • Become a more strategic leader and decision-maker by understanding the long-term impact your decisions can have on your organisation

Course Outlines

Topic 1: Intro to business analytics
Topic 2: Business use case discussion
Topic 3: Intro to MS Excel and useful functions
Topic 4: Business Analytics pipeline with Excel
Topic 5: Business Modelling with Excel
Topic 6: A use case with Operations analytics using Excel
Topic 7: A use case with Credit risk modelling with Excel
Topic 8: Building business dashboard with excel

Questions regarding to the Course?
Let us help!

Scroll to Top