Data Analyst Training Program

1 Month Basic + 2 Months Expert

8 Modules | 100 Marks ​

Course Fee Structure

Learning Path Fee (PKR)
Beginner to Expert Level
Pkr.20,000/-
Expert Level Only
Pkr.15,000/-
Enroll Now

Beginner Level (Foundation Track) – Month 1

  • Understanding Data Analysis and Career Scope
  • Types of Data & Data Formats
  • Excel Basics: Interface, Formatting, Formulas
  • Basic Functions: SUM, AVERAGE, COUNT, IF
  • Sorting, Filtering, Conditional Formatting
  • Data Cleaning using Excel
  • Introduction to Charts & Basic Data Visualization
  • Introduction to Databases & RDBMS Concepts
  • SQL Syntax & Structure
  • SELECT, WHERE, ORDER BY
  • Filtering with Operators & Wildcards
  • Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
  • GROUP BY & HAVING Clauses
  • Basic Joins (INNER, LEFT, RIGHT)
  • Introduction to Power BI Interface
  • Importing Data from Excel & CSV
  • Data Cleaning in Power Query
  • Building Basic Visuals (Tables, Cards, Bar Charts, Pie Charts)
  • Introduction to DAX Basics (SUM, COUNT, DISTINCTCOUNT)
  • Creating Simple Reports & Publishing to Power BI Service
  • Introduction to Python & Jupyter Notebook
  • Data Types, Variables, and Operators
  • Basic Python Functions & Loops
  • Introduction to Libraries: Pandas & Matplotlib
  • Reading Data from CSV/Excel
  • Basic Data Cleaning with Pandas
  • Simple Data Visualization with Matplotlib

Expert Track – Month 2 & 3

  • Advanced Functions: VLOOKUP, XLOOKUP, INDEX-MATCH
  • Nested IFs & Logical Functions
  • Pivot Tables & Pivot Charts
  • Data Validation & Drop-Down Lists
  • What-If Analysis & Scenario Manager
  • Power Query in Excel for Automation
  • Advanced Joins & Subqueries
  • CTEs (Common Table Expressions)
  • Window Functions (ROW_NUMBER, RANK, LEAD, LAG)
  • String Functions & Date Functions
  • Data Aggregation & Complex Filtering
  • Creating Views & Stored Procedures
  • SQL Optimization Basics
  • Advanced Data Modeling Concepts
  • Relationships & Star Schema Design
  • Advanced DAX: CALCULATE, FILTER, ALL, SWITCH
  • Time Intelligence Functions (YTD, MTD, QTD)
  • Dynamic Measures & Conditional Formatting
  • Tooltips, Bookmarks & Drillthrough Pages
  • Dashboard Design Best Practices
  • Data Wrangling & Cleaning with Pandas
  • Merging, Joining & Concatenating DataFrames
  • GroupBy & Aggregations in Pandas
  • Advanced Visualizations with Seaborn & Matplotlib
  • Exploratory Data Analysis (EDA)
  • Introduction to Machine Learning Basics (Classification/Regression)
  • Automating Data Analysis with Python Scripts
  • Real-World Dataset Analysis (Choose Domain: Sales, Finance,
    Marketing, etc.)
  • Apply Excel, SQL, Power BI, and Python Skills
  • End-to-End Data Cleaning, Analysis, and Visualization
  • Dashboard & Report Presentation
  • Beginner Modules (1–4) → Month 1
  • Advanced Modules (5–8) → Month 2 & 3
  • Capstone Project → Last 2 weeks of Month 3
  • Evaluation → per month 1 quiz, 1 assignment & 1 project
Enroll Now
About the Instructor

Tayyaba Zahid

Tayyaba Zahid is a Data Analyst and Trainer with over two years of experience in data analytics, visualization, and automation. She has worked on diverse projects ranging from banking and healthcare analytics to predictive modeling and business intelligence solutions. Passionate about simplifying data for decision-making, Tayyaba now trains students and professionals in SQL, Power BI, Python, and Excel. She also shares insights through content creation and project-based learning.

  • Bachelor’s degree in Computer Science with major of Data Science
  • Certifications in Data Analytics, Business Intelligence, and Machine Learning from IBM, Johns Hopkins University and Google

Over 2 years of experience as a Data Analyst and Python Developer, with industry experience in business analytics, dashboard development, and automation. Currently working as, a Data Analyst Trainer, delivering structured programs in SQL, Power BI, Python, and Excel. Freelancing and professional projects include building interactive dashboards, predictive models, and end-to-end data workflows for banking, retail, and healthcare datasets.

  • Data Analysis & Visualization (Power BI, Tableau, Excel)
  • SQL (MySQL, SQL Server, Google Cloud BigQuery)
  • Python for Data Science
  • Business Intelligence & Reporting
  • Machine Learning Fundamentals
  • Data Cleaning, EDA, and Automation
  • Developed dashboards in Finance and Marketing sector and optimize them.
  • Completed Heart Disease Prediction Model using machine learning.
  • Conducted multiple freelancing projects in data analysis on Upwork.
  • Currently concluding Data Analytics course with AI integration