Excel for Data Analysis
Essential Excel Formulas (SUM, IF, COUNTIF, AVERAGE, etc.)48:34
Pivot Tables for Data Analysis40:28
LOOKUP and Indexing44:31
Conditional Formatting in Excel48:06
Charts & Data Cleaning Techniques42:22
Excel Project – Sales Dashboard with KPIs45:04
SQL for Data Analysis
SQL Introduction, Installation & Importing Data57:17
Basic SQL Queries (SELECT, WHERE, AND, OR, NOT, LIKE, ORDER BY)56:24
Date & Time Functions, Numeric Functions, Aggregations, IN, BETWEEN53:16
LIMIT, CASE Statements, GROUP BY, String Functions50:44
HAVING Clause, SQL Joins, Set Operators, Subqueries, Window Functions44:22
CTEs, Views & Stored Procedures50:25
SQL Project – Sales & Customer Analysis34:22
Python for Data Analysis
Python Basics, Data Types, Operators, Conditions & Problem Solving51:08
Loops, Lists, Functions & List Comprehension58:29
Tuples, Dictionaries, Sets & Problem Solving52:57
Python Libraries for Data Analytics & Visualization
Python Functions and Modules43:46
NumPy for Data Manipulation53:36
Pandas for Data Analysis59:34
Matplotlib & Seaborn for Data Visualization49:04
Power BI for Business Intelligence
Power BI Installation & First Visualization35:11
Power Query for Data Cleaning40:29
Data Modeling, Relationships & DAX Basics42:40
Drill Down, Tooltips, Bins & Slicers59:27
Advanced Power BI & Dashboard Project
Conditional Formatting & Popular Power BI Visuals36:41
Power BI Project – Marketing Dashboard40:24
Bonus Module: Career & Portfolio Setup
GitHub Tutorial – Uploading & Managing Data Analyst Projects15:04
Conclusion
Thank You
Excel for Data Analysis – Interface & Overview
