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 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.
12 weeks72 credit hrs12 modules2 batches FMentorFaisal AdnanfromRs 25,000