Group project with: Aleksander Blok
Data warehouse for an E-Learning platform. Business goals of the e-learning platform “UniLearn” is to provide increase course completion rates by 4% compared to the previous year, and improve the average student grades by 8% by the end of the semester compared to the previous year. Source of data - e-learning platform database and data generators.
- Data Warehouse and Source Database design and implmentnation
- MDX queries
- KPI queries
- BI dashboards to represent the data.
- ETL process written in T-SQL and Enrollment Fact loading explanation
- Data generators in Python
- SCD 2 implementation and explanation.
- Visual Studio project Cube with hierarchies
- Project Documentation and DW optimization report
Data Warehouse consists of two fact tables, namely Fact_Enrollment and Fact_Teachings. The Fact_Enrollment table contains numerical data for each student's enrollment in a particular course, including their grades and results from surveys. With this data, we have been able to perform aggregation functions such as calculating the average grade, average tutor rate, and average competition percentage.
More screenshots available in report.pdf