thumb-Two men and four women in 2 rows on a dark background

Data analyst. Excel

How to become a data analyst and find answers in data

Experts: Sasha Koltsova, Marharyta Bondarenko, Yevhen Kovalenko, +3

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.

Format:
Education series
EKTS:
0.1
Languages:
Ukrainian, English
Topic:
Re/Upskilling
For:
for IDPs, for new job seekers, for new profession, for remote work
Skills:

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

Profession:
Data analyst

Program

thumb-image-332559

Get started

Episode 1. Who data analysts are and what they do

What do data analysts need to know and be able to do? Do you need to be good at drawing, math, statistics, and coding? Types of data analysis. Where do analysts get information from? We discuss areas where data analysts are needed and how they help companies.
thumb-image-332565

Episode 2. Data-driven approach and big data

We look at the concept of big data. What is a data-driven approach? Why do Spotify, Netflix, Grammarly, and other businesses analyze big data? General characteristics of big data. What programs do analysts use to process and work with data?
thumb-image-332571

Episode 3. Problem detection and task setting

What does the work of a data analyst start with? Identifying the need, gathering information, breaking down the problem into smaller parts, and formulating and validating the problem. How to communicate with stakeholders to verify the correctness of the established problem and task? What do data analysts do at the stage of developing an analysis plan? What are the expectations for a junior, middle, and senior analyst?

Invited experts

thumb-image-332580
Sasha Koltsova
Singer, the lead vocalist of the Krykhitka band, public figure
thumb-image-332584
Marharyta Bondarenko
Data engineer of the research department, Squad company
thumb-image-332588
Yevhen Kovalenko
Big Data Engineer, EPAM Systems
thumb-image-332592
Mariia Vareshchuk
Business Data Analyst at Genesis Growth Accelerator

Partners

thumb-image-332600

Kunsht

thumb-image-332603

EPAM Ukraine

You may also like