The marketer-analyst evaluates the effectiveness of advertising and user behavior at different stages of the funnel. His main task is to find out which ads respond best to the audience.
Using in-depth data analytics, he calculates the return on investment for each advertising channel and makes recommendations on how best to allocate the marketing budget. This knowledge helps to optimize marketing strategy, improve commercial performance and multiply business revenues.
Course content
Four blocks with different levels of complexity, webinars and practice are waiting for you.
74 modules
420 videos
Web Analyst from Zero to Junior 2.0
You’ll learn how to work with basic web analytics systems, collect data, and understand key metrics. You’ll learn how to analyze user behavior, website and traffic efficiency, and increase the impact of advertising.
Introduction to web technologies
Google Analytics. Setting up an account
Google Analytics for business. The basic level. Part 1
Google Analytics for Business. The Basic Level. Part 2
Google Analytics. Tracking settings.
Google Analytics. Segments and e-commerce.
Reports, metrics, and web analytics skills
Google Tag Manager
Google Tag Manager: setting up events
Google Tag Manager: working with dataLayer
SQL and Google BigQuery
Visualization: theory
Visualization: practice
A/B-testing: theory
A/B-testing: practice
Web-analyst in the team
Cross-cutting analytics
Learn how to determine advertising profitability, evaluate product metrics, and calculate business financials. Understand how to automate routines.
What is end-to-end analytics and why you need it
Product assortment analytics
Customer analytics
Shipping and the last mile
User experience
Retention marketing
Popups and referral systems
Website and mobile app analytics
Call-tracking
Advertising expenses
Period estimation
P&L
Data Analyst from scratch 2.0
Learn to analyze data using analytics services and BI tools, master Python and SQL.
Familiarity with Python
Python Basics
Operators and expressions in Python
Python. Conditional if statement, branching
Python. Conditional if statement: continued
The while loop in Python.
Python. The for loop: working with the counter. Part 1
Python. The for loop: working with the counter. Part 2
Python. The for loop: working with strings
Python. Basic collections: lists
Methods for working with lists in Python
Nested loops in Python.
Python. The for loop: working with lists.
Functions in Python.
Python. The float data type.
Python. Installing and configuring the IDE
Representing lists in Python
SQL basics
Reading and writing data. Part 1
Reading and writing data. Part 2
Introduction to statistics
Getting to know big data
Loading data into Power BI
Connecting data from different tables and resources
Bonus Course. PowerPoint + Google Presentations
You will learn how to design slides effectively, create tables, charts and graphs in presentations, and use animation. You’ll be able to create memorable presentations and use all the power of these tools.