Implementing data modeling and analysis
- Collaboration and relational management - Collaborative logic and relational management - Ability to decipher non-verbal language - Ability to convey meaning, to be a pedagogue - Ability to engage in dialogue and share an analysis - Ability to argue in adversarial debate - Ability to challenge, formulate convictions and sound the alarm
- Data analytics, statistics, data analysis - Fundamental knowledge of statistics, data analysis (including correlation, regression and segmentation) and forecasting methods - Growth (decay), index calculations
- Modeling, simulation, scenarios - Modeling, simulation, scenarios
- Spreadsheets for finance (Excel ) - Mastery of spreadsheets for finance
Mastering a complex environment
Target audience
- Internal auditors
- Researchers
- Management controllers
- Consolidation and accounting managers
- Finance managers
- Anyone who has to handle and synthesize large volumes of data.
2 day
New training
Prerequisites
This course requires Excel 2010 or higher and a good level of Excel skills.
Objectives
- Discover Microsoft's new restitution and visualization tools
- Familiarize yourself with the concept of data analysis
- Leverage the power of the Excel-Power Pivot binomial to create new types of reports and analyses
- Know how to produce relevant summaries and analyses from large volumes of data
Contents
> Introduction (a little more clarity...)
- Clarify the notions of Big Data, AI, Business intelligence, Data Analytics, etc.
- The data revolution and management control
- What are the tools? What are they used for? Power Pivot's contribution to Excel
> A little vocabulary
- Familiarize yourself with the concepts of dimension, hierarchy, fact table, measurements, granularity, etc.
> Handling (based on a case study)
- Interface overview
- The 5-step work cycle
a) Understanding the need/problem
b) Identify sources
c) Connection, import
d) Data model creation and management
e) Report creation
> DAX language
> Data processing and reporting
- Objects and segments
- Creating KPIs
- Successful presentations
> Further information
- The Power Query alternative
- Ambiguity, multiple fact tables, (n-n) relationships, model (de)normalization
Why choose this course?
Welcome to the data age! The revolution underway is accompanied by a rapidly growing volume of data available to organizations. The Finance function is not immune to this revolution, and can even play a key role in making the most of data.
This training course introduces you to one of Microsoft's " self-service " solutions, and proposes a practical approach to making sense of large volumes of scattered data, adding value to the data and extracting relevant information from it.
Teaching and assessment methods
During the session : alternating theoretical developments, illustrations and case studies. These contextualized exchanges ensure that knowledge is acquired throughout the course.
After the session: the trainer is available to answer any questions relating to the training.
Price
1,860 EXCL.
Media
Testimonials
Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.
Jonathan C.
Company
Training