Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Data Analysis
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Meditation Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Leadership
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing Startup YouTube Marketing

BusinessBusiness Analytics & IntelligenceBusiness Analysis

How to become world class Business Analyst - Cases in Excel

A practical guide on how to do business analysis in Excel especially of sales and operations
Rating: 4.5 out of 54.5 (353 ratings)
4,130 students
Created by Asen Gyczew
Last updated 6/2022
English
English [Auto]

What you'll 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

Requirements

  • Basic or intermediate Excel

Description

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 or supervised over 90 different performance improvement projects in different industries that generated in total 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 124 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, tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, 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 modification, 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, Chief Restructuring Officer VP responsible for Strategy and Development) still have huge problems with proper 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 the 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 operational and strategic analyses in FMC, SMCG, B2B companies including also online models like e-commerce, SaaS, marketplaces.

In what way will you benefit from this course?

The course is a practical, step-by-step guide loaded with tones of analyses, tricks, 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 a 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 aspects of sales, marketing, operations?

  • How to draw conclusions from those analyses – both for current operations as well as strategic ones?

  • How to be efficient in your work as an analyst?

  • How to build Excels and PowerPoints so that it is understandable for 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, 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, and efficiency, 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 the 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 to short analytical cases 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 easiely modified to meet your needs

Who this course is for:

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

Instructor

Asen Gyczew
Expert in performance improvement, turnaround and startups
Asen Gyczew
  • 4.5 Instructor Rating
  • 28,877 Reviews
  • 140,517 Students
  • 64 Courses

Expert in performance improvement, scaling businesses, and turning-around companies with significant experience both in management as well as in supervision of medium size companies (EUR 20 – 500 million) and startups. I have trained in person over 100 consultants, business analysts, and managers who now are Investment Directors, CEO, Partners in PE and VC funds, Sales and Marketing Directors, Operational  Directors, COO, Directors in Consulting Companies, Supply Chain Directors, Board Members, etc.


Functional experience:
performance improvement, strategy development, startups, intrapreneurship, post-merger integration and cost reduction, due diligence, turn-arounds, PMO; 

 Industry experience: SMCG (domestic appliances, furniture, ceramic tiles), FMCG (cosmetics, juice, meat), retail (electronics, convenience shops, pharmaceuticals, DIY, vending, fashion, toys), B2B (aluminum system, plywood, alcohol, reagents, loading systems), services (MRO, consulting, outsourcing), foodtech, marketplaces

Countries: Poland, Serbia, Russia, Ukraine 

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.