365datascience Onboarding Report
Nazmul Islam Rakin
Data Modelling Analyst
Data Visualizer
Data Analyst
Microsoft Power BI
Microsoft SQL Server
SQL
This project analyzes user data from the 365datascience website, focusing on membership trends, subscription types, and engagement insights. The workflow includes data cleaning in Power Query, visualization in Power BI, and cross-validation using SQL to ensure accuracy and consistency.
Analysis Overview
Total Members and Paid Membership: Counts all members and calculates the percentage of paid members.
Survey Completion Rate: Calculates the total number of surveys completed and the percentage of completed surveys.
Monthly Trends: Tracks monthly registration and survey completions to highlight user activity patterns.
Country Distribution: Lists the top 5 countries by member count.
Subscription Type Analysis: Shows the percentage of each subscription type among users.
Sources and User Interests:
Primary sources where users heard about the platform.
Main topics of interest and learning goals among members.
Technology Used:
Power Query
Microsoft Power Bi
Microsoft SQL Server
Workflow
Data Cleaning: Conducted in Power Query to ensure data consistency and handle missing or inconsistent values.
Visualization: Built in Power BI to display trends, distributions, and insights in an interactive format.
Cross-Validation: SQL queries are used to validate key metrics and ensure data accuracy across different stages of the analysis.\
Queries and Results
The SQL queries in this repository provide a breakdown of metrics related to registration, subscription, survey completion, and demographic distribution. They are organized for easy execution and retrieval of insights on user demographics and engagement patterns.
