Valiotti Analytics: SQL & Python 101

This is a course for everyone who wants to learn about the basics of Data Analyst job. If you've never worked with SQL, Python, or product metrics before, then Data Marathon is made for you! We'll show you the most important data analysis tools and clearly explain what the data analyst does using real-life examples.
Beginner Level
5-10 hours
Stepik certificate

What you will learn

  • Get acquainted with data analysis and try on the role of a data analyst.
  • Learn what the real data looks like and work with it.
  • Understand and calculate the main product and marketing metrics.
  • Learn to process data using tools like SQL and Python.
  • Decide whether you want to dive deeper into this profession.

About this course

Data Marathon is a simulation of the Data Analyst job that will introduce you to databases and the methods of working with them. Data analysis is a wide field, and we can't cover all its branches in one course, so we will focus on product and marketing data analysis.

Our course can help if you're looking to switch careers and are considering data analysis as an option. We won't provide you with enough knowledge for a Junior Data Analyst position, but we'll show you the day-to-day work of a data analyst, their most common tasks and tools, so that you can decide on your own whether this is the job for you. You can find more information on the course and its benefits on our site (need English link).

You will get acquainted with:

  • SQL basics: learn to select data with specified conditions, use aggregate functions and group data;
  • Python basics: learn about variables and data types, the pandas library, try filtering and aggregating data from tables;
  • main product metrics: look at such metrics as LTV, CAC, AOV, ARPU, ARPPU, and calculate some of them using real-life game developer data.

Whom this course is for

If you want to get a quick intro to data analysis and understand whether it's the right job for you, the free Data Marathon course is already waiting!

Initial requirements

You don't need any specialized knowledge to complete this course. Data Marathon is developed with novices in mind, so you will be able to understand the material even with no education or experience in IT.

Meet the Instructors

Course content

loading...
Certificate

Certificate

Stepik certificate
Price: Free

Share this course

Price: Free