AI Computer Science Academy · Faisalabad

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 35,000per month
Apply for the next batch Try the free lab first

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.

Fee and batch

  1. Data hygiene

    Weeks 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

  2. Excel power

    Weeks 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

  3. Power BI

    Weeks 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

  4. Reporting

    Weeks 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 35,000
  • Usual fee elsewhereRs 45,000
  • Duration2 months
  • Admission feeNone
  • Exam feeNone
  • Certificate feeNone
Apply for this course Call +92 325 8000848

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.

Open SQL & Databases

Also in Data & Security

Courses that go well with this one

Data & Security Beginner 2 months

Cyber Security Essentials

Protect accounts, websites and networks — and learn the attacks from the defender side.

Rs 35,000 / month Details