Tracking User Engagement with SQL, Excel, and Python Project

Background: Throughout this Tracking User Engagement with SQL, Excel, and Python project, you’ll work with a real dataset from our company’s data. The project requires you to analyze whether the new additions to the platform (new courses, exams, and career tracks) have increased student engagement.

You are given the following information:

• Holder (student ID) and issuance date of certificates issued in Q2 2022
• Student ID and registration date of students registered between January 1, 2020 and June 30, 2022
• Student ID, product type, purchase date, and refund date (if applicable) of purchases made between January 1, 2020 and June 30, 2022
• Student watching (student ID), time watched, and date of courses watched in Q2 2021 and Q2 2022

We have, of course, restrictеd the dataset volume and made sure to protect our customers’ privacy.

Hypothesis: The first half of 2022 was expected to be profitable for the company. The reason was the hypothesized increased student engagement after the release of several new features on the company’s website at end-2021. These include enrolling in career tracks and testing your knowledge through practice, course, and career track exams. Of course, we have also expanded our course library to increase user engagement and the platform’s audience as more topics are covered. By comparing different metrics, we can measure the effectiveness of these new features and the overall engagement of our users.

Guidelines: Every data scientist has their preferred methodology. Two data scientists solving a task may obtain the same result using different tools. This implies that throughout this project, analyzing the data correctly and extracting meaningful results is more important than your approach.
Nevertheless, we provide optional guidance with the tools taught in the courses from the Data Science career track.

For this Tracking User Engagement with SQL, Excel, and Python project, you’ll be working with MySQL Workbench 8.0 (or later), Excel 2007 (or later), and Python 3, where you’ll need to prepare the following libraries:

• pandas
• matplotlib
• statsmodels
• scikit-learn
• seaborn (optional)