- Data analytics, statistics, data analysis - Fundamental knowledge of statistics, data analysis (including correlation, regression and segmentation) and forecasting methods - Growth (decay), index calculations
Understanding and implementing
Target audience
- Internal auditors
- Bankers / Account managers
- Consolidation and accounting managers
- Financial managers and controllers
- Chartered accountants
- Accounting managers
- Treasurers
3 day
Data Analysis Training - Transforming and adding value to information
In today's data-driven world, knowing how to exploit data has become a strategic skill. This data analysis course enables you to transform raw data into useful information, directly in Excel. You'll learn how to structure, cross-reference and visualize data to extract meaning and guide your decisions.
Designed for operational or financial professionals, this course will give you the tools to automate analyses and develop your analytical autonomy, without depending on an IT department.
Prerequisites
This module requires a good knowledge of statistical analysis and Excel, acquired for example through the following training courses "Mastering fundamental data calculations" and and "Techniques for analyzing large volumes of data (Advanced Excel)". from our training catalog.
Objectives
- Understand how Data Science and Artificial Intelligence can help answer questions, make decisions and contribute to performance improvement
- Transform raw data into relevant information you can act on
- Know and understand the main analytical and predictive tools
- Discover complete use cases for these tools in real-life situations
Contents and case studies
> Introduction: a reminder of the principles of Data project management - Starting from the formulation of a business problem - Data Mining methodology (CRISP) - Action indicators adapted to the activity
> Management modeling and constrained optimization
- Modeling tools in Excel
- Solving linear and non-linear problems
- Illustration with 2 complete cases
> Predictive models, artificial intelligence algorithms, learning from a dataset, supervised and unsupervised approaches, use cases
- How to measure the effective impact of an action lever (linear regression - illustration with a business case in Excel - impact on sales of an action on sales prices)
- How to answer a business question on a characteristic (logistic regression, business case in Excel: identifying erroneous OD)
- How to create meaningful management groupings (categories, segmentation, classification tree) - hierarchical and non-hierarchical methods - case study in Excel
- How to make a qualitative forecast based on a documentary source and text analysis (application of Bayesian probabilities - case study in Excel: project delays based on e-mail readings)
- How to produce quantitative forecasts (moving averages and exponential smoothing) and check their quality
> Conclusion: ensure the relevance of output - Conformity and relevance to the desired objective
Why train in data analysis?
Would you like to initiate, develop or simply contribute to a Data-driven approach? Would you like to know which business questions can be answered using Data? Do your issues concern marketing, logistics, production management, human resources, quality, treasury or management control?
This affordable training course is at the heart of the Data Analytics competency.
Teaching and assessment methods
Before : self-assessment quiz
During the session: one complete business case per theme. Work in small groups and plenary discussions. Excel templates provided. Numerous practical exercises to validate the acquisition of skills at each stage.
After: the participant keeps all Excel templates.
The trainer is available to answer any questions relating to the training.
General training | FinHarmony Conseil & Formation
See our full training catalog.
Price
2,750 EXCL. TAX
Media
Testimonials
data science training
data science training
data science training
data science training
Jonathan C.
Company
Training