Introduction
- Introduction
- How this course is organized
- Who is business analyst
- What to do if a blurry image appears
- How to find additional resources
Main tools and techniques used by Business Analyst
- Main tools and techniques - introduction
- Excel - basic rules for every Business Analyst
- Excel – Main functions you should master
- What you can use the VLOOKUP for?
- Basic VLOOKUP usage
- Some comments on basic VLOOKUP
- How to assign categories using VLOOKUP?
- How to use HLOOKUP?
- How to assign categories based on 2 criteria using VLOOKUP and MATCH function?
- How to assign categories based on 2 criteria using HLOOKUP and VLOOKUP function
- Why NOT to use IF function
- How to use if function?
- How to use VLOOKUP instead of IF function?
- How to use IFERROR function?
- How to use MAX and MIN instead of IF function
- Pivot tables - introduction
- Power Point - how it should be used by business analyst
- Bottom-up approach
- Top-down approach
- Estimating the costs of a wedding – Introduction
- Estimating the costs of a wedding – Partial Solution
- Estimating the costs of a wedding – Excel Part 1
- Estimating the costs of a wedding – Excel Part 2
- Backward logic
- Backward logic based decisions – Case Introduction
- Backward logic based decisions – Solution
- Backward logic based decisions – When it makes sense to use it
- Compounded effect
- Issue tree
- Issue tree – Examples Introduction
- Issue tree – Logistics
- Issue tree – Retail
- Issue tree – FMCG
- Opportunity Tree
- OEE and OLE
- Cost drivers
- Theory of constraints and bottlenecks
- Preparation for consulting project and Issue Tree
Business modeling - example of analyses
- Business Modeling - introduction
- E-commerce business model - intro
- E-commerce business model - Excel example
- Business model of a restaurant in Excel - basic model
- Business model of a restaurant in Excel - advanced model
- Restaurant chain - how to model it in Excel?
- Mechanics of business model for a consulting firm
- The business model of a consulting firm in Excel - Capacity and revenues
- The business model of a consulting firm in Excel - costs and profit & loss
- Financial models vs Business Models
- What to study if you want to learn more
Sales and marketing analyses - examples
- Sales and marketing analyses - introduction
- Catchment area / reach analysis - B2B
- Efficiency of marketing activities
- Sales and margin efficiency in retail
- Sales channel analysis - case in FMCG
- Saturating existing markets – Introduction
- Saturating existing markets – Data for the case study
- Saturating existing markets – Number of Stores
- Saturating existing markets – Data by Concepts
- Saturating existing markets – Stores by concepts
- Saturating existing markets – Concept & Space
- Saturating existing markets – Solution in Power Point
- Saturating existing markets – WaterFall Chart
- Product range analysis - Introduction
- Product range analysis - Example
- How to expand the brand – Introduction
- How to expand the brand – Solution – Part 2
- How to expand the brand – Solution – Part 1
- How to find the white spaces untouched by your brand – Introduction
- How to find the white spaces untouched by your brand – Solution – Per capita
- How to find the white spaces untouched by your brand – Solution – Local shares
- How to find the white spaces untouched by your brand – Solution – Presentation
- Sales force efficiency analysis – Introduction
- Sales force efficiency analysis – Solution – Unit Cost
- Sales force efficiency analysis – Solution – ABC analysis of Current Solution
- Sales force efficiency analysis – Solution – more on Current Solution
- Sales force efficiency analysis – Solution – Margin Maximazation
- Sales force efficiency analysis – Solution – Specialization
- Sales force efficiency analysis – Solution – Summary
- Sales force efficiency analysis – Practical Tips
- What to study if you want to learn more
Operations - Production, Supply Chain - examples of analyses
- Operation analyses - introduction
- OEE analysis
- Removing bottlenecks
- Optimal production batch analysis - FMCG
- 2-stage production planning - example of cosmetics producers preparing bundles
- Finding the best spot for your factory – Introduction
- Finding the best spot for your factory – Cost comparison - Excel
- Finding the best spot for your factory – NPV for every project - Excel
- Top-dow approach for a FMCG - introduction
- Top down approach for a FMCG - tips how to do it
