365datascience Onboarding Report by Nazmul Islam Rakin

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.

Like this project