Business Analytics: Decision Making through Excel



      
Business Analytics: Decision Making through Excel

       APPLY NOW





SSG Course Code: TGS-2021004319/TGS-2021004320

 

Depending on the prevailing COVID-19 environment, classes may be conducted online.

Business Analytics: Decision Making through Excel

We are now in the era of big data. Companies are able to collect a tremendous amount of data, very often more than necessary, with ease at an inexpensive cost.

“Information is Power” is no longer valid if companies are not able to make correct decisions timely on the basis of the data on hand. The use of business analytics for modeling and decision making represents the future of best practices for tomorrow’s companies.

This course prepares participants with fundamental theory and skills to capture business insights from data for decision making using Excel Spreadsheets. Practical examples and cases with data are used to stimulate participants’ interest and foster their understanding of the use of Business Analytics in management and business.

Quantitative models and tools such as Decision Analysis, Simulation Modeling and Optimization are covered to demonstrate the use of scientific methods in business decision making.

TOPIC COVERAGE

This course will address the following:

  • Introduction to Business Analytics
  • Data Intelligence using Pivot Table Analysis
  • Probability Theory and Bayes Theorem
  • Probability Distributions and Simulation Modeling
  • Decision Tree
  • Linear Optimisation and Sensitivity Analysis
  • Discrete Optimization
  • Application of Optimization


 
   

Course Fees

SGD 3,049.50

(SGD 344.85 after MAX Funding)

 
   

Date

27-29 Oct

9am - 5.30pm

 
   

Venue

NUS Business

School

 
   

Level

Intermediate

 


   

Advisor: Clare Ong (Ms)
Contact: +65 6601 7823
Email: clare.ong@nus.edu.sg

 

APPLICATION PROCEDURE AND DEADLINE

  • Participants are strongly advised to apply at least 2 weeks in advance.

WHO SHOULD ATTEND

The course is suitable for those who are interested in business analytics without any prior knowledge. Specifically, the course assumes that participants are new to the Analytics field without any programming and probability concepts, and will introduce Microsoft Excel to them as the main computing software. By familiarizing themselves with Excel, the participants can carry out those decision methods for their future business projects with ease.    

PRE-REQUISITES

This course assumes a very basic level of comfort with Microsoft Excel. Participants should be able to import data, sort it, and perform simple functions such as addition, multiplication, division, and creating tables in Excel. Participants will be required to bring their laptops to class, and to analyze data in class using Excel Spreadsheets. All analyses in this course will be carried out using Excel.

FACULTY 

Tung Yi-Liang, Eli

Lecturer, Analytics & Operations

COURSE FEES AND FUNDINGS

 Self-Sponsored

Company-Sponsored

SME (ETSS Scheme) 

Company-Sponsored

Non-SME 

Course Fees $3,049.50 $3,049.50 $3,049.50
Singapore Citizens & PRs aged 21 years and above $914.85 $344.85 $914.85
Singapore Citizens aged 40 years and above (MCES Scheme) $344.85 $344.85 $344.85

The above prices are quoted in Singapore dollars (SGD), inclusive of 7% GST.