1) Understand the supply chain and all its indicators for all industries
Detailed explanations of supply chain processes with the necessary indicators :
1) KPIs Retail & Stores
2) KPIs E-commerce
3) KPIs Distributor / FMCG
4) KPIs Warehouses / Logistics
5) KPIs Transport / Import / Export
6) KPIs Industry / Production / Agribusiness
7) KPIs Purchasing / Procurement / Sourcing
8) KPIs Production Raw materials
2) Select the essential KPIs without falling into the expert syndrome
-I will tell you how to quickly identify the essential KPIs (20/80) for your business
-Where to start immediately to get quick results (a common problem in small businesses)
-Without falling into the expert syndrome and getting lost in details that will impair your performance (classic mistake in large groups)
3) Extract and clean data from your ERP/Software to Excel
-Identify the data to extract for your KPIs
-How to extract them from your ERP / Software / WMS / TMS / BI even if you are not a computer scientist
-How to automatically clean them on Excel and stop wasting hours every week manipulating them
-Finally have reliable data and stop driving your supply chain blindly
4) Calculate the indicators: all the rules with real examples
-All calculation rules are explained simply
-No need to be a mathematician, I will give you examples on Excel with tens of thousands of articles
-Concrete examples in supply chain with ERP extractions to practice and learn quickly
5) Create an effective dashboard that will impress your management
-Create an effective dashboard in less than 2 hours
-Create a design that will make a strong impression with your management (it allowed me to become a Supply Chain Manager and to have a visa for Australia 😉 )
-Calculate your indicators on several sites (store, factory, warehouses..)
-Master the latest Excel functions like advanced charts and graphs
-9 complete Excel dashboards to download covering the entire supply chain and all industries
-I share my screen and create step by step these dashboards with tens of thousands of articles.
6) Automate the update and then migrate to software (BI, ERP, WMS..)
-How to automate its update in 1 click to finally start analyzing your performance on Monday at 9:30 am (and not on Tuesday night 😉 )
-The new Excel structure which I recommend to simplify everything (I discovered it very recently)
-How to use these reports as specifications to set them up on a BI or ERP software (Power BI, Qlick, Business Object, Tableau)
7) Analyze your Dashboard to get straight to the essentials
-I will tell you how I have been analyzing my dashboards for 15 years to always stay focused on the most important
-My Macro/Micro 20/80 method applied to many examples
-Concrete examples with thousands of articles (overstocks, forecasts...)
8) Improve your performance and have long term results
-Set realistic and ambitious goals at the same time
-How to improve your results and empower all departments
-How to not stay disconnected from the field
-Mistakes to avoid so as not to fall back into the daily management of fires (firefighter)
BONUS 1 : My benchmarking database of the KPIs of hundreds of companies
I will analyze and share the indicators of hundreds of companies and on all sectors of activity to help you compare and set short-term and long-term goals for your supply chain.
BONUS 2 : Improve and boost the performance of your TEAMS
-You cannot have a successful supply chain without safe, motivated, and fulfilled teams.
-I will share with you how I have been improving the performance of my teams for 10 years without "policing"
-KPIs and Excel dashboards that I use
BONUS 3 : Measure & reduce the impact of your supply chain on our PLANET
-Don't wait any longer for your management to start measuring the impact of your supply chain on the planet
-Simple and concrete action plan to get started immediately
-KPIs and CSR standards that I recommend
BONUS 4 : 2 video COACHING with Edouard
-Have you got a question, are you stuck or finding something difficult?
-I analyze your work on video
-Direct and honest feedback on your dashboard, KPIs, analysis, presentation before a management committee
BONUS 5 : OFFICIAL CERTIFICATE TO BOOST YOUR CV & LINKEDIN
At the end of this program, receive an official SCM Metrics certificate to prove your expertise in this strategic competence in supply chain and boost your CV and career
BONUS 6 : 8 NEW AUTOMATIC DASHBOARDS POWER QUERY-PIVOT
NEW UPDATE : For each module, I will explain how to build a dashboard with the "classic" and the "power query' way...
I reveal how to create a dashboard 5 times lighter and automatic using the power of Power Query and Power Pivot. It's much easier than you think and will be able to handle millions of rows in a few clicks.
(Free update for all new and old SCM Metrics members.)
A complete 8-step method to measure your performance and have lasting results
Discover all the essential indicators for the entire supply chain.
I will explain how to set up a SIMPLE, EFFICIENT, and AUTOMATIC dashboard with very useful Excel formulas.
Master the 5 essential pillars to measure your performance sustainably
Something that many people find difficult: extract data from your ERP and make it reliable.
I will tell you how to build 9 complete dashboards with tens of thousands of articles to get to the essential and impress your management
I will share with you the KPIs of hundreds of companies to help you set realistic and ambitious goals in your industry (+30 industries)
Design dynamic KPIs map in less than 10 minutes for your warehouse, factory, store, plant. You can then display or print them to share with your team.
In my new update, I will show you how to use the full power of Power Query and Power Pivot to create even lighter, powerful, and automatic dashboards. (much easier than creating macro and 50 times more powerful 🚀 )