Course Curriculum
- Introduction to Python
- Python Environment Setup (Anaconda, Jupyter Notebooks)
- Python Programming Fundamentals (Variables, Data Types, Operators, Functions)
- Data Structure (List, Tuple, Dictionary, Set)
- Data Analytics Overview
- Statistical Computing
- Mathematical Computing using NumPy
- Data Manipulation with Pandas
- Data Preprocessing
- Exploratory Data Analysis
- Data Visualization (Matplotlib, Seaborn)
- Intro to Model Building
- Regression Analysis
- Classification and Clustering
- Hands-On: Project on Real-World Data
- Fundamental of SQL Statements
- DDL & DML
- Restore and Backup
- Selection Commands: Filtering, Ordering
- Alias
- Aggregate Commands
- Group By Commands
- Conditional Statement
- Keys
- Joins
- Subqueries
- Views and Index
- String Function
- Mathematical Function
- Pattern (String) Matching
- User Access Control Function Introduction
- Introduction to Business Analytics
- Sorting and Filtering
- Removing Duplicates
- Text Functions
- Dates and Times Function
- Formatting, Conditional Formatting, and Important Functions
- Analyzing Data with Pivot Tables
- Dashboarding
- Business Analytics with Excel
- Data Analysis Using Statistics
- Lookup Function
- Logical Functions: IF, AND, OR
- Statistical Functions: Average, Countif, SUM
- Error Handling Functions: IFERROR
- Pivot Table with Pivot Charts
- Introduction
- Tableau Basics
- Working with Data Sources
- Visualization Using Tableau
- Tableau Calculations
- Sort and Filter with Tableau
- Different Charts in Tableau
- Working with Dashboards
- Introduction to Level of Details in Tableau (LODs)
- Hands-On: Design a Dashboard Based on Real-World Data
- Storytelling
- Introduction to Power BI
- Connecting to Various Data Sources (Excel, SQL, APIs)
- Creating Reports and Visualizations
- Basic Charts: Bar, Line, Pie, and Donut Charts
- Building Custom Dashboards and Interactive Reports
- Data Transformation with Power Query (Cleaning, Merging, Filtering Data)
- Hands-On: Building a Power BI Report and Dashboard Based on a Dataset
