Examination System - BI Edition

A full-stack business intelligence solution for managing and analyzing an online examination system. This project combines OLTP, DWH, ETL, SSRS reports, OLAP cubes, and Power BI dashboards.

? Project Modules

1. OLTP Database (SQL Server)

ERD Diagram & Backup

Stored Procedures (CRUD, Exam Logic)

Reports (via Stored Procedures)

2. Data Warehouse (DWH)

Star Schema

ETL with SSIS

Cubes with SSAS

Reports with SSRS

3. Power BI Dashboards

20+ Interactive Dashboards

Analysis on certificates, freelancing, hiring, and performance

4. Desktop App (Bonus)

Windows-based UI for managing exams