RAKSHIT MITRA

CASE STUDY :   BELLABEAT'S NEW PRODUCT MARKET STRATEGY

Capstone Project, Coursera.

• Objective - Use SQL, R programming, and Tableau to analyze data and gain insights into customer behavior and product usage to inform Bellabeat's marketing strategy.
• Process - Collected, cleaned, and organized data using SQL queries and spreadsheets. Generated a comprehensive report on customer behavior and product usage using R. Visualized data trends and insights using Tableau
• Expected outcome - Identified trends and patterns in customer behavior, and devised market strategy to optimize product features, retain existing customers, attract new customers, and increase revenue and business growth

EXPLORATORY DATA ANALYSIS (EDA) -  SUPERMARKET SALES DATASET

• Performed data cleaning and manipulation with python and to ensure data integrity and accuracy of the analysis.
• Explored single variables for customer ratings individually and looked for patterns and relationships.
• Performed Bivariate Analysis for budget and customer ratings and examined for correlations.

CASE STUDY: ANALYZING CUSTOMER CHURN IN TABLEAU

• Objective - Analyze customer churn using Tableau and gain insights into the reasons behind customer attrition.
• Process - Tableau analysis process with data checking, calculating the churn rate, investigating the reasons for churn, and visualizing the churn rate by region or location.
• Expected outcome - Identifying the factors and gaining insight from the analysis to improve customer retention strategies and increase customer loyalty.