This repository contains the source code and documentation for graduation project of ITI: POWER BI Track: Examination System. The project encompasses various components including an ERD, database creation on SQL Server, stored procedures, SSRS reports, Power BI dashboards, and a simple student portal website.
Examination system for an educational institution that provides the following:
- Dashboards for supervisors and managers to analysze student data, instructors performance and more.
- guidance for professors to evaluate exams and get valuable feedback.
- Excel
- SQL BI (SSIS, SSRS)
- MSSQL Server
- Power BI
-
ERD (Entity-Relationship Diagram): This visual representation illustrates the database structure and relationships between different entities in the system.
-
Mapping: Describe how data is mapped from the front end to the database and vice versa.
-
Database Creation on SQL Server: Provides instructions on setting up the database environment on SQL Server.
-
Stored Procedures: Contains the SQL procedures used for specific functionalities within the system.
-
SSRS Reports: This section covers the reports generated using SQL Server Reporting Services and the associated stored procedures.
-
Dashboards using Power BI: Provides details about the Power BI dashboards and the data sources they connect to.
-
Student Portal Website: Contains the code and files for the front-end interface accessible to students. find more about the website from here Screenshots from the website:
- View the full documentation of the project here.