Select Page
3-month program · Arfa Software Technology Park, Lahore

Data Analytics with Excel & Power BI Course in Lahore, Pakistan

Turn raw data into decisions at Ideo College, Lahore. Learn advanced Excel, pivot tables, Power Query, DAX and Power BI dashboards through real business projects and build a portfolio for analyst roles and freelancing.

3 monthsDuration
24 lectures2 per week
CertificateIdeo College
From Rs 25,000Installments available
Why Data Analytics with Excel & Power BI

Decisions need data that people can read

Every department runs on reports. Analysts who clean data, model it and present it in Excel and Power BI help leaders act on facts.

📊

Excel remains the office standard

Advanced Excel and automation are still asked for in most analyst jobs.

📈

Power BI turns data into dashboards

Star schemas and DAX produce reports that update by themselves.

🗣️

Storytelling gets you heard

You learn to present insights so executives act on them.

🧾

Business-ready projects

Sales, inventory, financial P&L and retail revenue dashboards fill your portfolio.

★

In 12 weeks you go from the first lecture to 6 portfolio-ready projects, with live classes, LMS recordings and job-cell support behind you.Ideo College • Ideoversity, Lahore

3-Month Roadmap

Your 12 weeks, lecture by lecture

24 live lectures, two sessions a week, with LMS recordings. Choose a month and open any lecture to see what you will learn.

24Lectures
12Weeks
Week 1 · Day 1Data Analytics Foundations & Clean Data Architecture
  • Role of a Data Analyst, structured vs. unstructured data
  • Tabular data rules, data validation, named ranges
  • Spreadsheet best practices
Week 1 · Day 2Core Business & Lookup Functions
  • Mastering XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, AVERAGEIFS
  • IFERROR for multi-condition financial and sales reporting
Week 2 · Day 1Modern Dynamic Array Formulas
  • Building self-updating reports with FILTER, SORT, SORTBY, UNIQUE
  • XLOOKUP multi-criteria formulas
  • Dynamic dropdowns and conditional formatting
Week 2 · Day 2Data Cleaning & Wrangling Real-World Datasets
  • Fixing messy exports using TEXTSPLIT, TEXTJOIN, TRIM, CLEAN
  • Date/time parsing, duplicate handling
  • AI-assisted formula troubleshooting
Week 3 · Day 1PivotTables, PivotCharts & Interactive Slicers
  • Multi-dimensional slicing, grouping by dates/tiers
  • Calculated fields, % of grand total/parent row, timelines
  • Synchronized PivotCharts
Week 3 · Day 2Financial Modeling & What-If Analysis
  • Budget vs. Actual variance analysis, Goal Seek, Scenario Manager
  • Two-variable Data Tables, trendline sales forecasting
Week 4 · Day 1Power Query ETL Automation in Excel
  • Connecting to CSV, folder, web sources, unpivoting columns
  • Merging and appending multi-month files, one-click data refresh
Week 4 · Day 2Month 1 Milestone: Executive Excel KPI Dashboard
  • End-to-end lab: transforming raw retail datasets via Power Query and designing a boardroom-ready interactive Excel dashboard (Project 1 & 2)
Week 5 · Day 1Transitioning to Power BI Desktop
  • Business Intelligence workflow
  • Power BI Desktop interface (Report, Table, Model views)
  • Connecting to Excel, SQL/CSV, live web APIs
Week 5 · Day 2Advanced Power Query & M Language Transformations
  • Data profiling, conditional columns, custom M formulas
  • Query parameters, handling null/error rows
  • Query folding principles
Week 6 · Day 1Relational Data Modeling & Star Schema
  • Fact vs. Dimension tables, primary/foreign keys
  • Cardinality (1:Many), filter direction
  • Avoiding flat-table performance traps
Week 6 · Day 2DAX Foundations: Measures vs. Calculated Columns
  • Understanding row context vs. filter context
  • Organizing dedicated measure tables
  • Aggregation functions (SUM, DISTINCTCOUNT, DIVIDE)
Week 7 · Day 1Intermediate DAX: CALCULATE & Iterator Functions
  • Mastering CALCULATE, FILTER, ALL, ALLEXCEPT, RELATED
  • Row-by-row iterators (SUMX, AVERAGEX, RANKX) for dynamic business logic
Week 7 · Day 2Time Intelligence & Growth Analytics in DAX
  • Building custom Calendar tables, calculating YoY, MoM, MTD, QTD
  • YTD revenue, moving averages, same-period-last-year comparisons
Week 8 · Day 1AI Co-Pilot for DAX, Debugging & Data Insights
  • Prompt engineering with ChatGPT and Claude to write complex DAX patterns
  • Optimize slow measures, generate automated data dictionaries
Week 8 · Day 2Month 2 Milestone: Multi-Table Sales & Revenue Model
  • Hands-on build: modeling an e-commerce dataset with Star Schema and 15+ core DAX KPIs
  • Mentor audit and Project 3 sign-off
Week 9 · Day 1Visual Storytelling & Dashboard UX Design
  • Choosing the right chart for every metric, KPI cards
  • Z-pattern visual hierarchy, color psychology, custom themes
  • Decluttering reports
Week 9 · Day 2Interactive App-Like UX in Power BI
  • Building navigation panels with Bookmarks, Page Navigation
  • Drill-Through detail views, Custom Report Tooltips
  • Dynamic Field Parameters
Week 10 · Day 1Power BI Built-in AI Visuals & Predictive Analytics
  • Root-cause analysis with Decomposition Trees
  • Key Influencers visual, Natural Language Q&A, Smart Narratives
  • Anomaly detection
Week 10 · Day 2Power BI Service, Cloud Sharing & Security (RLS)
  • Publishing reports to Power BI Service
  • Configuring scheduled gateways/refreshes, packaging Workspace Apps
  • Enforcing Row-Level Security
Week 11 · Day 1Industry Domain Lab: Supply Chain & HR Analytics
  • Designing cross-functional dashboards for logistics/delivery bottlenecks and HR workforce retention & attrition tracking (Projects 4 & 5)
Week 11 · Day 2Building an Interactive Data Analytics Portfolio
  • Hosting live embeddable Power BI dashboards on NovyPro
  • Documenting business cases on GitHub
  • Structuring an executive LinkedIn profile
Week 12 · Day 1Freelancing on Fiverr & Upwork + Job Interview Prep
  • Packaging high-ticket Excel & Power BI dashboard gigs
  • Writing winning client proposals, technical case-study tests
  • Salary negotiation
Week 12 · Day 2Final Capstone Presentation & Certification
  • Live executive presentation of your end-to-end Capstone BI solution
  • Portfolio evaluation, Job Cell onboarding, certificate award

What you will build

✓Automated Sales & Inventory Tracker (Excel)
✓Executive Financial P&L & Variance Report (Excel)
✓E-Commerce & Retail Revenue Intelligence (Power BI)
✓Supply Chain & Logistics Operations Dashboard (Power BI)
✓HR Workforce & Attrition Analytics (Power BI)
✓Final Capstone Business Intelligence Solution
75K+Students trained across Asia
90+Career-focused courses
3months to job-ready skills
24/7LMS and support access
Book your seat

Start learning this weekend

The Data Analytics with Excel & Power BI Course runs for 3 months with 24 live lectures. The fee starts from Rs 25,000. Call or WhatsApp us for the next batch, book early for the early bird discount, or spread the fee with our installment plan.

LahoreArfa Tower
On campus+ LMS access
Data Analytics with Excel & Power BI Course
from Rs 25,000
3 monthsDuration
24 lectures2 per week
LMSRecordings
  • Advanced Excel
  • Pivot Tables
  • Power Query
  • DAX
  • Ideo College certificate
  • Expert mentorship
★ Early bird discount★ Installment plan availableAsk about discounts →
Questions

Data Analytics with Excel & Power BI Course FAQs

What is the fee and schedule?

The Data Analytics with Excel & Power BI Course runs for 3 months with 24 live lectures, two sessions a week, and LMS recordings. The fee starts from Rs 25,000. Call 0300-8642269 or message us on WhatsApp for the next batch dates. An early bird discount and an installment plan are available.

Will I get a certificate?

Yes. Every student who completes the course receives an Ideo College certificate.

Where are the classes held?

At Office #01, 3rd Floor, Arfa Software Technology Park, Lahore, with course material on our Learning Management System.

How do I book my seat?

Click Book This Course to enroll online, call 0300-8642269, or message us on WhatsApp and our team will guide you.

Explore more courses

Ideo College offers 90+ career-focused courses in Lahore. Find the next skill to add to your profile.

Limited seats in every batch

Your new career starts here.

Join the Data Analytics with Excel & Power BI Course in Lahore and build practical skills that get you hired or paid.

Data Analytics with Excel & Power BI Course · From Rs 25,000Book now

Data Analytics with Excel & Power BI Course in Lahore in Lahore at Arfa Tower: What You Learn

Digital skills training

Build in-demand digital skills with Data Analytics with Excel & Power BI Course in Lahore at Ideo College, Arfa Software Technology Park, Lahore.

Skill development program

As part of our skill development program, Data Analytics with Excel & Power BI Course in Lahore is taught by Ideo College with NAVTTC, PSDA and PBTE affiliation. Call 0300-8642269 or 0321-0222118, 9am to 10pm, Monday to Sunday.

Frequently Asked Questions

What will I learn in Data Analytics with Excel & Power BI Course in Lahore?

Data Analytics with Excel & Power BI Course in Lahore is taught through practical, instructor-led sessions at Arfa Tower. Ask admissions for the current syllabus.

Where is Data Analytics with Excel & Power BI Course in Lahore taught?

Data Analytics with Excel & Power BI Course in Lahore is taught in person at Ideo College, Arfa Software Technology Park (Arfa Karim Tower), Lahore.

Is Ideo College affiliated with any authority?

Yes. Ideo College is affiliated with NAVTTC, PSDA, PBTE, the Lahore Chamber of Commerce and FBR.

How do I get the fee, duration and batch timings for Data Analytics with Excel & Power BI Course in Lahore?

Call 0300-8642269 or 0321-0222118. We are open 9am to 10pm, Monday to Sunday.

Will I receive a certificate?

Ideo College issues course certificates, which can be checked on our certificate verification page.