Course Details - Data Knowledge

Data Analyst - Course Curriculum

Master the modern data stack with our comprehensive 8-module program

MODULE 1

Excel & Advanced Excel

What You'll Learn

  • Excel fundamentals
  • Data cleaning and formatting
  • Formulas and functions
  • Lookup functions (VLOOKUP, XLOOKUP)
  • Conditional formatting
  • Pivot Tables & Pivot Charts
  • Dashboard creation
  • Power Query basics
  • Data validation
  • Advanced Excel automation

Tools

  • Microsoft Excel
  • Power Query
MODULE 2

SQL & ETL

What You'll Learn

  • Database concepts
  • CRUD operations
  • Filtering and sorting
  • Aggregate functions
  • Joins
  • Subqueries
  • Window Functions
  • CTEs
  • Stored Procedures (Basics)
  • Query optimization

Tools

  • MySQL
  • MS SQL
  • Snowflake
  • SSIS & AWS Basics
MODULE 3

Power BI & Tableau

What You'll Learn

  • Data visualization principles
  • Connecting multiple data sources
  • Data modeling
  • DAX basics
  • Interactive dashboards
  • KPI reporting
  • Drill-down reports
  • Storytelling with data

Tools

  • Power BI
  • Tableau
MODULE 4

Python & Statistics

What You'll Learn

  • Python basics
  • Variables and loops
  • Functions
  • NumPy
  • Pandas
  • Data Cleaning
  • Exploratory Data Analysis
  • Descriptive Statistics
  • Probability
  • Hypothesis Testing

Tools

  • Python
  • Jupyter Notebook
  • Pandas
  • NumPy
MODULE 5

Business Knowledge & Jira

What You'll Learn

  • Business domains
  • KPI understanding
  • Requirement gathering
  • Agile methodology
  • Sprint planning
  • Jira workflow
  • Documentation
  • Stakeholder communication

Tools

  • Jira
MODULE 6

ChatGPT & AI Tools

What You'll Learn

  • Prompt Engineering
  • AI-assisted reporting
  • Report automation
  • SQL generation
  • Excel formula generation
  • Dashboard insights
  • AI productivity tools

Tools

  • ChatGPT
  • AI Productivity Tools
MODULE 7

Dashboard Building

What You'll Learn

  • End-to-end dashboard projects
  • Business KPI dashboards
  • Executive dashboards
  • Interactive filters
  • Data storytelling
  • Publishing reports

Tools

  • Power BI
  • Tableau
  • Excel
MODULE 8

Case Studies & Business Reporting

What You'll Learn

  • Healthcare Analytics
  • Finance Analytics
  • Retail Analytics
  • HR Analytics
  • Sales Analytics
  • Presentation skills
  • Report writing
  • Stakeholder communication

Career Opportunities

Data Scientist Machine Learning Engineer AI Engineer Analytics Consultant Data Analyst ML Engineer

Major Tools Covered

Python NumPy Pandas Scikit-learn SQL Power BI AWS Azure ChatGPT Machine Learning Libraries

Real-time Projects

E-commerce Sales Analysis Retail Inventory Optimization Financial Fraud Detection Credit Risk Analysis Banking Loan Default Prediction Customer Segmentation (RFM Analysis)