Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
In this comprehensive video you will learn:
1) How to approach a data analysis project
2) A real-world sample data with 10 problems
3) Go through step by step
4) Calculate descriptive statistics (mean, median, quartiles, range, individual items and count)
5) Exploratory data analysis in Excel
6) Analysis with formulas vs. pivot points (necessary techniques)
7) best/worst performing items
8) Anomaly detection
9) Best in class analysis
10) Complete report preparation
11) Combining data in different tables (spreadsheets)
12) Answer open questions
13) Prepare and use Excel charts
14) Challenges and homework assignment
Below you will also learn the Excel functions:
1) Using tables
2) Formulas
3) Pivot tables and Power Pivot measurements
4) Conditional formatting
5) Graphs
6) Data validation
7) Shortcuts and tricks
Video timestamps:
0:00 – Introduction
2:12 – Descriptive statistics in Excel
8:05 – Exploratory data analysis (EDA) with conditional formatting
13:20 – Sales by country report with formulas
19:01 – Sales by country report with pivot points
23:43 – Top 5 products with per unit
27:13 – Anomaly detection in your data
31:24 – Analysis of the best in the category
33:36 – Profit analysis (combine two tables)
37:26 – Country level dynamic sales report
41:55 – Which products should be discontinued (open questions)
Sample files:
Blank data file (perfect for tracking) – https://chandoo.org/wp/wp-content/uploads/2021/08/beginner-DA-course-blank.xlsx
Completed Workbook – https://chandoo.org/wp/wp-content/uploads/2021/08/beginner-DA-course.xlsx
There is an ERROR: Cannot modify array?
Here is the solution – https://chandoo.org/wp/errors-with-data-analysis-course/
What should you watch next?
I recommend setting aside some time to practice what you just learned. But if you feel like watching more, I recommend these videos:
5 Key Skills You Need to Be a GREAT Data Analyst – https://youtu.be/gVr9f1GJdZc
5 Excel Skills You Should Focus On – https://youtu.be/cEuq_9CsHIY
15 Excel Functions You Need to Know – https://youtu.be/B5hayFelHDU
My data analysis playlist – https://www.youtube.com/watch?vgVr9f1GJdZc&listPLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
Do you want to know more? Join my Excel school
If you want more step-by-step education and tools to be GREAT at work, consider joining my Excel School program. This online course will teach you everything you need for data analytics reporting roles.
Visit https://chandoo.org/wp/excel-school-program/ to sign up today.
My recommended Excel books:
https://chandoo.org/wp/best-excel-power-bi-books/
SAY HELLO
In addition to YouTube, I regularly post on:
my blog – https://chandoo.org/wp/
twitter – https://twitter.com/r1c1/
Instagram – https://www.instagram.com/chandoo.xlsx
Have a nice day
#Data Analysis #Excel
Please take the opportunity to connect and share this video with your friends and family if you find it useful.