How to become world class Business Analyst – Cases in Excel

How to become world class Business Analyst – Cases in Excel, available at $74.99, has an average rating of 4.65, with 167 lectures, based on 489 reviews, and has 5653 subscribers.

You will learn about Kill any discussion with solid data analyses Do the analyses 10x faster Structure complex problems and solve them in Excel Perform the analyses in a very effective manner Understand the main challenges in analyzing different aspects in sales, marketing and operations Build business models for e-commerce, service companies and B2C services You will get ready made examples of complex analyses from top-notch consulting companies You will learn what kind of analyses can be performed during a management consulting project This course is ideal for individuals who are Business analysts or Researchers or Controllers or Consultants or Small and medium business owners or Startup founders or Students considering entering management consulting It is particularly useful for Business analysts or Researchers or Controllers or Consultants or Small and medium business owners or Startup founders or Students considering entering management consulting.

Enroll now: How to become world class Business Analyst – Cases in Excel

Summary

Title: How to become world class Business Analyst – Cases in Excel

Price: $74.99

Average Rating: 4.65

Number of Lectures: 167

Number of Published Lectures: 167

Number of Curriculum Items: 167

Number of Published Curriculum Objects: 167

Original Price: $189.99

Quality Status: approved

Status: Live

What You Will Learn

Kill any discussion with solid data analyses
Do the analyses 10x faster
Structure complex problems and solve them in Excel
Perform the analyses in a very effective manner
Understand the main challenges in analyzing different aspects in sales, marketing and operations
Build business models for e-commerce, service companies and B2C services
You will get ready made examples of complex analyses from top-notch consulting companies
You will learn what kind of analyses can be performed during a management consulting project

Who Should Attend

Business analysts
Researchers
Controllers
Consultants
Small and medium business owners
Startup founders
Students considering entering management consulting

Target Audiences

Business analysts
Researchers
Controllers
Consultants
Small and medium business owners
Startup founders
Students considering entering management consulting

What is the aim of this course?

This course will help you drastically improve your knowledge and skills in business analysis through a series of practical cases. It is designed for people who want to become business analysts or do a lot of business analyses at their work.

This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated in a total of 2 billion of additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 224 000 students including people working in EY, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

I teach through case studies, so you will have a lot of lectures showing examples of analyses, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and materials shown in the lectures so as a part of this course you will also get a library of ready-made analyses that can, with certain modifications, be applied by you or your team in your work.

Why have I decided to create this course?

The companies I have worked with so far as a Board Member (I am usually, the Chief Restructuring Officer, VP responsible for Strategy and Development) still have huge problems with properly analyzing intermediate and advanced issues – they are usually preoccupied with current activities, and have close to no time for business analysis and strategic decision. Moreover, they do not know how to approach any subject from an analytical point of view to make sure that they are making the right decision. Therefore, quite often they hire consultants who in turn lack the practical knowledge and experience. This course is my small contribution to improving both consulting as well as operational and strategic analyses in FMC, SMCG, and B2B companies including also online models like e-commerce, SaaS, and marketplaces.

In what way will you benefit from this course?

The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you do the business analyses as well as the quality of the conclusions coming out of available in your company data. Every business analysis is well described and presented in the form of Excel, attached to the lecture. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course, you will know:

How to analyze different aspectsof sales, marketing, and operations?
How to draw conclusions from those analyses – both for current operations as well as strategic ones?
How to be efficientin your work as an analyst?
How to build Excels and PowerPoints so that it is understandablefor you and your team, even after some time?
Chose the right business analysis to identify problems and opportunities

You can also ask me any question either through the discussion mode or by messaging me directly.

How the course is organized?

The course is divided into the following sections:

Introduction.We begin with a little intro into the course as well as some general info on the role of business analyst – what skills, education, and knowledge is required from you and what are the available career paths for you
Tools.In the second section, we briefly go through the main tools and concepts for business analysts. We devote some time to the most popular ones: Excel and PowerPoint
Business modeling – example of analyses. On some occasions, you analyze the whole business to see what is the logic behind it. Here we show how to prepare the model in Excel for some of the business models
Sales & Marketing. Analyzing the market, sales activities, efficiency, and the potential for expansion are some of the most typical tasks set for business analysts. Here I provide you with plenty of practical real-life examples of problems and solutions. Every business analysis also shows you the potential for increased sales or margin.
Operations. Quite often business performance depends on Operational Excellence. In this section, we will show you examples of analysis from logistics, production, production planning, and other supply chain issues. Every business analysis here will show you possible savings or opportunities to increase capacity.
Management Consulting Presentations.In this section, I will show you the essential things you need to create a consulting presentation during management consulting projects.
Cases for training analytical skills.In the last 4 sections, we will show you a lot of short analytical case studies that will help you improve your analytical skills.

You will be able also to download many additional resources

Excels with analyses shown in the course
Presentation of slides shown in the course
Links to additional presentations and movies
Links to books worth reading
Every business analysis is well described, available as a downloadable Excel file, and can be easily modified to meet your needs

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: How this course is organized

Lecture 3: Who is business analyst

Lecture 4: What to do if a blurry image appears

Lecture 5: How to find additional resources

Chapter 2: Main tools and techniques used by Business Analyst

Lecture 1: Main tools and techniques – introduction

Lecture 2: Excel – basic rules for every Business Analyst

Lecture 3: Excel – Main functions you should master

Lecture 4: VLOOKUP – Introduction

Lecture 5: VLOOKUP with approximate match – Introduction

Lecture 6: What you can use the VLOOKUP for?

Lecture 7: Basic VLOOKUP usage

Lecture 8: Some comments on basic VLOOKUP

Lecture 9: How to assign categories using VLOOKUP?

Lecture 10: How to use HLOOKUP?

Lecture 11: The logic of MATCH function

Lecture 12: How to assign categories based on 2 criteria using VLOOKUP and MATCH function?

Lecture 13: How to assign categories based on 2 criteria using HLOOKUP and VLOOKUP function

Lecture 14: Why NOT to use IF function

Lecture 15: How to use if function?

Lecture 16: How to use VLOOKUP instead of IF function?

Lecture 17: How to use IFERROR function?

Lecture 18: How to use MAX and MIN instead of IF function

Lecture 19: Pivot tables – introduction

Lecture 20: Power Point – how it should be used by business analyst

Lecture 21: Bottom-up approach

Lecture 22: Top-down approach

Lecture 23: Estimating the costs of a wedding – Introduction

Lecture 24: Estimating the costs of a wedding – Partial Solution

Lecture 25: Estimating the costs of a wedding – Excel Part 1

Lecture 26: Estimating the costs of a wedding – Excel Part 2

Lecture 27: Backward logic

Lecture 28: Backward logic based decisions – Case Introduction

Lecture 29: Backward logic based decisions – Solution

Lecture 30: Backward logic based decisions – When it makes sense to use it

Lecture 31: Compounded effect

Lecture 32: Issue tree

Lecture 33: Issue tree – Examples Introduction

Lecture 34: Issue tree – Logistics

Lecture 35: Issue tree – Retail

Lecture 36: Issue tree – FMCG

Lecture 37: Opportunity Tree

Lecture 38: OEE and OLE

Lecture 39: Cost drivers

Lecture 40: Theory of constraints and bottlenecks

Chapter 3: Business modeling – example of analyses

Lecture 1: Business Modeling – introduction

Lecture 2: E-commerce business model – intro

Lecture 3: E-commerce business model – Excel example

Lecture 4: Business model of a restaurant in Excel – basic model

Lecture 5: Business model of a restaurant in Excel – advanced model

Lecture 6: Restaurant chain – how to model it in Excel?

Lecture 7: Mechanics of business model for a consulting firm

Lecture 8: The business model of a consulting firm in Excel – Capacity and revenues

Lecture 9: The business model of a consulting firm in Excel – costs and profit & loss

Lecture 10: Financial models vs Business Models

Lecture 11: Other busines models

Lecture 12: What to study if you want to learn more

Chapter 4: Sales and marketing analyses – examples

Lecture 1: Sales and marketing analyses – introduction

Lecture 2: Catchment area / reach analysis – B2B

Lecture 3: Efficiency of marketing activities

Lecture 4: Sales and margin efficiency in retail

Lecture 5: Sales channel analysis – case in FMCG

Lecture 6: Saturating existing markets – Introduction

Lecture 7: Saturating existing markets – Data for the case study

Lecture 8: Saturating existing markets – Number of Stores

Lecture 9: Saturating existing markets – Data by Concepts

Lecture 10: Saturating existing markets – Stores by concepts

Lecture 11: Saturating existing markets – Concept & Space

Lecture 12: Saturating existing markets – Solution in Power Point

Lecture 13: Saturating existing markets – WaterFall Chart

Lecture 14: Product range analysis – Introduction

Lecture 15: Product range analysis – Example

Lecture 16: How to expand the brand – Introduction

Lecture 17: How to expand the brand – Solution – Part 1

Lecture 18: How to expand the brand – Solution – Part 2

Lecture 19: How to find the white spaces untouched by your brand – Introduction

Lecture 20: How to find the white spaces untouched by your brand – Solution – Per capita

Lecture 21: How to find the white spaces untouched by your brand – Solution – Local shares

Lecture 22: How to find the white spaces untouched by your brand – Solution – Presentation

Lecture 23: Sales force efficiency analysis – Introduction

Lecture 24: Sales force efficiency analysis – Solution – Unit Cost

Lecture 25: Sales force efficiency analysis – Solution – ABC analysis of Current Solution

Lecture 26: Sales force efficiency analysis – Solution – more on Current Solution

Lecture 27: Sales force efficiency analysis – Solution – Margin Maximazation

Lecture 28: Sales force efficiency analysis – Solution – Specialization

Lecture 29: Sales force efficiency analysis – Solution – Summary

Lecture 30: Sales force efficiency analysis – Practical Tips

Lecture 31: Overview of segmentation methods

Lecture 32: What to study if you want to learn more

Chapter 5: Operations – Production, Supply Chain – examples of analyses

Lecture 1: Operation analyses – introduction

Lecture 2: OEE analysis

Lecture 3: Removing bottlenecks

Lecture 4: Optimal production batch analysis – FMCG

Lecture 5: 2-stage production planning – example of cosmetics producers preparing bundles

Lecture 6: Finding the best spot for your factory – Introduction

Instructors

Asen Gyczew
Expert in performance improvement, turnaround and startups

Rating Distribution

1 stars: 17 votes
2 stars: 25 votes
3 stars: 60 votes
4 stars: 156 votes
5 stars: 231 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!

Menu