Customer Engagement Analysis Report for 365datascience Platform
Nazmul Islam Rakin
Data Modelling Analyst
Data Visualizer
Data Analyst
Microsoft Power BI
Microsoft SQL Server
SQL
This project analyzes user engagement and subscription trends on the 365datascience platform, identifying key insights to guide strategic decisions in user retention and satisfaction.
Key Performance Indicators (KPIs)
Total Students: Total registered users
Total Courses: Number of available courses
Total Countries: Geographical reach of users
Average Course Rating: Aggregated course ratings
Key Analysis
Student Registration Trends by Month and Weekday
Purchases Trends by Month and Weekday
Total Hours Watched Trends by Month and Weekday
Purchase Type Distribution
Paid vs. Free Membership Ratio
Course Metrics:
Analysis by total hours watched, average rating, and rating count.
Geographical Analysis by Country
Most students
Highest engagement (hours watched)
Highest purchases
Relationship between rating and customer engagement (content hours watched).
Key Insights
Peak User Growth: Registrations peak in August, with Monday as the top sign-up day.
Purchasing Patterns: July and Thursdays show the highest purchases, indicating a mid-year buying trend.
Engagement Peaks: August sees the highest content consumption, with Tuesdays and Wednesdays as high engagement days.
Subscription Preferences: Users prefer the annual plan, indicating long-term learning commitment.
Geographical Insights: India leads in total students, while the US shows high engagement and purchase rates, with paid users investing more time in content.
Paid members in particular investing more time in content.
Higher average rated course tends to have more engagement.
Tools & Workflow
Data Source: MS SQL Database
ETL: Power Query for data cleaning and transformation
Dashboard: Power BI for visualizations and reporting
Validation: SQL queries for cross-checking data accuracy
