Admissions are open for the Fall 2026 batches - limited seats, apply today! Apply now
Duration
12 Weeks
Mode
Hybrid
Audience
Working Professionals
Certificate
Verified

Turn spreadsheets into executive dashboards - advanced Excel, Power Query, DAX and Power BI storytelling for business analysts.

The Data Analytics with Power BI & Advanced Excel program at ITA Academia is a 8-week, mentor-led track designed around real industry workflows. Every module combines live instruction with guided labs, and ends with a graded deliverable that goes straight into your portfolio.

What makes this course different

  • Project-based learning: you build real, demonstrable work - not just slides and quizzes.
  • Industry mentors: taught by practitioners who are actively shipping in their domain.
  • Career systems: CV and portfolio reviews, mock interviews and placement support through our hiring-partner network.
  • Flexible pacing: morning, evening and live-online batches with recorded sessions for revision.

By the end of this course you will be able to

  • Master lookups, pivot tables and Power Query
  • Model data and write DAX measures
  • Design interactive Power BI dashboards
  • Publish and share reports securely
  • Tell data stories to stakeholders

Certification

Graduates receive an ITA Academia verified certificate of completion and a transcript of assessed projects. Selected students are recommended to hiring partners and internship programs.

What you will learn

  • Master lookups, pivot tables and Power Query
  • Model data and write DAX measures
  • Design interactive Power BI dashboards
  • Publish and share reports securely
  • Tell data stories to stakeholders

Who should attend

  • Working professionals upskilling for promotion or career change
  • Freelancers and agency owners
  • Managers who need hands-on technical literacy

Prerequisites

No prior experience required. Basic computer literacy and a laptop are recommended.

Course curriculum · 7 modules

Hands-on sessions, guided labs and a graded assignment covering advanced excel functions.

  • Concepts & live demo
  • Guided lab exercise
  • Assignment & review

Hands-on sessions, guided labs and a graded assignment covering pivot tables & power query.

  • Concepts & live demo
  • Guided lab exercise
  • Assignment & review

Hands-on sessions, guided labs and a graded assignment covering power bi desktop & data modeling.

  • Concepts & live demo
  • Guided lab exercise
  • Assignment & review

Hands-on sessions, guided labs and a graded assignment covering dax measures.

  • Concepts & live demo
  • Guided lab exercise
  • Assignment & review

Hands-on sessions, guided labs and a graded assignment covering dashboard design.

  • Concepts & live demo
  • Guided lab exercise
  • Assignment & review

Hands-on sessions, guided labs and a graded assignment covering publishing & governance.

  • Concepts & live demo
  • Guided lab exercise
  • Assignment & review

Hands-on sessions, guided labs and a graded assignment covering business case project.

  • Concepts & live demo
  • Guided lab exercise
  • Assignment & review
Dr. Sarah Ahmed

Dr. Sarah Ahmed

Python & Research Analytics Instructor · ex Jazz

Sarah bridges academia and industry - she supervises MS/PhD research analysis and teaches Python for data-driven decision making.

Python AutomationData AnalysisResearch Statistics
Related

More in Data Science & AI