Technical Training

Business intelligence

Data Analytics Learning Path

Build practical data analysis skills across Microsoft Excel, SQL & Databases, Python, Power BI, and advanced dashboarding techniques.

60 Hours Beginner to advanced Hands-on analytics
Explore Syllabus Back to Technical Training Programs
Jump to Course Syllabus
Course Overview

Learn data analysis end-to-end with the tools used in modern business analytics.

This learning path is structured across six progressive sections, starting with Excel for data analysis and moving through SQL, Python fundamentals, Python libraries, Power BI fundamentals, and advanced Power BI with DAX. The course is designed to take learners from beginner-level analysis to complete business-ready dashboards and reporting solutions.

Total Duration 60 Hours
Learning Track Beginner to Advanced
Core Tools Excel, SQL, Python, Power BI
Outcome Industry-ready Analytics
Module Outline

Course Syllabus: Step-by-Step Modules

Each section focuses on one major tool or skill area, with a practical project outcome at the end of the path.

01

Microsoft Excel for Data Analysis

  • Interface, navigation & keyboard shortcuts
  • Data entry, types & cell formatting
  • Data validation & dropdown lists
  • Core formulas
  • Logical functions
  • Lookup functions
  • Text functions
  • Date & time functions
  • Error handling
  • Conditional Formatting
  • Sorting, Filtering & Advanced Filter
  • Remove Duplicates & data cleaning techniques
  • Named Ranges and Data Tables
  • PivotTables
  • PivotCharts and Sparklines
  • What-If Analysis: Goal Seek, Scenario Manager
  • Power Query: transform & refresh data
  • Building an interactive Excel dashboard
  • Protecting sheets and workbooks
  • Formatting reports for stakeholders
02

Microsoft SQL Server & Database Development

  • Database concepts, normalization & ER diagrams
  • Installing SQL Server & SQL Server Management Studio (SSMS)
  • Creating databases, tables, schemas & relationships
  • Primary Keys, Foreign Keys & Constraints
  • SQL Server data types
  • SELECT, DISTINCT, TOP, WHERE, ORDER BY
  • Filtering data using AND, OR, NOT, IN, BETWEEN & LIKE
  • INSERT, UPDATE, DELETE & MERGE statements
  • Aggregate functions: COUNT, SUM, AVG, MIN, MAX
  • GROUP BY & HAVING clauses
  • INNER, LEFT, RIGHT & FULL OUTER JOINs
  • Self Joins & Cross Joins
  • Subqueries & Correlated Queries
  • CASE expressions for conditional logic
  • String functions
  • Date functions
  • Views for reusable queries
  • Stored Procedures & Parameters
  • User Defined Functions (UDFs)
  • Window Functions
  • Indexes & Performance Optimization
  • Query Execution Plans & SQL Tuning
  • Importing and Exporting Data (CSV, Excel)
  • Backup & Restore Databases
  • Security, Roles & Permissions
  • Real-world business scenarios
  • Mini Project: End-to-End Database Design & Reporting
03

Python Fundamentals

  • Installing Python & VS Code
  • Variables, Data Types & Operators
  • Conditional Statements (if, else)
  • Loops (for, while)
  • Functions
  • Lists, Tuples, Sets & Dictionaries
  • String Manipulation
  • Working with Files
  • Basic Exception Handling
  • Practice Exercises & Assignments
04

Python Libraries for Data Analysis

  • NumPy Fundamentals
  • Arrays & Array Operations
  • Indexing, Slicing & Filtering
  • Pandas Series & DataFrames
  • Reading CSV, Excel & JSON Files
  • Data Cleaning & Transformation
  • Handling Missing Values
  • Filtering, Sorting & Grouping Data
  • Merging & Joining Datasets
  • Date & Time Operations
  • Matplotlib Basics
  • Line, Bar, Scatter & Pie Charts
  • Chart Formatting & Customization
  • Seaborn Basics
  • Statistical & Advanced Visualizations
  • Exploratory Data Analysis (EDA)
  • Business Data Analysis Scenarios
  • Mini Project: End-to-End Data Analysis
05

Power BI Fundamentals

  • Introduction to Power BI
  • Power BI Desktop Interface
  • Report, Data & Model Views
  • Connecting Data Sources
  • Excel, CSV & SQL Imports
  • Power Query Basics
  • Data Cleaning & Shaping
  • Creating Relationships
  • Data Modelling Basics
  • Calculated Columns
  • Basic DAX Measures
  • SUM, COUNT & AVERAGE
  • Tables & Matrix Visuals
  • Bar & Line Charts
  • Cards & KPIs
  • Slicers & Filters
  • Report Formatting
  • Dashboard Design Basics
  • Publishing Reports
  • Mini Dashboard Project
06

Advanced Power BI & DAX

  • Advanced Data Modeling
  • Star & Snowflake Schemas
  • Relationship Management
  • Advanced Power Query
  • M Language Fundamentals
  • DAX Fundamentals Review
  • CALCULATE Function
  • FILTER, ALL & ALLEXCEPT
  • Time Intelligence Functions
  • YTD, MTD & QTD Analysis
  • RELATED & RELATEDTABLE
  • Ranking & Top N Analysis
  • Dynamic Measures
  • Bookmarks & Navigation
  • Drill Through Reports
  • Advanced Visual Interactions
  • Conditional Formatting
  • Row Level Security (RLS)
  • Power BI Service Features
  • Data Refresh & Gateways
  • Performance Optimization
  • Capstone Dashboard Project
Outcome

A complete analytics journey from Excel to Power BI

Learners finish with practical experience in data preparation, SQL reporting, Python analysis, and dashboard building in Power BI.

Data Preparation Clean, transform, and analyze data using Excel, SQL, and Python workflows.
Analytics Delivery Create reports, dashboards, and visualizations that support business decisions.
Capstone Readiness Complete a capstone dashboard project with advanced Power BI and DAX skills.