DATA ANALYTICS
- Variables & Data Types
- Operators
- Lists, Tuples, Sets, Dictionaries
- Loops (for, while)
- Functions
- NumPy – Numerical Operations
- Pandas – Data Manipulation
- Matplotlib – Visualization
- Seaborn – Advanced Charts
- Handling Missing Values
- Removing Duplicates
- Data Transformation
- String Operations
- Bar Chart
- Line Chart
- Histogram
- Heatmap
- Scatter Plot
- SELECT, WHERE, ORDER BY
- LIMIT
- DISTINCT
- LIKE
- BETWEEN
- Aggregate Functions (COUNT, SUM, AVG, MAX, MIN)
- Joins (INNER, LEFT, RIGHT, FULL, SELF)
- Subqueries
- GROUP BY
- HAVING
- Window Functions
- RANK(), DENSE_RANK(), ROW_NUMBER()
- CTE (Common Table Expressions)
- Views
- Stored Procedures
- Data Cleaning Queries
- Excel Interface & Shortcuts
- Data Types (Text, Number, Date)
- Sorting & Filtering
- Conditional Formatting
- IF, IFS, AND, OR
- VLOOKUP, HLOOKUP, XLOOKUP, INDEX MATCH
- LEFT, RIGHT, MID, LEN, TRIM
- TODAY, NOW, DATEDIF
- SUM, COUNT, COUNTIF, SUMIF
- Pivot Table & Pivot Chart
- Data Validation
- Removing Duplicates
- What-If Analysis
- Power Query Basics
- Power Pivot
- Dashboard Creation
- Power BI Interface
- Import Data from Excel / SQL
- Data Transformation
- Relationships & Star Schema
- DAX Functions (SUM, CALCULATE, FILTER)
- Bar, Line, Pie Charts
- KPI Cards & Map Visuals
- Interactive Reports
- Filters & Slicers
- Publishing to Power BI Service
- Sales Data Analysis
- HR Analytics Dashboard
- E-Commerce Data Analysis
- End-to-End Data Analytics Project
