Skip to content
Free delivery over PKR 2,500 nationwide
Ilmora
Bestseller

Power BI & Excel for Data Analysis

Turn messy spreadsheets into dashboards that managers actually use — PivotTables, Power Query, DAX and more.

4.8(11,280 ratings) 58,720 learners

Created by Zainab Qureshi

  • Updated August 2026
  • Urdu + English
  • Beginner
  • 30 hours · 198 lectures
  • Certificate included
PKR 1,999PKR 2,99933% off

33% off ends in-- d -- h

30-day money-back guarantee · Secure card payment via Safepay

This course includes

  • 30 hours on-demand video
  • 11 articles & notes
  • 17 downloadable resources
  • 2 quizzes & assignments
  • Access on mobile, laptop and TV
  • Full lifetime access
  • Certificate of completion

What you’ll learn

  • Clean and reshape data with Excel formulas, tables and Power Query
  • Summarise data with PivotTables, XLOOKUP and dynamic arrays
  • Model data in Power BI with relationships and a proper star schema
  • Write essential DAX measures: totals, YoY growth, running totals
  • Design clear, interactive dashboards for sales, HR and finance
  • Publish and share reports securely with your team

Course content

5 sections · 198 lectures · 30h total length

5 lessons · 1h 18m

  • 07:45
  • 15:30
  • XLOOKUP, IFS and text functions22:20
  • PivotTables and PivotCharts24:10
  • Quiz: Excel formulas08:00

4 lessons · 1h 41m

  • Importing from Excel, CSV and folders16:40
  • Fixing dates, merged cells and typos21:15
  • Merging and appending queries18:30
  • Assignment: Clean the textile export data45:00

3 lessons · 47 min

  • Power BI Desktop tour12:20
  • Relationships and the star schema20:45
  • Date tables done right13:50

4 lessons · 1h 9m

  • Calculated columns vs measures15:10
  • CALCULATE and filter context26:30
  • Time intelligence: MTD, YoY, Ramadan vs normal months22:40
  • DAX cheat sheet05:00

4 lessons · 1h 48m

  • Design principles for dashboards17:15
  • Project: Retail sales dashboard38:20
  • Project: HR attrition dashboard32:45
  • Publishing, row-level security and refresh19:30

Section outlines list the key lessons (6h 43m shown). The full syllabus of 198 lectures unlocks on enrolment.

Requirements

  • Windows laptop with Excel 2019 or Microsoft 365
  • Power BI Desktop (free download)
  • Basic Excel familiarity is helpful but not required

Description

In most Pakistani offices, reporting still means someone spending three days every month copying numbers between spreadsheets. This course teaches you to automate that work and present it in dashboards that make you the most useful person in the room.

Zainab uses real-style datasets from a retail chain, a textile exporter and a hospital — complete with spelling mistakes, merged cells and inconsistent dates — so you learn to handle the data you'll actually receive. By the end you'll have a portfolio of four dashboards.

Who this course is for

  • Complete beginners who want a structured, step-by-step start in Power BI
  • Commerce, business and engineering graduates moving into analyst roles
  • Learners who prefer clear explanations in Urdu, with technical terms kept in English
  • Anyone who wants a verifiable certificate to add to their CV or LinkedIn profile

Your instructor

Zainab Qureshi

Senior Data Analyst, Karachi retail group

Rating
4.8
Learners
89.3k
Courses
2

Zainab builds the dashboards that a large Karachi retail group uses to run hundreds of stores, from stock levels to Ramadan sales forecasts. She moved into data from a commerce background, so she knows how to teach people who don't think of themselves as technical. Her courses use real, messy Pakistani business datasets.

Power BIExcelSQLData VisualisationStatistics

More from Zainab Qureshi

Learner reviews

4.8

Course rating · 11.3k ratings

Breakdown of 4 written reviews.

Most recent reviews

Sobia Akram

Accounts officer, Faisalabad

Verified learner

My monthly report used to take two days. Now it refreshes with one click. My manager asked me to train the whole department.

Helpful?

Imran Latif

Supply chain executive, Karachi

Verified learner

Zainab explains DAX better than any English tutorial I've seen. CALCULATE finally makes sense.

Helpful?

Hamid Raza

MBA student, IBA Karachi

Verified learner

Very good, practical datasets. Would like a section on Power BI Service admin.

Helpful?

Tayyaba Khalid

Fresh graduate, Lahore

Verified learner

Put the retail dashboard in my CV and it got me my first job as a junior analyst.

Helpful?

Learn with books too

Recommended books for this course

Go deeper on Power BI with reference titles and guides chosen to sit next to the videos. Delivered nationwide with cash on delivery.

Shop all books

Keep learning

Learners also enrolled in

All Data Science courses
Bestseller
ProgrammingUrdu

Python for Absolute Beginners (Urdu)

Hamza Malik · Mobile Engineering Lead & Programming Educator

4.8(18.4k)
96.3k22hBeginner
Save 33%
PKR 1,999PKR 2,999
Cyber SecurityUrdu + English

Ethical Hacking from Scratch

Bilal Ahmed · Penetration Tester & Security Consultant

4.7(8.9k)
47.3k38hBeginner
Save 29%
PKR 2,499PKR 3,499
BusinessUrdu + English

Amazon FBA & Daraz Selling Guide

Omer Farooq · Chartered Accountant & E-commerce Entrepreneur

4.5(5.3k)
29.9k27hBeginner
Save 14%
PKR 2,999PKR 3,499