19/12/2019
0
Views
Profession Marketing Analyst - free course from Skillbox, training, Date: November 29, 2023.
Miscellaneous / / December 02, 2023
Analysts help marketers optimize advertising and improve business performance. They determine which promotion channels are effective and which are not working, and reallocate the budget. They find out why users don’t buy products on the site and build a new sales funnel.
Specialists with such skills are in great demand - with them, businesses do not waste resources on untested solutions, but rely on accurate numbers.
-For beginners. Learn how to make money by collecting and analyzing marketing data. Get 1 of 3 popular IT specializations and you can find a high-paying job.
-Beginner analysts. Learn to work with programming languages and databases. Master Power BI and Excel to organize information and turn it into clear reports. Increase your professional level and income.
-Internet marketers. Improve the effectiveness of advertising campaigns and reduce costs on ineffective channels. You can get a promotion or change your specialization.
-Product Managers Learn to collect holistic data about a product - from analyzing user behavior to marketing and web analytics. Continue your career in any direction and you can earn more.
Chief editor at the publishing house "MIF". Certified MS Office Trainer
Productivity is one of the main areas of interest of Renat Shagabutdinov, within the framework of which he has read hundreds of books and manuscripts and tested dozens of practices. Co-author of the book “Business hack for every day” (with Igor Mann). Translator, scientific editor of books on running, sports nutrition, productivity. Editor-in-chief of the “Sports” direction, ex-chief of the “Personal Development”, “Business”, “Scientific Pop” directions at MYTH.
Participant in the Comrades ultramarathon in South Africa (90 km), Ironman triathlon and other competitions at distances from 3 to 42 km. Partner and editor-in-chief of the TG channel “Running Simply” with 86,000 subscribers, finalist of the Sport Business Awards 2022 in the “Sports Journalist of the Year” category. Founder and co-author of the Google Sheets TG channel with 34,000 subscribers.
Experience in Excel and Google Sheets - 10 years. Certified MS Office trainer. MIF Publishing House is known for its remote work format, so Renat uses Google tools every day.
Senior Analyst at Estée Lauder Companies Inc.
Basic courses
These are the basics that are important to learn to successfully launch your career in analytics. You will become familiar with different types of analytics and understand which specialization is right for you.
Introduction to Analytics
Why does business need analytics?
Metrics in analytics
What does a marketing analyst do?
What does a product analyst do?
What does a web analyst do?
How to choose a specialization
Web analyst from scratch to Junior 2.0
Introduction to Web Analytics
Introduction to Web Technologies
Google Analytics. Counter setup
Google Analytics for Business. A basic level of. Part 1
Google Analytics for Business. A basic level of. Part 2
Google Analytics. Tracking Settings
Google Analytics. Segments and e-commerce
Yandex. Metrics. Differences from Google Analytics
Yandex. Metrics. Main functionality
Yandex. Metrics. Main reports
Reports, metrics and web analyst skills
Google Tag Manager
Google Tag Manager: Setting Up Events
Google Tag Manager: working with dataLayer
SQL and Google BigQuery. Part 1
Visualization: theory
Visualization: practice
A/B testing: theory
A/B testing: practice
Web analyst on the team
Carier start
At this stage, you are ready for employment. A career consultant will help you find a job and prepare you for an interview.
Choosing a Specialization
Courses that will determine your future specialization in the profession. If you can’t decide, career consultants will help you choose the right direction.
Product analytics
Stories about data: why business needs analytics
How an analyst looks at products
Metrics: MAU, NPS, ARPU, Retention, conversion, CTR, North Star
Metrics: Happiness, Retention, Engagement, Success, Fulfillment, Adoption
Selecting metrics and setting KPIs
How to create your first dashboard
How to accept a task from a customer
Collect and evaluate data using Power BI
Aggregate and cleanse your data with Power BI
How to interpret the data
Data visualization
How to find insights in data
How to make a decision based on a dashboard
Can you trust the data from the dashboard?
Introduction to SQL
Yandex. Metrica and AppMetrica
How to Find Insights Using Python Libraries
Testing hypotheses
Analysis methods: regression, cohort and predictive
Advanced SQL: How to Improve Dashboard Performance
End-to-end analytics
What is end-to-end analytics and why is it needed?
Product range analytics
Customer base analytics
Delivery and last mile
User Experience
Retention-marketing
Pop-ups and recommendation systems
Website and mobile application analytics
Call tracking
Advertising expenses
Period evaluation
P&L
Web Analytics PRO
Google Analytics for Business. Advanced level
Types of counters in Google Analytics
Data Enrichment in Google Analytics
JavaScript: Basics
JavaScript: Advanced
How to write scripts to set up events in analytics
Google Tag Manager: Setting Up Ecommerce
Google Tag Manager: Dynamic Remarketing
Advanced data processing in SQL and Google BigQuery
How to automate data upload
Additional courses
Auxiliary courses that will help improve your skills. You can go through them in parallel or watch materials as needed.
SQL for data analysis
Data Analysis and SQL
SELECT statement - selecting columns
SELECT Statement - Row Filtering
Sorting and functions for working with strings
Functions for working with date and time. Part 1
Functions for working with date and time. Part 2
Aggregate functions and grouping
Merging data from different tables
Modifying tables
Window functions
Preparing data for Excel
Power BI
Loading data into Power BI
Connecting data from different tables and resources
Chart types and date filter
Main types of filters and filter synchronization
Visual filters
Working with data hierarchy in graphs
Detailing in reports using the Drill through pages functionality
Working with world maps in charts
Working with tooltips
Basic Metrics and DAX Query Language
Metrics and DAX: Using CALCULATE and Aggregate Functions
SUMX, AVERAGEX, ALL and SWITCH functions
Building a Dashboard for end-to-end analytics
Building a Dashboard with profit and loss charts
Power BI Software Services
A/B testing
Introduction to A/B Testing
Elements of statistics for constructing hypotheses
Statistical tools
Variations of A/B testing and its applications
Organization of mass A/B testing
Acceleration and optimization
Bonus module. Advanced approaches to A/B testing
Data Analyst from scratch 2.0
Introduction to Python
Python Basics
Operators and Expressions in Python
Python. Conditional if statement, branches
Python. Conditional statement if: continuation
While loop in Python
Python. For loop: working with a counter. Part 1
Python. For loop: working with a counter. Part 2
Python. 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. float data type
Python. Installing and configuring the IDE
Representing Lists in Python
NumPy library. Part 1
NumPy library. Part 2
pandas library. Part 1
pandas library. Part 2
SQL Basics
Reading and writing data. Part 1
Reading and writing data. Part 2
Introduction to Statistics
Introducing Big Data
Key business metrics and analytics systems: Google Analytics and Yandex. Metrics
Loading data into Power BI
Connecting data from different tables and resources
Bonus course without practical tasks
In this course you will learn how to create complex reports, calculate data and make forecasts using tables.
Excel from scratch to PRO
Introduction
Leaf structure. Data entry and processing
Formats and meanings. Style and conditional formatting
Analysis of tables. Seal
Checking data, finding errors
Pivot tables
Calculations and formulas. Smart Tables
Counting and summing functions. Statistical functions. Rounding functions
Logic functions
Text functions and tools
Functions for working with date and time
Conditional formatting using formulas
Data search and substitution functions
Advanced filter and database functions
Array formulas. Dynamic arrays
Basic charts and sparklines
Complex diagrams. Dynamic charts
Optimization and forecasting
Linking books. Importing data from external sources
Power Query and Power Pivot Add-in
Subscribe
YOU MIGHT ALSO LIKE
