Data analyst. Excel
How to become a data analyst and find answers in data
Experts: Sasha Koltsova, Marharyta Bondarenko, Yevhen Kovalenko, +3
Data analyst. Excel
How to become a data analyst and find answers in data
The charts and graphs are so beautiful! To make them, you can collect information for weeks, then analyze it and track trends. It helps companies do business, come up with innovations, and save money. Data analysts are "magicians" who turn boring data into understandable information. In the first module, you will learn about the routine of data analysts, how and why companies use data, and how analysts work with data. Learn how to use Excel and all its secrets. Some episodes address data visualization and how to use data ethically. The second module of the educational series is dedicated to SQL and Power BI.
The educational series was created at the initiative of the Ministry of Digital Transformation for the Diia.Education platform with the support of Google.org, the Eastern Europe Foundation, with the assistance of EPAM and Kunsht.
HARD: Big data, Cohort analysis, Conclusions, Conducting A/B tests, Data analysis, Data-driven approach, Data sources, Data types, Data visualization tools, Formulation and decomposition of the problem, Funnel analysis, Market analysis, Proposing hypotheses, Storytelling with data, Tracking metrics, Types of data visualization, Work with Excel
SOFT: Data usage ethics, Problem identification and research, Stakeholders management
Program
Get started
Episode 1. Who data analysts are and what they do
Episode 1. Who data analysts are and what they do
15 min
Episode 2. Data-driven approach and big data
Episode 2. Data-driven approach and big data
13 min
Episode 3. Problem detection and task setting
Episode 3. Problem detection and task setting
14 min
Invited experts
Sasha Koltsova
Marharyta Bondarenko
Yevhen Kovalenko
Mariia Vareshchuk
Partners
Kunsht
EPAM Ukraine
Do you have questions?