Course List

Our Courses

Credit-hour based, hybrid and online programs across Data Analytics, AI & BI.

Data EngineeringIntermediate
NewOnsiteOnline

Become a Hands-on Fabric Expert

Ask a data team in Islamabad or Karachi what they are moving to and a lot of them say Microsoft Fabric. One platform with storage, pipelines, Spark, a SQL warehouse, real-time data and Power BI under the same roof. The catch is that people who already know Power BI or SQL open Fabric for the first time and can't tell which of the many items to create first. This course fixes that, with eight weeks of building real things in a real Fabric workspace. Onsite, we meet for five classes a week, Monday to Friday, three hours each, in either the 3:00 to 6:00 PM or the 6:00 to 9:00 PM shift. That is the pace the outline below is written for. The online batch meets on Saturday and Sunday and follows the same week-by-week outline at its own pace, so you cover the same topics and the same labs. We build one story from week one to week eight: a Pakistani business sends us messy files, and we turn them into a governed, refreshing, secured dashboard. You'll write PySpark and T-SQL, build pipelines, model for Direct Lake, stream a few events into a KQL database and set an alert on them. The course also helps you prepare for Microsoft's DP-600 (Fabric Analytics Engineer) and DP-700 (Fabric Data Engineer) exams. Those exams are Microsoft's own, we can prepare you but we can't promise a pass. Fabric changes its menus often, so we teach the concepts first and tell you to check Microsoft's current documentation whenever a detail is likely to move.

8 weeks120 credit hrs8 modules3 batches
MentorFaisal AdnanfromRs 25,000
Business IntelligenceIntermediate
NewOnsiteOnline

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
MentorFaisal AdnanfromRs 25,000
Trusted by students and graduates of leading universities across Pakistan
Bahria University
PMAS Arid Agriculture University
International Islamic University
Federal Urdu University
FAST National University
Quaid-i-Azam University
Riphah International University
COMSATS University
NUST
Air University
Iqra University
Foundation University
Bahria University
PMAS Arid Agriculture University
International Islamic University
Federal Urdu University
FAST National University
Quaid-i-Azam University
Riphah International University
COMSATS University
NUST
Air University
Iqra University
Foundation University