Business Analytics with Excel

Name: Business Analytics with Excel
Rating: 3.9 (58 reviews)

Business Analytics covering Statistical tools, Excel applications, Forecasting, Regression, Optimization & Simulation

Created byDr Bishram

Last updated 8/2022

English

What you'll learn

1. To gain an understanding of how managers use business analytics to formulate and solve business problems and to support managerial decision making.
2. Use analytics in customer requirement analysis, general management, marketing, finance, operations, and HR
3. To become familiar with the processes needed to develop, report, and analyze business data.
4. To learn how to use and apply Excel and Excel add-ins to solve business problems.
5. Get empowered and be ready to propel his/ her career.

Course content

5 sections • 39 lectures • 4h 16m total length

Course Structure5:23
This Lecture describes the Course Structure
What is Business Analytics?6:26
Business Analytics Explained. The elements of Business Analytics and how it is done?
Types of Business Analytics4:41
Business Analytics are of three types viz Descriptive Analytics, Predictive Analytics & Prescriptive Analytics. All types are explained with examples.
A Caveat2:08
Descriptive Analytics - A little more about Descriptive Analytics6:18
Descriptive Analytics popularly known as Visualization. It is widely used Analytics portion. The details of Descriptive analytics is explained in this lecture.
Type of Charts and their general usage8:59
Excel has many charts option to create Visualization. This lecture covers some important charts and their typical usage
Predictive Analytics -Explained7:12
Predictive Analytics is the section of Business Analytics which helps you understand the future trend, behaviour of the process or outcome.
Prescriptive Analytics - Tools to prescrib best set of solutions using analytics4:39
Importance of Prescriptive analytics is explained in this lecture. Tools to conduct prescriptive analytics are also mentioned.
Decision Models5:34
Decision Models are foundation of the Analytics work. What is decision models? How to create Decision models?
Basics of Business Analytics

An Operation Problem4:30
Students will learn how to analyse a problem and create descriptive analytics for better understanding
News Vendor Problem - How Time Magazine saved millions by analysing the problem?6:55
News Vendor Problem is a generic problem in Operation analytics. Many problems in business fall under this category. The lecture also explains how Time Magazine saved millions by solving the news vendor problem.
Descriptive Analytics ( Statistics)10:08
Whenever a problem needs to be analysed, descriptive statistics should be created to get better perspective or understanding of the problem. This lecture explains how to go about creating descriptive analytics?
Descriptive Statistics in excel8:21
Some basic statistics everyone should know1:34
Descriptive Statistics and some common distributions are explained. Also how to calculate probability using excel and solve some common problems using these distributions are explained.
Discrete and Continuous Variables3:11
Discrete and continuous variables explained with appropriate examples.
Data Sources for Analytics6:22
Data Sources like Historical Data, Experimental Data & Expert Opinion are explained. You should never stop an analytics work for lack of data. This section will help students get a grasp of data sources for any analytics study.
Normal Distribution & its applications in business8:03
Normal distribution and calculation using Excel is explained.
Binomial Distribution and its applications in Business9:25
Binomial Distribution explained and also its application in business is explained.
Poisson Distribution and its applications in Business8:43
Descriptive Analytics - Understanding

Predictive Analytics - A brief on coverage1:16
Students will learn various techniques like Moving Average, Exponential Smoothening, Cyclic and Regression Correlation analysis in this section.
Introduction to Forecasting4:43
Forecasting with Scenario Analysis2:57
Students will learn about Scenario Analysis and how the technique can be used to paint future canvas.
Predictive Analytics with Moving Averages8:59
Students will learn about Moving average , it advantages, disadvantages.
Computing Moving averages and Mean Absolute Deviation in Excel4:57
Computation of Mean Square Error (MSE) & Mean Absolute Percentage Error (MAPE)7:44
Modeling Relationship with Excel8:30
Modeling is key to analytics. Students will learn about various modeling options in excel.
Predictive Analytics with Exponential Smoothening10:20
Students will learn about Forecasting with Exponential Smoothening
Correlation & Regression Analysis5:56
Students will learn about the technique of Correlation and regression and its industry applications.
Correlation & Regression in Excel6:07
A problem is taken here and explained how one should go about model the data using multiple regression analysis.
How to forecast data series having seasonality6:02
Understanding Forecasting of Data having seasonality.
Forecasting including Seasonality in Excel11:12
In this lecture identifying seasonality in data, calculating seasonal factors and predicting have been discussed.
Validating Understanding of Prescriptive Analytics

A Problem -Prescriptive Analytics with low uncertainty3:45
Students will learn about a class of problem with low uncertainty. It will help students to classify problems in their workplace and work with Prescriptive analytics
Understanding some key terms & assumptions used in Linear Programming7:10
Students will understand terms used in Linear Programming & assumptions for formulating such problems
Formulation of a LP Problem4:48
Formulation of a problem is most important part of Linear Programming. Once you have right formulation, the solution can be obtained by using excel functions very quickly.
Solving the Problem using Excel Solver8:09
Prescriptive Analytics under Uncertainty7:21
Most of the prosolve such problems and tools for solving the sameblems in business fall under this category. Students will learn about how to
Simulation using Excel - News Vendor Problem9:27
Students will learn Simulation process in excel. This lecture also explains various objectives under which decisions are taken.
Evaluating understanding of Prescriptive Analytics

Requirements

There is no prerequisite. It is preferred, one should be conversant with use of excel for day to day working. No knowledge of statistics, modelling and optimization is required.
It is important the students should be willing to learn and empower himself.

Description

If you are a manager or aspiring manager and you want to differentiate yourself or create a competitive advantage for you, Business Analytics with Excel is right course for you.

You will learn some important tools and techniques to proceed with Business Analytics of your own. This is a quick course. The techniques have been presented from practical perspective. You don’t need to get into complex mathematical and statistical modelling. Instead the focus is on understanding implications of various tools, learn interpreting and formulating problem and finally solve them using Excel.

In the book “Competing on analytics: The new science of winning”, Thomas Davenport claims that a significant proportion of high-performance companies have high analytical skills among their personnel. In a research by MIT Sloan Management Institute it has been found that 51 % companies used Analytics to gain competitive advantage while others have been struggling.

The answer is empowering each manager on analytics. This course is an attempt to empower every participant with analytics tools. This is about demystifying analytics. You will be able to do 80% of analytics related work yourself after this course. You may need specialist intervention in some complex cases. This course will help you getting competitive advantage and help you move faster in your career.

So, what are you waiting for?

Who this course is for:

The Course is aimed at Managers, Departmental Heads, Functional Heads who are responsible for managing and improving functional operations.
Anyone who aspires to take up managerial role and be responsible for managing and improving functional operations.
Anyone who is aspiring to improve one’s functional operations.

Business Analytics with Excel

What you'll learn

Explore related topics

Course content

Introduction to Business Analytics9 lectures • 51min

Diving Deep into Descriptive Analytics10 lectures • 1hr 7min

Diving Deep into Predictive Analytics12 lectures • 1hr 19min

Diving Deep into Prescriptive Analytics6 lectures • 41min

Summing-up & Bonus Lecture2 lectures • 19min

Requirements

Description

Who this course is for: