Diia.education

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

Profession:

Data analyst

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

Program

Get started

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.

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?

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

Sasha Koltsova

Singer, the lead vocalist of the Krykhitka band, public figure

Marharyta Bondarenko

Data engineer of the research department, Squad company

Yevhen Kovalenko

Big Data Engineer, EPAM Systems

Mariia Vareshchuk

Business Data Analyst at Genesis Growth Accelerator