Modayo/Capstone-Customer-Data

Data Analysis Journey with Ladies in Tech Africa - Project 2 # Capstone-Customer-Data Data Analysis Journey with Ladies in Tech Africa - Project 2 # LITA-Capstone-Project: CUSTOMER DATA REPORT This project is one of the data analysis project submitted as one of the requirements for successful completion of a ten week data analytic training programme organized by The Incubator Hub-Ladies in Tech Africa.(linkedin.com) ## **PROJECT OVERVIEW** --- This project requires an in-depth study of subscription pattern of the customers of a Tech Company. The company seeks to understand the most preferable subscription package among their customers. Thereby gaining an insight into their top performing products and region in terms of subscribers' retention, subscription packages and revenue generation. It is expected that an interactive power BI dashboard will be produced for the store. ## **OBJECTIVES** --- The objective of this project is to: - determine the regional revenue trend - determine the total revenue - Determine the Cancellation rate - identify the most subscribed package - identify any other useful insight ## **Data Analysis Tools** --- The data analysis tools used for the project are 1. Microsoft Excel - For Data Cleaning - For Data Exploration and initial analysis 2. SQL Server: - SQL Queries for Exploratory Analysis. 3. Microsoft Power Bi - For Visualization and Report ## **EXPLORATORY DATA ANALYSIS** SQL Server Query --- ``` Select * from[dbo].[LITA_Capstone_Customer_Data] ---1. Retrieve Total Number of Customer from each region for Customer Data---- Select [Region],Count (CustomerID) as Total_No_of_Customers from [dbo].[LITA_Capstone_Customer_Data] Group by Region --Q2 Most popular subscription type by the number of customers. SELECT SubscriptionType,COUNT(CustomerID)AS No_Of_Customers FROM [dbo].[LITA_Capstone_Customer_Data] GROUP BY SubscriptionType --Q3 Find customers who canceled their subscription within 6 months SELECT CustomerName,Canceled,Subscripti …