Python
- Introduction to Python, Operators in Python, Conditional Statement, Loops in Python
- Installing Python and Setting Up the Environment
- Writing Your First Python Program
- Python Syntax, Variables & Data Types
- Conditional Statements (if, else, elif)
- Loops in Python (for, while)
- Functions and Scope
- Working with Lists, Tuples, Sets & Dictionaries
- File Handling in Python
- Error Handling and Exceptions
- Error Handling and Exceptions
- Basics of Object-Oriented Programming (OOP)
- Mini Projects and Practice Exercises
SQL
- Understanding RDBMS (Relational Database Management Systems)
- Installing and Setting Up SQL Environment
- Creating and Managing Databases
- Creating Tables and Understanding Data Types
- Inserting, Updating, and Deleting Data (CRUD Operations)
- Using SELECT Queries to Retrieve Data
- Filtering Data with WHERE Clause
- Using Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
- GROUP BY and HAVING Clauses
- Working with JOINs (INNER, LEFT, RIGHT, FULL)
- Using Filters, Slicers, and Drill-Downs
Tableau
- Installing Tableau Public / Tableau Desktop
- Understanding Tableau Interface and Workspace
- Connecting to Various Data Sources (Excel, CSV, SQL, etc.)
- Working with Dimensions and Measures
- Creating Basic Charts (Bar, Line, Pie, etc.)
- Filters, Sorting, and Grouping Data
- Using Calculated Fields and Table Calculations
- Creating Maps and Geographic Visualizations
- Applying Parameters and Actions
- Building Interactive Dashboards
- Formatting and Customizing Visuals
- Publishing and Sharing Dashboards
- Real-World Dashboard Case Study / Mini Project
Power Bi
- Installing Power BI Desktop
- Power BI Interface Overview
- Connecting to Data Sources (Excel, SQL, Web, etc.)
- Data Cleaning & Transformation Using Power Query
- Understanding Data Models and Relationships
- Creating Visuals: Bar, Line, Pie Charts & More
- Sharing and Collaborating on Reports
- Real-Time Dashboard Project / Case Study
Excel
- Introduction to Excel Tables and Named Ranges
- Protecting Sheets and Using Passwords
- Basic Data Analysis Project Using Excel
- Understanding Workbooks, Worksheets & Cells
- Basic Formulas and Functions (SUM, AVERAGE, COUNT, etc.)
- Using Logical Functions (IF, AND, OR, NOT)
- Working with Text Functions (LEFT, RIGHT, CONCATENATE, etc.)
- Sorting, Filtering, and Conditional Formatting
- Data Validation and Drop-Down Lists
- Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Pivot Tables and Pivot Charts
- Creating Charts and Graphs (Bar, Line, Pie, etc.)
- Working with Date and Time Functions
- Introduction to Excel Tables and Named Ranges
- Protecting Sheets and Using Passwords
- Basic Data Analysis Project Using Excel
