2019

How to Make Data Talk
Training in data visualization in corporate reports and presentations



You will learn how
To select visualization based on the sense of data
To use Excel life hacks to creating dashboards
To present the results of analytics convincingly
To help top managers making the right decisions

Training Program

Beginning
Types of reports
Report users: analysts and a top manager. What is the difference in perception between them?
Types of reports: operational, analytical, strategic. Differences in structure, content, target audience.

Summary: before creating a report it is necessary to identify who will use it and what decisions will make.
Types of data analysis
Basic types of data analysis.
Techniques of selection charts depending on the type of analysis. Placement of visual accents.

Case "Thesis visualization". The data can be presented in different ways, it depends on what idea you want to "sell".

Summary: the data can be presented in different ways, it depends on what idea you want to "sell".
Anatomy of diagrams
Visual perception, modern trends in information design and usability. Recommended style templates.

Advanced visualization. The limits of Excel
Analysis of interactive examples received "Oscar" on infographics. Analysis of visual deceptions.

Practice: Fixing charts in PowerPoint / Excel, creating templates.

Summary: it is enough to know a few Excel life hacks to make your reports look "expensive" and professional.

Coffee Break
Dashboards creation
Rules of building dashboards. Elements that affect visual perception: grid, field of view, information density, entry point.

Case "Sales Funnel": building an interactive dashboard by Excel pivot tables.

Summary: everyone can create dashboards, you don't need a designer or a programmer to do this.
"Steroids" for Excel
"Chips" of working with the data: conditional formatting, microcharts, calculations. Power view tools, connecting maps to reports.

Case "Report to Director" in Power View
Techniques that you have worked in Excel, can be used on a corporate scale

Summary: Techniques that you have worked on Excel, can be used on a corporate scale.
Collaboration with Analytics
Overview of the best tools for data analysis and visualization. Publish reports on mobile devices, portals and websites. Example of projects.

Practice: publish a report in the MS Power BI Cloud

Summing-up
Students works
Students feedback
At the training I:
1) Formed a view at the data visualization process
"through the eyes of the TOP-Manager"
2) Gained skills in the building of
data visualization
3) Saw the examples of how to effectively
use visualization skills
4) Fixed the acquired skills in practice
Aleksandr
Analyst
Very cool practice! Prior to that, I used pivot tables rarely. I was afraid that the training will be difficult with this, but there were no problems. The trainer explained everything very well. I interested in the topic of dynamic dashboards and will try to begin to apply it in the work immediately.
Totally recommend the training for product analysts.
Kristina
Product owner
I liked that the trainer is a "playing business analyst", he gives specific universal templates, that are in demand in modern business, regardless of the industry, not an overview of the program functions.

Alla
Head of Personnel Assessment and Development Department
The training is very useful with theoretical,
and most importantly, from a practical point of view.
There were ideas how to use these skills to work with customers and in internal business processes.
Ksenia
Project Manager
Companies we train

Author - BI Expert

Alex Kolokolov
Head of the Institute of Business Intelligence

I work in the field of data analysis and data visualization 11 years, in 2014 established the Institute of Business Intelligence (IBI) to teach people how to make big data understandable.

The team of IBI automate data, develop working dashboards and interactive reports. Our clients are big industrial holdings, banks, IT and trading companies in Russia and CIS.

On the educational programs I teach analysts to understand their customers, to be not calculators, but advisors that turn data into profit.
Prices
Business
Econom
8 hours training
Lunch and Coffee Breaks
Access to materials
Certificate of attendance
A contract with a legal entity
Individual consultations after the training
Price
500 $
300 $
Prices
Econom
300 $
8 hours training
Access to materials
Certificate of attendance
Lunch and Coffee Breaks
Register
Register three or more participants
from the company and get a discount

Do you have any questions?

Register for the training
Complete the form. We will contact you shortly to clarify the details.
Register for the training
Complete the form. We will contact you shortly to clarify the details.
Register for the training
Complete the form. We will contact you shortly to clarify the details.