Data science with Ai - Monisha

1️⃣ Microsoft Excel (Beginner to Advanced)

• Excel interface & formulas

• Functions: Lookup, text, date/time, logical

• Data cleaning & data validation

• Pivot tables, charts & dashboards

• Excel reporting automation

2️⃣ SQL for Data Analysis

• SQL basics & database concepts

• SELECT, WHERE, GROUP BY, HAVING, ORDER BY

• Joins & subqueries

• Window functions

• Writing optimized SQL queries

• Real-time database querying

3️⃣ Tableau

• Tableau interface & data connections

• Charts, filters, parameters

• Calculated fields

• Interactive dashboards

• Sharing & publishing reports

4️⃣ Power BI

• Power BI Desktop overview

• Data modeling & DAX

• Power Query M-language

• Visualizations & interactive reports

• Power BI dashboards & publishing

5️⃣ Python Programming

• Python basics & syntax

• Data types, loops, functions

• File handling & modules

• Numpy, Pandas for data analysis

• Data cleaning & wrangling

6️⃣ Machine Learning

• Supervised & unsupervised learning

• Regression & classification models

• Clustering & dimensionality reduction

• Model training, testing & validation

• Real-world ML project workflow

📌 Course Outcome

• Become job-ready in Data Analytics & BI

• Build dashboards in Power BI/Tableau

• Write SQL queries & automate Excel tasks

• Perform data analysis using Python

• Implement ML models for real datasets