thumb-Four women and one man in two rows on a dark background

Data analyst. SQL and Power BI

How to develop data analyst skills and become an expert in using SQL and Power BI

Experts: Max Shcherbyna, Oksana Nosenko, Mariia Atamaniuk, +3

The two magic wands of data analytics are the SQL programming language and Power BI. You will learn how to work with data in SQL: what types of data are available, how to group them, and what functions are available in SQL. You will also work with Power BI and create dashboards there. Finally, learn about opportunities for further development in the topic and job options for data analysts.

 

 

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: Connection of tables, Creating dashboards in Power BI, Data grouping, Filtering in MySQL, Working with built-in functions, Working with connectors, Working with Power BI, Working with queries to databases, Work with cloud resources, Work with databases, Work with numerical databases, Work with relational databases

Profession:
Data analyst

Program

thumb-image-212782

Get started

Episode 1. Why we need data and how to work with it

How do businesses collect our data, and why do they need databases? Where and how is the data stored? Stationary computers, servers, and cloud resources. How are database types classified, and what tools can we use to work with it?
thumb-image-212788

Episode 2. Main data types

How are databases similar to human memory? We consider the MySQL database management system and three types of data: text, numeric, and date and time. How to correctly define data types, and how to work with it?
thumb-image-212794

Episode 3. Data filtering

How to filter data in MySQL, and is it possible to search for information by several parameters at once? Data grouping and working with aggregated data. What are the most common mistakes when filtering data?

Invited experts

thumb-image-212803
Max Shcherbyna
Journalist, scriptwriter and co-host of the TV Toronto YouTube channel
thumb-image-212807
Oksana Nosenko
Head of General Analytics at the Ukrainian product company Jooble
thumb-image-212811
Mariia Atamaniuk
Data Analyst at Oddity Tech
thumb-image-212815
Marharyta Dubrova
Product Analyst at Gismart

Partners

thumb-image-212823

Kunsht

thumb-image-212826

EPAM Ukraine

You may also like