BUSINESS ANALYTICS: DECISION MAKING THROUGH EXCEL
DURATION
8 evenings
NEXT RUN
15 Jan 2025
FEES
SGD 3,106.50 (incl. GST)
SGD 361.95 (after MAX Funding*)
VENUE
Live Online (every Wed & Fri, via Zoom)
NUMBER
Crystal Tan
+65 6516 1320
GST shall apply at prevailing rates. More info.

This course is one of the gateway courses that is required and compulsory for admission to The NUS Executive MSc in Management (EMIM).
OVERVIEW

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 modelling 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 Modelling and Optimisation are covered to demonstrate the use of scientific methods in business decision making.

Outline

  • Use Excel formulae and cell referencing
  • Conduct basic summary of data

  • Use Pivot Tables in Excel to stratify data
  • Use Pivot Charts to visualize data

  • Compute conditional probabilities
  • Understand and use Bayes’ rule

  • The concepts of random variables
  • Differentiate between discrete and continuous probability distributions

  • Use Excel to simulate a variety of random variables
  • Carry out Simulation to analyse business decision problems

  • Illustrate a decision tree and its power in decision making
  • Use decision tree to make business decisions under uncertainty

  • Formulate a Linear Programming (LP) mathematical model
  • Solve the optimal solution of an LP using Excel solver

  • Construct binary constraints
  • Logical constraint formulation
  • big-M notation

    Faculty

    yi-liang tung
    Lecturer
    Analytics & Operations
    View Profile
    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 familiarising themselves with Excel, the participants can carry out those decision methods for their future business projects with ease.

    THE NUS EXECUTIVE MSc IN MANAGEMENT (EMIM)

    24 Months | Hybrid-Learning. Executive-friendly format.

    Explore The NUS Executive Master of Science in Management Programme, rooted in the ethos of lifelong learning. Our transformative program is designed to empower and equip mature learners from diverse educational backgrounds with the latest knowledge and essential management skills, all within a dynamic and multicultural setting. A prior bachelor’s degree is not mandatory for admission.

    Learn More

    • Small/medium business owners looking to acquire formal education
    • Former civil servants looking to transit into the private sector
    • People who have done well in business without any formal training and are looking to further develop their skills or credentials to grow
    • The middle-aged career candidates that would like to attain a degree
    • People who are in transition from career sabbatical and back to professional life

    Learners will

    • gain a holistic perspective of business operations, corporate
      finance and accounting, and the key drivers of firm performance as well
      as the interrelationships among them,
    • learn about the key themes on qualitative and quantitative
      components of management, strategy making and execution, and
      facilitating them in organisations,
    • develop skills in data-informed analysis,
    • communicate and work collaboratively in teams to solve challenging problems, and
    • develop sensitivity to stakeholders’ requirements and learn to work towards meeting them.



    *Learners will need to attain at least a Merit grade for just 2 gateway courses (with the Financial Analysis and Business Decisions for Non-Finance Managers gateway course as mandatory) as part of the admissions criteria to the EMIM programme.

    DATES AND FEES
    Date Venue (incl. GST) (after MAX Funding*) Registration
    15 Jan 202514 Feb 2025
    Live Online (every Wed & Fri, via Zoom) SGD 3,106.50 SGD 361.95
    Application Procedure and Deadline
    Participants are strongly advised to apply at least 2 weeks in advance.

    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 analyse data in class using Excel Spreadsheets. All analyses in this course will be carried out using Excel.

    SkillsFuture Singapore (SSG) Funding Scheme for Singapore Citizens or Permanent Resident (PR)

    This programme is eligible for subsidies under SkillsFuture Singapore
    (SSG). Singaporeans or PR can enjoy up to 70% or more subsidies.

    *Click here to find out the details.