Complete Data Analytics With AI

• What is Data Analytics?
• Types of Analytics: Descriptive, Diagnostic, Predictive, Prescriptive etc
• Data Analytics vs Data Science vs Business Intelligence
• Real-world Use Cases
• Understanding the Data Analytics Lifecycle

Assignments

• Identify and categorize types of analytics from case studies
• Write a short reflection on how companies use data

Projects

• Mini Presentation: “Data Analytics in Real Life – Business Case Study Analysis”

• Types of Data (Structured vs Unstructured)
• Data Sources: APIs, Web, Surveys, Databases
• Data Quality and Challenges
• Introduction to Data Profiling and Exploration

Assignments

• Collect a dataset from open data portals (like Kaggle or Data.gov)
• Clean and describe the dataset in tabular form

Projects

• Web Scraping Mini-Project: Extract product data from an e-commerce website using tools
• Google Forms-based survey project + analysis

• Data Cleaning Techniques in Excel
• Lookup Functions (VLOOKUP, INDEX-MATCH)
• Pivot Tables, Charts, and Dashboards
• Conditional Formatting and Data Validation
• What-If Analysis, Goal Seek, Solver

Assignments

• Clean and filter messy data (CSV/Excel file)
• Create a pivot table from sales data
• Design a mini dashboard using charts

Projects

• Sales Analysis Dashboard (Excel)
• Customer Feedback Sentiment Classification (Excel-based)

• Introduction to Databases and SQL
• SELECT, WHERE, ORDER BY, GROUP BY, JOIN
• Aggregations and Subqueries
• Window Functions
• Real-World Querying Scenarios

Assignments

• Write SQL queries on sample retail datasets
• Practice JOINs with employee and department tables

Projects

• Customer Segmentation Analysis using SQL
• Create a dynamic report using real-world dummy data

• Mean, Median, Mode, Variance, Standard Deviation
• Probability Basics
• Distribution (Normal, Binomial)
• Hypothesis Testing (t-test, chi-square test)
• Correlation and Regression

Assignments

• Analyze sample datasets for correlation and distributions
• Perform hypothesis testing on A/B test data

Projects

• Customer Behavior A/B Test Case Study
• Sales Pattern & Correlation Report

• Getting Started with Power BI
• Data Import, Transformation with Power Query
• Creating Visuals: Bar, Pie, Line, Maps
• Creating Dashboards & Reports
• Power BI Service and Sharing Reports

Assignments

• Import Excel/CSV dataset into Power BI
• Create basic visuals and filter interactions

Projects

• Sales Dashboard for an Online Retail Store
• HR Analytics Dashboard

• Introduction to Python and Jupyter Notebook
• Variables, Lists, Dictionaries, Loops, Conditions
• Libraries: NumPy, Pandas
• Data Cleaning and Manipulation with Pandas
• Data Visualization with Matplotlib & Seaborn

Assignments

• Load and clean a CSV file using Pandas
• Create visualizations using Seaborn

Projects

• Movie Data Analysis (IMDB dataset)
• Exploratory Data Analysis on COVID-19 dataset

• Handling Missing Values and Outliers
• Feature Engineering Basics
• Data Transformation Techniques
• EDA Report Writing

Assignments

• Perform EDA on a messy dataset
• Generate and interpret correlation matrix

Projects

• EDA Report on Superstore Dataset
• Real Estate Price Pattern Study

• What is Machine Learning?
• Supervised vs Unsupervised Learning
• Linear Regression & Logistic Regression
• Clustering (K-Means)
• Model Evaluation Metrics

Assignments

• Train a simple linear regression model
• Evaluate accuracy with confusion matrix

Projects

• Predicting Student Performance (Regression)
• Customer Segmentation using Clustering

• BI Concepts & Dashboards
• KPI Design and Monitoring
• Connecting Power BI with SQL
• Automating Reports and Alerts
• Reporting Best Practices

Assignments

• Create KPI-based Power BI dashboard
• Connect Power BI to a SQL database

Projects

• Executive Dashboard for Business Performance
• Weekly Automated Sales Report

• Capstone Planning and Dataset Selection
• Industry Case Studies: E-commerce, Healthcare, Banking
• Peer Review and Feedback
• Presentation & Storytelling Techniques

Projects

• E-commerce Customer Behavior Analysis
• Sales Forecasting for a Retail Store
• Employee Attrition Prediction
• Financial Risk Dashboard for Loan Approval