Analysis to present data on course revenue, in order to know which Course has the highest revenue, Also to understand and track where opportunities may lie to increase revenue generation, and track the performance of courses.
This is a project for the SoyHenry academy.
- eda.ipynb: Contain the EDA process for the
CSVfiles. - web_scrap.py: Contain the web scraping to the udemy web page.
- query.sql: Contain all the query to generate the dimension and fact tables based on the
CSVfiles created on te EDA process. - Datasets: Folder that contains original datasets.
- Dashboard: Folder that contains new generated dataset that were used to create the Power Bi dashboard.
- udemy_dashboard.pbix: Interactive dashboard in Power Bi.
For the project is used Github Action Project, you can access this project in the following link.
This project will follow the conventional commits of the following link.
Each task will be divided into an issue. Here you can find all the issues available at the moment.
The scheduled task timetable can be access in the following link.
It has been done a web scraping precess to the Udemy platform in order to get missing information such as rating and language.
For this task it has been created the following issue where you can find the task description to solve.
For this task it has been created the following issue where you can find the task description to solve.
For this task it has been created the following issue where you can find the task description to solve.
The following image shows an interactive dashboard:
Contains the KPIs values and different graphs that shows:
- Number of Courses per Year
- Average subscriber per subject
- Courses Subjects
- Average cost per subject and level
- Average of content duration per subject
- Average of rating per Subject and level
For this task it has been created the following issue where you can find the task description to solve.
It has created the following star model to work in the Power Bi environment:
This project is licensed under the GPL-2.0 license.