Introduction
- Introduction
- A little bit about me
- How this course will be organized?
- What to do if a blurry image appears
- How to reach additional resources
Basic tools, techniques and frameworks – Part 1
- Basic tools – introduction
- Bottom-up approach
- Top-down approach
- Ceramic tile market – Case Introduction
- Ceramic tile market - case to be solved
- Ceramic tile market - solution
- Ceramic tile market - solution in Excel
- Ceramic tile market - Presentation in Power Point
- Backward logic / backward reasoning
- Backward logic based decisions – Case Introduction
- Backward logic based decisions – Solution
- Backward logic based decisions – When it makes sense to use it
- Compounded effect
- Compounded effect – Case Study Introduction
- Compounded effect – Available Data
- Compounded effect – Solution
- Issue tree – Introduction
- Issue tree – Examples Introduction
- Issue tree – Logistics
- Issue tree – Retail
- Issue tree example for a FMCG firm
- Low hanging fruits
- Low hanging fruits – Case Studies
- Quick wins for cost reduction
- Quick wins for cost reduction – Remarks on Pontetial Savings
- Quick wins in Drugstore – Case Introduction
- Quick wins in Drugstore – Cost Structure
- Quick wins in Drugstore – Cost Reduction
- Quick wins in Drugstore – Summary
- Management Consulting Tools, Techniques, Frameworks Overview
Basic tools, techniques and frameworks – Part 2
- Setting Priorities
- Benchmarks – external and internal
- 80/20 rule in practice
- Set SMART goals
- Opportunity Tree
- Cost drivers
- KPIs and business drivers – Introduction
- Introduction to the KPIs for cinema case
- KPIs for cinema – case to be solved
- KPIs for cinema – solution
- KPIs for cinema - solution in Excel
- KPIs for cinema - Presentation in Power Point
- KPIs for marketplace – Problem
- KPIs for marketplace – Solution
- KPIs for marketplace – Alternative Solution
- KPIs for a FMCG business model – Problem
- Main drivers for FMG business model
- KPIs for a FMCG business model – Solution
- KPIs for SaaS – Problem
- Examples of SaaS businesses
- KPIs for SaaS – Solution
- Short Contest
- Excel – basic rules for every Management Consultant
- Resources that will help you master Excel
- Power Point – how it should be used by business analyst
- Basic tools – Summary
Intermediate tools, techniques and frameworks – Part 1
- Intermediate tools – Introduction
- Rankings – Introduction
- How to expand the brand – Introduction
- How to expand the brand – Solution – Part 1
- How to expand the brand – Solution – Part 2
- Expansion strategy into other countries - intro
- Expansion strategy into other countries – Case Introduction
- Expansion strategy into other countries – Data for the case study
- Expansion strategy into other countries – Which function to use
- Expansion strategy into other countries – Solution in Excel
- Expansion strategy into other countries – Solution in Power Point
- Rankings – Other examples
- Scenario analysis – Introduction
- Which price formula is the best for my profits – Introduction
- Which price formula is the best for my profits – Solution – T&M and fixed fee
- Which price formula is the best for my profits – Solution – Mixed Options
- Scenario analysis – How to shorten the lifespan of a product
- How to shorten the lifespan of a product – Case Introduction
- How to shorten the lifespan of a product – General rules
- How to shorten the lifespan of a product – Current Situation
- How to shorten the lifespan of a product – Fad
- How to shorten the lifespan of a product – Lower Costs
- How to shorten the lifespan of a product – Simplify Exchange
- How to shorten the lifespan of a product – Parameters
- How to shorten the lifespan of a product – Comparison
- How to shorten the lifespan of a product – Solution in Power Point
Intermediate tools, techniques and frameworks – Part 2
- Representative element analysis – Introduction
- Convenience stores - Analysis of tariffs – Introduction
- Convenience stores - Analysis of tariffs – Tips how to do it
- Convenience stores - Analysis of tariffs – Solution
- Decision Tree Analysis – Introduction
- Decision Tree Analysis – Solution
- OEE and OLE
- Theory of constraints and bottlenecks
