Data analyst - course 108,540 rub. from Hexlet, training 9 months, date November 30, 2023.
Miscellaneous / / November 29, 2023
Learn to understand basic company metrics and calculate them yourself using SQL and Google Sheets. Conduct cohort analysis and make predictions by visualizing data using Looker Studio and Python libraries. Draw conclusions based on research, justify them and help your business grow
A data analyst is a specialist who collects, processes, studies and interprets data. It helps the company make important decisions, improving business processes and product.
The learning process on Hexlet is designed in such a way that it is impossible to “sit through” or “listen to”. Hexlet is designed for serious training and is ideal for those who want to become a good specialist
Deep study of topics
We are not proponents of the “repeat after the teacher” approach.
On Hexlet, problem solving comes only through real understanding. You will learn not just to collect data, but also to analyze and interpret it
Certificate
Employers value Hexlet graduates and even list our courses as an advantage when hiring. The certificate is confirmation that you have seriously worked on yourself and have a good prospect of becoming a first-class specialist
Practice from day one
Let's start analyzing the data in the first lesson.
Exercises and homework from your mentor await you. As well as educational projects with typical tasks for an analyst from different areas of business
Experienced mentors
Practicing specialists who will adjust the learning trajectory and help cope with difficulties. You will not be left alone and you will not be ashamed of the result
Preparing for employment
Hexlet has a Career Track program, within which you will prepare to find your first job in IT
Data Analyst course program
Rest assured that you will receive exactly the tools and skills that will allow you to find a job
We regularly monitor which developer competencies are in demand on the market and build a training program in accordance with this knowledge
Profession in 9 months
110 hours of theory, 320 hours of practice
3 modules, 24 courses, 270 lessons, 190+ practices, 3 projects
Career track and assistance with employment
Module 1. Introduction to Data Analytics
Courses
In the first module, you will become familiar with the main tasks of a data analyst, learn what types of data exist and how to process them. Learn to represent data in the form of charts and choose the right chart for a specific task. Get comfortable with Google Sheets. You will process data using the SQL language and write complex SQL queries
Introduction to Analytics
Analytical tasks in business
SQL Basics
Basics of Analytics in SQL
Advanced analytics in SQL
SQL. Join
Advanced SQL Queries
SQL. Multiple operations
SQL Window Functions
Visualization in Looker Studio
Analyze the trading platform database. Visualize the received data in Looker Studio and make a final presentation with the results
Webinars
Data visualization in Tableau
Sales
Project
Module 2. Data analytics for real-world problems
Courses
You will learn what challenges you will face in financial, product, marketing and web analytics. You will learn such metrics as CTR, DAU/WAU/MAU, Visits, UV, NRR, ARR, cost-per-mile, learn how to configure and calculate them. Learn to rigorously justify data-driven decisions. You will be able to conduct end-to-end analytics and help build a marketing and sales strategy
Project
End-to-end analytics
Module 3. Python for data analysis
Courses
Learn the Python programming language, which saves analysts a lot of time. You will learn how to read a huge amount of data by writing just one line of code, or work simultaneously with several databases that are stored in different formats. Learn to connect to databases and update them automatically
Webinars
Introduction to Neural Networks
Preliminary analytics of the House Prices dataset: exploring the parameters of houses
Livecoding: writing a neural network to predict house prices
Livecoding: selecting hyperparameters of a neural network