Understanding and implementing
Target audience
- Accountants
- Consolidators
- Controllers
- Financial managers and controllers
- Finance, consolidation and accounting managers
2 day
Data analysis training
Prerequisites
No prior knowledge required
Objectives
◗ Use data to solve problems, answer questions and suggest solutions
◗ Adopt best practices for visual communication
◗ Increase the impact of your presentations
◗ A commitment to continuous, sustainable improvement
Contents
◗ Using data to answer management questions
- Descriptive, predictive, prescriptive analysis
- Clarify a problem, identify a deviation, search for root causes
- The feedback loop and the quality management approach
✔ UNDERSTANDING | Illustration: analysis typology (what happened? why? what happened next?)
✔ APPLY | Case study: structuring a problem situation based on a business case
✔ EVALUATE | Quiz: in your opinion... How can we make it happen?
◗ Data collection, processing and reliability
- General model: data processing (ETL) collect, process, return
- Application in Excel: import, consultation, preparation and export tools
- Collection biases and data quality
- Variables, transforming a qualitative variable into a discrete variable
✔ UNDERSTAND | Guided study: general diagram of data flows and associated tools
✔ APPLY | Case study: preparing a cleaned and documented database in Excel
✔ ASSESS | Quiz: what do you think... How do you detect a collection bias in an Excel table?
◗ Solve a problem using modeling
- Simple and multiple regression, correlation, causation
- Excel tools: regression line, slope, ordinate, R²
- Using regression as a forecasting tool
✔ UNDERSTAND | Activity: putting problem-solving steps back in order
✔ APPLY | Case study: building a multiple regression on explanatory variables
✔ APPLY | Group brainstorming: can you think of possible applications in your
your professional environment?
✔ ASSESS | Quiz: in your opinion... How do you identify a cause-and-effect relationship?
◗ Simulate to suggest solutions
- Target value, solver, constrained optimization
- Four stages: objectives, decisions, constraints, resolution mode
- Sensitivity studies, scenarios, simulating variability in Excel
- Statistical tests to accept or reject a result
✔ APPLIQUER | Case study: building a loan simulation with the Table tool
✔ APPLY | Case study: optimizing a production plan with the Solver tool
✔ EXPERIMENTALIZE | Case study: how to build a sensitivity model
✔ EVALUATE | Quiz: in your opinion... How confident are you in the results obtained?
◗ Restore data to convince
- Choosing indicators, crossing dimensions, changing perspective
- Data storytelling, visual narration, dataviz spirit
- Building a relevant, visual dashboard
✔ APPLY | Case studies: practical application to real-life issues in sub-groups
with a theme assigned to each group
✔ EXPERIMENTALIZE | Workshop: create an impactful pitch in 3 minutes with supporting graphics.
✔ EVALUATE | Quiz: in your opinion... What approach to redesigning the performance management framework?
Why choose this course?
This course is designed to strengthen corporate performance management and management dialogue. It provides techniques for using data, putting it into visual form using the dataviz standard, and structuring messages to increase their impact. A practical workshop in sub-groups enables participants to apply the tools and new skills by producing a production that can be reused in the workplace.
Pedagogy and assessment methods
Before: self-assessment quiz
During the session : alternating theoretical developments, illustrations and case studies. Several Excel templates are provided, as well as practical worksheets. At the end of the day, a workshop is held to put the acquired skills into practice.
Afterwards: the trainer is available to answer any questions relating to the training.
Price
2,090 EXCL. TAX
Testimonials
Data analysis training
Data analysis training
Data analysis training
Jonathan C.
Company
Training