Data Analytics & Power BI

ZEF's Data Analytics & Power BI training is a practical programme of 3 months covering Excel, SQL, Power Query and Power BI. You learn to turn messy data into clear dashboards and insights, and finish with a portfolio of real analysis projects.

Benchmarked against the Microsoft PL-300 (Power BI Data Analyst) skill areas: prepare, model, visualise and analyse, deploy and maintain; and the Google Data Analytics certificate.

• 8 modules
• 8 hands-on tasks

1. 1Excel for Analysis4 topics

   Topics

   • Tables, sorting, filtering and conditional formatting
   • Lookup functions: XLOOKUP, INDEX/MATCH
   • Pivot tables and pivot charts
   • Basic statistics: averages, spread, growth

   You Will Be Able To

   • Turn a raw sales sheet into a clear summary with pivots
   • Use lookups to combine data from several sheets

   Hands-on

   • Analyse a 10,000-row sales file and present five findings
2. 2Data Cleaning4 topics

   Topics

   • Common data problems: blanks, duplicates, wrong types
   • Text and date functions
   • Validation and consistent categories
   • Documenting cleaning steps

   You Will Be Able To

   • Clean a messy dataset so it is ready for analysis
   • Keep a record of every change made

   Hands-on

   • Clean a real customer list and write a data-quality report
3. 3SQL for Analysts4 topics

   Topics

   • Relational databases and tables
   • SELECT, WHERE, ORDER BY, GROUP BY
   • JOINs across tables
   • Aggregations and subqueries

   You Will Be Able To

   • Query a database to answer business questions
   • Join several tables correctly

   Hands-on

   • Answer 15 business questions from a retail database with SQL
4. 4Power Query: Prepare the Data4 topics

   Topics

   • Connecting to Excel, CSV, folders and databases
   • Shaping data: split, merge, unpivot
   • Combining queries: append and merge
   • Refreshable, repeatable transformations

   You Will Be Able To

   • Build a refreshable data preparation flow in Power Query
   • Profile data quality before modelling

   Hands-on

   • Combine 12 monthly files into one clean, refreshable table
5. 5Data Modelling4 topics

   Topics

   • Fact and dimension tables (star schema)
   • Relationships, cardinality and filter direction
   • Date tables
   • Model performance basics

   You Will Be Able To

   • Design a star-schema model that answers questions correctly
   • Create and mark a proper date table

   Hands-on

   • Build a sales data model with products, customers, stores and dates
6. 6DAX Calculations4 topics

   Topics

   • Measures vs calculated columns
   • CALCULATE and filter context
   • Time intelligence: YTD, previous period, growth
   • KPIs and targets

   You Will Be Able To

   • Write DAX measures for core business KPIs
   • Compare periods with time intelligence

   Hands-on

   • Create a KPI measure set: revenue, margin, growth and target achievement
7. 7Dashboards and Visual Design4 topics

   Topics

   • Choosing the right chart
   • Layout, colour and accessibility
   • Interactivity: slicers, drill-through, bookmarks
   • Designing for mobile viewers

   You Will Be Able To

   • Build a clear, interactive dashboard for managers
   • Apply visual design rules so insights stand out

   Hands-on

   • Design a one-page sales performance dashboard with drill-through
8. 8Sharing, Security and Storytelling4 topics

   Topics

   • Publishing to the Power BI service
   • Workspaces, apps and scheduled refresh
   • Row-level security
   • Presenting insights as a story

   You Will Be Able To

   • Publish and share a report securely
   • Present data findings to non-technical managers

   Hands-on

   • Capstone: deliver and present a KPI dashboard with recommendations

You complete weekly analysis tasks and a capstone dashboard built from a raw dataset. Assessors check data cleaning, the accuracy of your measures, dashboard design and how clearly you explain the findings. Your result is Competent or Not yet competent, with a chance to resubmit.

1. Assessment 1After modules 1–3
2. Assessment 2After modules 4–6
3. Final assessmentAfter all 8 modules, for your certificate

• 727,381Pakistanis registered for jobs abroad in 2024Source: BE&OE
• $38.3 billionsent home by overseas Pakistanis in 2024-25Source: State Bank of Pakistan
• $1.76 billionearned by Pakistani freelancers in 2025-26Source: State Bank of Pakistan

These are published national figures and market benchmarks to help you plan, not a promise of a job or income. What you earn depends on your skills, experience, employer and city. Subject to employer, licensing, visa and qualification-recognition requirements.