
Learn how to analyze large data.
This course teaches through exercises and case studies where to start to analyze data, how to perform fundamental analysis, the message creation process and reporting findings.
Participants
12
Tools


Online/Offline
In-class exercises
Length
1 day
Free Resources
For whom?
It is designed for those who want to learn to get insights from large and messy data.
​
-
Data/Business analyst/manager
-
IT specialist/senior specialist/manager
-
Strategy specialist/senior specialist/manager
-
Finance specialist/senior specialist/manager
-
CX, UX or service design specialist/senior specialist/manager
-
Management reporting departments
What are the requirements?
This course is designed for professionals who have access and basic knowledge on the use of Excel. Before joining the course make sure you have a stable internet connection and Excel installed on a PC or Mac.
Course Content
Understanding dataset
-
Dimensions and metrics
-
Calculation fields
-
Data types
-
Cumulation
​
Finding compare points
-
Scenarios
-
Targets
-
References
-
Benchmars and indices
-
Dimensions
-
Variations
​
Data Visualization
-
Charts
-
Tables
-
Warnings
-
Trend analysis
-
Interaction analysis
​
Crafting a message
-
Message types
-
Using extra data
-
Detailed explanations