Virtual learning performance analysis with SQL + interactive Excel dashboard

Project description: A data analyst who works at a university is tasked to perform data analysis to review students’ performance on Virtual Learning Environment (VLE) in order for Management to make business decision whether to offer more online courses.

1. Data collection

Research from Kaggle: https://www.kaggle.com/rocki37/open-university-learning-analytics-dataset

2. Data analysis using SQL

• Explore and observe the relationships using statistical methods
• Join tables
• Clean unwanted columns/ data that won’t add value to the analysis

3. Interactive Excel dashboards

Dashboard

4. Insights and recommendations