Data Analytics

Course Overview

Master end-to-end data analytics — from Python, SQL, and Excel to Tableau and Power BI. Build real-world dashboards and data-driven business insights.

Duration: 24 weeks
Rating: 4.8 / 5
4,100+ Students

Detailed Syllabus

1-4: Python for Data Analytics

  • Introduction to Python and Data Analytics
  • String Manipulation and Data Structures
  • Control Loops and Functions
  • Object-Oriented Programming
  • Modules and Packages
  • Graphical User Interface (GUI)
  • Exception & File Handling
  • Variables, Scope, and PEP8 Standards
  • Advanced Concepts and Error Handling
  • Working with APIs and JSON Data
  • Mini Project: Data Cleaning with Python

Tools: Python, Jupyter Notebook, Google Colab

5-8: Advanced Excel for Analytics

  • Excel Interface and Data Entry
  • Formulas & Functions for Analysis
  • Lookup & Reference Functions (VLOOKUP, INDEX, MATCH)
  • String Functions and Conditional Formatting
  • Pivot Tables, Pivot Charts, and Dashboards
  • Aggregate Functions and Data Validation
  • Scenario Manager & What-If Analysis
  • Macros, VBA Basics & Automation
  • Excel Data Cleaning & Transformation
  • Industry-Oriented Excel Analytics Project

Tools: Microsoft Excel

9-12: SQL for Data Management & Analysis

  • Introduction to MySQL & Database Basics
  • Creating Databases and Tables
  • Data Insertion and Updates
  • MySQL Warnings, NULL and NOT NULL
  • CRUD Commands: SELECT, UPDATE, DELETE, INSERT
  • WHERE, AND, OR, DISTINCT, IN/NOT IN Clauses
  • String Functions: SUBSTRING, REPLACE, REVERSE, CHAR_LENGTH
  • Case Manipulation (UPPER, LOWER)
  • Relational Database Concepts and Schemas
  • Primary, Foreign & Unique Keys, Constraints
  • Aggregate Functions and Joins
  • Stored Procedures and Parameters
  • Control Statements: IF, CASE, LOOP, WHILE
  • Access Control for Stored Programs
  • SQL Optimization & Query Debugging
  • Industry Projects using MySQL and PostgreSQL

Tools: MySQL, PostgreSQL, DBeaver

13-16: Tableau Data Visualization

  • Getting Started with Tableau & Interface Overview
  • Connecting to Data Sources (Excel, CSV, SQL)
  • Data Preparation and Cleaning in Tableau
  • Creating Charts, Maps, and Visual Elements
  • Scatterplots, Dual Axis Charts, and Heatmaps
  • Table Calculations and Aggregations
  • Advanced Dashboards and Interactivity
  • Storytelling and Presentation Design
  • Joining & Blending Multiple Data Sources
  • Parameters and Calculated Fields
  • Publishing Dashboards to Tableau Public
  • Team Collaboration and Real-Time Updates

Tools: Tableau Desktop, Tableau Public

17-20: Power BI for Business Insights

  • Introduction to Power BI & Interface Setup
  • Data Import and Cleaning (Power Query)
  • Creating Relationships and Data Models
  • Data Analysis Expressions (DAX)
  • Aggregations, Filters, and Calculations
  • Creating Dynamic Visuals and Reports
  • Drill-Through and Cross-Filtering
  • Integrating Power BI with Excel and SQL
  • Implementing AI Visuals in Reports
  • Publishing & Sharing Reports on Power BI Service
  • Scheduled Data Refresh and Workspace Management
  • Power BI Project: Business Sales Dashboard

Tools: Power BI Desktop, Power BI Service

21-22: Foundations of Data Science & Machine Learning

  • Introduction to Data Science Concepts
  • Understanding Data Pipelines
  • Exploratory Data Analysis (EDA)
  • Data Cleaning and Preprocessing
  • Introduction to Machine Learning
  • Supervised vs Unsupervised Learning
  • Linear and Logistic Regression
  • Decision Trees and Model Evaluation
  • Deploying Simple Models using Streamlit or Flask

Tools: Python, Scikit-learn, Pandas, NumPy

23-24: Capstone Project & Industry Applications

  • Real-World Data Analytics Case Study
  • Combining Python, SQL, Tableau & Power BI
  • Data Cleaning and ETL Pipeline Design
  • Building a Full Interactive Dashboard
  • Performing Business Analysis and Insights
  • Report Creation and Storytelling with Data
  • Presentation & Review with Mentors
  • Portfolio Building and Job Preparation

Tools: Python, Excel, SQL, Tableau, Power BI, Streamlit

← Back to all courses