Business Analytics with Excel
Business Analytics with Excel, available at $54.99, has an average rating of 3.7, with 39 lectures, 4 quizzes, based on 57 reviews, and has 233 subscribers.
You will learn about 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. This course is ideal for individuals who are The Course is aimed at Managers, Departmental Heads, Functional Heads who are responsible for managing and improving functional operations. or Anyone who aspires to take up managerial role and be responsible for managing and improving functional operations. or Anyone who is aspiring to improve one’s functional operations. It is particularly useful for The Course is aimed at Managers, Departmental Heads, Functional Heads who are responsible for managing and improving functional operations. or Anyone who aspires to take up managerial role and be responsible for managing and improving functional operations. or Anyone who is aspiring to improve one’s functional operations.
Enroll now: Business Analytics with Excel
Summary
Title: Business Analytics with Excel
Price: $54.99
Average Rating: 3.7
Number of Lectures: 39
Number of Quizzes: 4
Number of Published Lectures: 39
Number of Published Quizzes: 4
Number of Curriculum Items: 43
Number of Published Curriculum Objects: 43
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will 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.
Who Should Attend
- 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.
Target Audiences
- 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.
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?
Register now and empower your career!
Course Curriculum
Chapter 1: Introduction to Business Analytics
Lecture 1: Course Structure
Lecture 2: What is Business Analytics?
Lecture 3: Types of Business Analytics
Lecture 4: A Caveat
Lecture 5: Descriptive Analytics – A little more about Descriptive Analytics
Lecture 6: Type of Charts and their general usage
Lecture 7: Predictive Analytics -Explained
Lecture 8: Prescriptive Analytics – Tools to prescrib best set of solutions using analytics
Lecture 9: Decision Models
Chapter 2: Diving Deep into Descriptive Analytics
Lecture 1: An Operation Problem
Lecture 2: News Vendor Problem – How Time Magazine saved millions by analysing the problem?
Lecture 3: Descriptive Analytics ( Statistics)
Lecture 4: Descriptive Statistics in excel
Lecture 5: Some basic statistics everyone should know
Lecture 6: Discrete and Continuous Variables
Lecture 7: Data Sources for Analytics
Lecture 8: Normal Distribution & its applications in business
Lecture 9: Binomial Distribution and its applications in Business
Lecture 10: Poisson Distribution and its applications in Business
Chapter 3: Diving Deep into Predictive Analytics
Lecture 1: Predictive Analytics – A brief on coverage
Lecture 2: Introduction to Forecasting
Lecture 3: Forecasting with Scenario Analysis
Lecture 4: Predictive Analytics with Moving Averages
Lecture 5: Computing Moving averages and Mean Absolute Deviation in Excel
Lecture 6: Computation of Mean Square Error (MSE) & Mean Absolute Percentage Error (MAPE)
Lecture 7: Modeling Relationship with Excel
Lecture 8: Predictive Analytics with Exponential Smoothening
Lecture 9: Correlation & Regression Analysis
Lecture 10: Correlation & Regression in Excel
Lecture 11: How to forecast data series having seasonality
Lecture 12: Forecasting including Seasonality in Excel
Chapter 4: Diving Deep into Prescriptive Analytics
Lecture 1: A Problem -Prescriptive Analytics with low uncertainty
Lecture 2: Understanding some key terms & assumptions used in Linear Programming
Lecture 3: Formulation of a LP Problem
Lecture 4: Solving the Problem using Excel Solver
Lecture 5: Prescriptive Analytics under Uncertainty
Lecture 6: Simulation using Excel – News Vendor Problem
Chapter 5: Summing-up & Bonus Lecture
Lecture 1: Summing-up
Lecture 2: Bonus Lecture – Construct your Investment Portfolio using Analytics
Instructors
-
Dr Bishram
Author, Trainer & Management Consultant, Visiting Professor
Rating Distribution
- 1 stars: 4 votes
- 2 stars: 3 votes
- 3 stars: 13 votes
- 4 stars: 11 votes
- 5 stars: 26 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024