Complete Data Analyst Roadmap: From Beginner to Job-Ready
Excel for Data Analysis – Interface & Overview
Complete Data Analyst Roadmap: From Beginner to Job-Ready
0%
Completed
Excel for Data Analysis
Excel for Data Analysis – Interface & Overview
Video - 00:50:07 mins
Essential Excel Formulas (SUM, IF, COUNTIF, AVERAGE, etc.)
Video - 00:48:34 mins
Pivot Tables for Data Analysis
Video - 00:40:28 mins
LOOKUP and Indexing
Video - 00:44:32 mins
Conditional Formatting in Excel
Video - 00:48:07 mins
Charts & Data Cleaning Techniques
Video - 00:42:22 mins
Excel Project – Sales Dashboard with KPIs
Video - 00:45:04 mins
SQL for Data Analysis
SQL Introduction, Installation & Importing Data
Video - 00:57:17 mins
Basic SQL Queries (SELECT, WHERE, AND, OR, NOT, LIKE, ORDER BY)
Video - 00:56:24 mins
Date & Time Functions, Numeric Functions, Aggregations, IN, BETWEEN
Video - 00:53:16 mins
LIMIT, CASE Statements, GROUP BY, String Functions
Video - 00:50:44 mins
HAVING Clause, SQL Joins, Set Operators, Subqueries, Window Functions
Video - 00:44:22 mins
CTEs, Views & Stored Procedures
Video - 00:50:25 mins
SQL Project – Sales & Customer Analysis
Video - 00:34:22 mins
Python for Data Analysis
Python Basics, Data Types, Operators, Conditions & Problem Solving
Video - 00:51:08 mins
Loops, Lists, Functions & List Comprehension
Video - 00:58:29 mins
Tuples, Dictionaries, Sets & Problem Solving
Video - 00:52:57 mins
Python Libraries for Data Analytics & Visualization
Python Functions and Modules
Video - 00:43:46 mins
NumPy for Data Manipulation
Video - 00:53:36 mins
Pandas for Data Analysis
Video - 00:59:34 mins
Matplotlib & Seaborn for Data Visualization
Video - 00:49:04 mins
Power BI for Business Intelligence
Power BI Installation & First Visualization
Video - 00:35:11 mins
Power Query for Data Cleaning
Video - 00:40:29 mins
Data Modeling, Relationships & DAX Basics
Video - 00:42:40 mins
Drill Down, Tooltips, Bins & Slicers
Video - 00:59:27 mins
Advanced Power BI & Dashboard Project
Conditional Formatting & Popular Power BI Visuals
Video - 00:36:41 mins
Power BI Project – Marketing Dashboard
Video - 00:40:24 mins
Bonus Module: Career & Portfolio Setup
GitHub Tutorial – Uploading & Managing Data Analyst Projects
Video - 00:15:04 mins
Conclusion
Thank You
Reading
More
Announcements
Reviews
Course Info
Hide similarities
Highlight differences
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
Image
SKU
Rating
Price
Stock
Availability
Add to cart
Description
Content
Weight
Dimensions
Additional information
Click outside to hide the comparison bar
Compare
