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, especially in PowerPoint.

◗ Commit to a process of continuous and sustainable improvement.

Training program

◗ Using data to answer management questions

– Descriptive, predictive, and prescriptive analysis
– Clarifying a problem, identifying a deviation, and root cause analysis
– The feedback loop and the quality approach in management
✔ UNDERSTAND | Illustration: Types of Analysis (What happened? Why? What next?)
✔ EVALUATE | Quiz: In your opinion… How can we make this happen?
✔ APPLY | Practical case study: Structuring a problem situation based on a business case

◗ Data collection, processing and reliability

– General Model: Data Processing (ETL)—Collect, Process, Deliver
– Application in Excel: Tools for Importing, Viewing, Preparing, and Exporting Data
– Collection Bias and Data Quality
– Variables: converting a qualitative variable into a discrete variable
✔ UNDERSTAND | Guided study: general data flow diagram and associated tools
✔ APPLY | Practical exercise: preparing a cleaned and documented database in Excel
✔ EVALUATE | Quiz: In your opinion… How can you detect collection bias in an Excel table?

◗ Solve a problem using modeling

– Simple and multiple regression, correlation, cause-and-effect relationships
– Excel tools: regression line, slope, y-intercept, R²
– Using regression as a forecasting tool
✔ UNDERSTAND | Activity: Put the problem-solving steps in order
✔ APPLY | Practical exercise: Build a multiple regression model using explanatory variables
✔ APPLY | Group discussion: Can you think of any possible applications in your professional environment?
✔ EVALUATE | Quiz: In your opinion… How can you identify a cause-and-effect relationship?

◗ Simulate to suggest solutions

– Target value, solver, constrained optimization
– Four steps: objectives, decisions, constraints, solution method
– Sensitivity analysis, scenarios, simulating variability in Excel
– Understanding statistical tests to accept or reject a result
✔ APPLY | Practical example: Build a loan simulation usingtheTable tool
✔ APPLY | Practical example: Optimize a production plan using Solver
✔ EXPERIMENT | Hands-on exercise: Step-by-step guide to building a sensitivity model
✔ EVALUATE | Quiz: In your opinion… How confident are you in the results obtained?

◗ Restore data to convince

– Selecting indicators, cross-analyzing dimensions, shifting perspectives
– Data storytelling, structured argumentation, visual storytelling, the dataviz mindset
– Creating a PowerPoint presentation that makes an impact
✔ APPLY | Practical exercise: applying concepts to real-world issues in small groups, with a specific theme assigned to each group
✔ EXPERIMENT | Workshop: creating a compelling 3-minute pitch with supporting graphics
✔ EVALUATE | Quiz: In your opinion… What approach should be taken to redesign the performance management framework?

Why choose this course?

This training program helps strengthen corporate performance management and management dialogue. It provides techniques for using data, visualizing it according to data visualization standards, and structuring messages to maximize their impact. A hands-on workshop in small groups allows participants to apply the tools and new skills by creating a deliverable that can be reused in the workplace.

Teaching and assessment methods

Before the training: Submit your expectations via your online portal 15 days before the training begins and complete a self-assessment of your skills.

Teaching Methods: A variety of teaching methods to cater to different learning styles, encourage active participation, and reinforce learning through experimentation and practice.

Educational materials: presentation materials, reference materials (summary sheets, tables, etc.), and other resources available in your account.

During the training: theoretical concepts are alternated with examples drawn from real-life cases. Participants are given the opportunity to engage in role-playing exercises. Numerous practical exercises allow participants to demonstrate their mastery of the skills as the training progresses.

Training monitoring and evaluation: attendance sheet and certificate of completion. Immediate and post-training evaluations conducted using the LearnEval platform.

Price

2,090 EXCL.

Testimonials

Data analysis training

Jonathan C.
Company
Training

Generalist trainings

Data analysis training