Code School of Analytics
Business Intelligence

Data Warehouse and Business Intelligence

Every dashboard we've ever been called in to fix was really a data platform problem underneath. Wrong totals, history that vanished when a customer moved city, three definitions of revenue. This twelve-week course…

PhysicalOnline
Mentor Faisal Adnan12 weeksSaturday & SundayOnsite (Islamabad campus) + Online (live)72 credit hours0 EnrolledEnglish / UrduLast updated 26 Sept 2026

Course description

Every dashboard we've ever been called in to fix was really a data platform problem underneath. Wrong totals, history that vanished when a customer moved city, three definitions of revenue. This twelve-week course teaches you to build the platform properly, a warehouse that pulls from many operational systems, keeps history correctly, tests itself and serves fast, trustworthy numbers to Power BI. It's for analysts who want to move into BI engineering, data engineering or analytics engineering roles, at banks and telecoms here or remotely for firms abroad.

We work through one realistic retail-chain case from start to finish. Warehouse concepts and SQL for BI, dimensional modelling (star schemas, conformed dimensions, slowly changing dimensions), ETL and ELT pipelines, cloud warehouses such as Snowflake and BigQuery, dbt-style transformations with tests and docs, data quality gates, a semantic layer with governed metrics, Power BI wired to the warehouse the right way, and performance tuning. The capstone is a complete platform you build, document and present as you would to a client.

Classes are live on Saturdays and Sundays, on campus in Islamabad or online. Labs run on PostgreSQL and the free tiers of the cloud warehouses, so everything can be practised at home for nothing. You should already be comfortable with basic SQL and have used Power BI or something like it at least once.

Twelve-week roadmap of the Data Warehouse and Business Intelligence course

What You'll Learn

Explain what a warehouse is for, how it differs from the systems that run the business, and where it sits in a modern platform
Write the analytical SQL that BI tools depend on, multi-table joins, aggregations, window functions and CTEs a colleague can read
Design star schemas with the right grain, fact tables and conformed dimensions for real business processes
Build ETL and ELT pipelines with staging, batch control, incremental loads and reloads that don't duplicate rows
Implement slowly changing dimensions (Types 1, 2 and 3) so last year's report still says what it said last year
Work in Snowflake and BigQuery and organise transformations dbt-style with tests and documentation
Put a data quality gate and a semantic layer in place so every team, and every AI assistant, gets the same metric
Connect Power BI to the warehouse with the right storage mode and tune both ends when a report crawls
Certificate on completionWeekend classes, onsite or live onlineRecordings, SQL repositories and lab data stay yoursAn end-to-end capstone platform for your portfolioMentor code reviews of your SQL models, line by lineCareer guidance for BI and data engineering roles here and abroad

Skills You'll Gain

DWData warehousing
DMDimensional modelling
Analytical SQL
E/ETL / ELT design
SCSlowly changing dimensions
SASnowflake and BigQuery
DTdbt-style transformations
DQData quality testing
SLSemantic layer and metrics
Power BI on warehouses

Test Yourself

Profile operational sources

Explore the retail chain's POS, ERP and product API exports in PostgreSQL, write down grain, keys, volumes and quality problems, and propose which questions the warehouse must answer. You'll find the product API disagrees with the ERP on category. That's deliberate.

Hands-on Lab Task

Design and load a star schema

Model FactSales, DimDate, DimProduct, DimStore and DimCustomer at the right grain, generate surrogate keys and load them from staging with SQL.

Hands-on Lab Task

Implement a Type 2 dimension

Add valid_from, valid_to and is_current to DimCustomer, write the merge that closes old rows and inserts new versions, and prove with a query that a customer who moved from Lahore to Karachi still has last year's sales in Lahore.

Hands-on Lab Task

Build an incremental pipeline with batch control

Create a batch control table, load only new or changed rows each run, make the load safe to rerun and log row counts and status for every step.

Hands-on Lab Task

Add dbt-style models and tests

Split transformations into staging, intermediate and mart models, add not-null, unique and relationship tests, and generate lineage docs.

Hands-on Lab Task

Connect Power BI and tune it

Build a Power BI dataset over the marts, compare Import and DirectQuery, add an aggregation table and use query profiles to cut a slow report's time.

Hands-on Lab Task

Fee by mode

Onsite / physicalRs 45,000
Online (live)Rs 25,000
Duration12 weeks
ScheduleSaturday & Sunday
Modules12
Quizzes0
Skill levelIntermediate
CertificateYes