Online course
About the lecturer
I am Lilia Lutsenko:
-
Leading Analyst at Wise, one of the biggest fintech companies in the world (13m users). Ex-KPMG.
-
Certified lecturer in data analysis with 5 years of teaching experience.
-
Author of courses “Data Analysis in Excel”, “Product Analytics”, completed by over 400 students.
-
Twice received a prestigious Data Award for outstanding data analysis skills
Course program:
Lecture 1
What data to track and analyse
-
Common data sources and their specifics
-
Metrics and their role in data analysis
-
The process of analysing the data
Lecture 2
Preparing your data for analysis
-
How to read data distribution
-
What is a data anomaly
-
How to detect data anomalies and outliers
Lecture 3
Data Analysis techniques: segmentation
-
Rules for segmenting data
-
Five segmentation models
-
Success story: finding insights with segmentation analysis
Lecture 4
Data Analysis techniques: correlation
-
What is correlation VS causation
-
How to find insights with correlation analysis
-
Success story: how correlation helped to save 2.5 million USD
Lecture 5
Excel for Data Analysis
-
Excel functions for data analysis
-
PivotTables
-
Correlation analysis in Excel
Lecture 6
Workshop : analysing real-world dataset with Excel
-
Preparing data for the analysis
-
Building Pivot tables
-
Applying correlation analysis to find behavioural patterns
Lecture 7
SQL for Data Analysis - Writing Your First SQL query
-
Basics of SQL and databases
Writing flawless SQL code
Exercise #1: writing your first SQL query
Lecture 8
SQL for Data Analysis - Filtering the Data
-
SQL functions to group and filter the data
-
Troubleshooting SQL errors
-
Exercise #2: data exploration with SQL
Lecture 9
SQL for Data Analysis - Measuring Business Metrics
-
Common SQL functions to calculate data metrics
-
Practical exercise #3: measuring business metrics with SQL
Lecture 10
Visualising your analysis
-
Common charts to visualise data analysis
-
Choosing the right chart for each data metric
-
Five rules to create a clear and powerful visualisation
Lecture 11
Creating compelling visualisation in Excel
-
Bar charts: absolute and relative
-
Pie charts and Line charts
-
Exercise #4: data visualisation in Excel
BONUS Lecture 12
Become a better analyst – everyday tips for career growth
-
Checklist for data preparation
-
Rules for data communication and storytelling
-
Managing stakeholder feedback
⭐⭐⭐⭐⭐ What Our Customers Say
WHAT IS THE LEARNING PROCESS LIKE?
After making a payment you will get an access to a Telegram channel.
In the channel, you will receive links to course lectures. Each lecture is 20-30 minutes long. All lectures are pre-recorded. You can watch them at your convenience.
You will be able to access all course lectures for 6 months.
WHAT YOU'LL GAIN AFTER COMPLETING THIS COURSE
Confidence in Your Analytical Skills. Feel empowered to do the data analysis with ease.
Mastery of Core Data Analysis Techniques. Learn the essential methods that every analyst needs.
Confidence in Identifying and Interpreting Data Trends. Develop the ability to uncover patterns and make sense of the story behind the numbers.
Proficiency in Excel and SQL. Build hands-on expertise with the tools that drive modern data analysis.
Compelling Data Storytelling Skills. Create impactful presentations and communicate insights effectively to any audience.
100% money-back guarantee
" I, Liliia Lutsenko, the author of 'Data Analysis for Beginners' course, personally guarantee you to return the full amount of course fee for any reason within 7 days since course purchase"
Collapsible text is great for longer section titles and descriptions. It gives people access to all the info they need, while keeping your layout clean. Link your text to anything, or set your text box to expand on click. Write your text here...
-
Is this course suitable for me if I know nothing about Data Analysis?Yes! This course is designed to introduce you to the basics of Data Analysis and help you learn common analysis techniques.
-
When does the course start and end?After payment, you will receive access to the private course channel where you will receive all course materials. Every day you will get a video lecture with learning materials. In total, you will receive 12 lectures and a BONUS Q&A session with the course tutor. You can start learning immediately or study at your own pace. You will be able to access the video lectures for 6 months.
-
How long will I have access to the course materials?You will have access to all video lectures and other course materials for 6 months. At any time during the 6 months, you can revisit the video lectures.
-
Where and how does the learning take place?After payment, you will receive an email with the access to a private course channel. All course lectures will be published there. Please, enter a valid email to the payment form when making a payment.
Please note that all course materials and videos are the intellectual property of the course owner and may not be copied, shared, or distributed without explicit permission. Any infringement will be subject to legal action under United Kingdom law.
Copyright © 2025 MoveFactory Education Group, All rights reserved.