Data & Security · Beginner
Data Analytics with Excel & Power BI
Turn raw business data into dashboards managers act on, using Excel, Power Query and Power BI.
- 2 monthslength
- 4modules
- 16+skills taught
- Rs 12,000per month
About this course
What you will study
Every business in Faisalabad runs on spreadsheets, and almost nobody can read them properly. This course makes you the person who can: clean the data, model it, and show the answer on one screen.
You build three dashboards from real sales, stock and fee-collection data, and learn how to present findings to a manager in five minutes.
The plan
What you will learn, module by module
4 modules over 2 months. Each one ends with something you built, not a quiz you guessed.
-
Module 1: Data hygieneWeeks 1–2
What you will learn in this module
- Types
- Duplicates
- Missing values
- Validation
You finish this module with: A cleaned dataset with documented transformation steps
-
Module 2: Excel powerWeeks 3–4
What you will learn in this module
- Lookups
- Pivots
- Conditional logic
- Charts
You finish this module with: Pivot tables and charts that answer three business questions
-
Module 3: Power BIWeeks 5–6
What you will learn in this module
- Import
- Relationships
- DAX basics
- Visuals
You finish this module with: A Power Query model that refreshes on one click
-
Module 4: ReportingWeeks 7–9
What you will learn in this module
- Dashboards
- Refresh
- Sharing
- Storytelling
You finish this module with: A Power BI report with filters a manager can drive himself
After the course
What you will be able to do
- Clean and combine messy sheets with Power Query
- Write formulas and pivot models that do not break
- Publish an interactive Power BI dashboard
- Present a finding with a recommendation, not just numbers
Included in the monthly fee
- One computer per student, every class
- Teacher feedback on your code or your files, in class
- Free access to the browser coding lab between classes
- Certificate with a QR code any employer can verify
- One free make-up sitting per month if work or family interrupts you
Money
Fee and batch
- Monthly feeRs 12,000
- Usual fee elsewhere
Rs 15,000 - Duration2 months
- Admission feeNone
- Exam feeNone
- Certificate feeNone
Pay by cash, JazzCash or bank transfer at the desk. The office marks it in your ledger the same day.
Practise tonight
Test the course before you pay for it
Every course here has a matching practice track in the browser lab, and the first ten tasks are free without an account. Open it tonight, finish a few tasks, and see whether this is the subject you actually enjoy.