Projects

Workstreams
involving my
PROJECT

Empowering Data-Driven Decisions with Advanced Analytics.

POWER-BI

Curated Bank Credit Card Choices

This project aimed to assist the bank in launching a new credit card line by analyzing data from 4000 customers across five cities. Focusing on online spending patterns and demographic information, the project utilized Power BI, Python, and Excel to provide comprehensive customer segmentation, uncover trends in spending and demographics, and create an interactive data-driven dashboard. Key findings included clear customer segmentation and actionable recommendations for personalized credit card features and targeted marketing strategies. Continuous data analysis was recommended to stay adaptive to market changes. The project’s success relied on effectively presenting the findings to stakeholders, especially Mr. Bashnir Rover’s team.

Comprehensive Business Insights

Comprehensive Business Insights is a project focused on providing a 360-degree view of business operations. Through advanced data analytics and visualization tools, it offers detailed insights into market trends, consumer behavior, and operational efficiencies. Utilizing a combination of Power BI, Python scripting, and Excel, the project delivers comprehensive reports and interactive dashboards that enable informed decision-making. Key outcomes include strategic recommendations for business growth, optimization of resources, and enhanced market competitiveness. Continuous analysis ensures adaptability to evolving market dynamics, making Comprehensive Business Insights a crucial tool for proactive business management.

SQL

Impromptu Requests | Consumer Goods Domain

Welcome to the Atliq Hardwares! In the fast-paced world of consumer goods, where data-driven decisions are paramount, Atliq Hardwares, an industry leader in computer hardware production, has recognized the need for quick and informed decision-making. To meet this demand, they are expanding their data analytics team with the goal of hiring junior data analysts who possess both technical expertise and essential soft skills.

Insightful MySQL Data Analysis by Maven Analytics

In my ongoing “Advanced MySQL Data Analysis by Maven Analytics” course, I worked as an eCommerce Database Analyst for Maven Fuzzy Factory, an emerging online retailer. Our midterm project aimed to uncover actionable insights from the eCommerce database. Key findings included the vital role of Gsearch in driving growth, promising results from non-brand and brand campaigns, and the significance of mobile traffic. A/B testing revealed incremental revenue opportunities, and our website’s overall performance improved, as reflected in higher session-to-order conversion rates. This project emphasized the power of data analysis in informing strategic decisions, enhancing user experience, and driving business growth.

AIRBNB Outlier Detection and EDA

Analyzed Airbnb’s European booking dataset, revealing room type trends, pricing influences, and cleanliness’s impact on guest satisfaction. Outlier detection refined data, highlighting hygiene’s role. Data-driven insights empower hospitality for exceptional guest experiences.

Cohort Analysis on Online Retail Data

This project involves performing cohort analysis on retail data using SQL queries. Through categorizing customers based on their first purchase month, insights into customer behavior, retention rates, revenue trends, and lifetime value are extracted to inform business strategies and decisions.

EXCEL

Eco-Friendly Sales Performance | Excel Dashboard

The “Eco-Friendly Sales Performance Metrics” dashboard provides a comprehensive overview of sales-related data. It includes analyses of total earnings and paid calls, highlights the top 5 consultants with sales revenue by month, and identifies highest, lowest, and average monthly revenues. It also offers insights into the percentage of paid and unpaid calls, training model fees by sales team, and enrolled courses by training level. Additionally, it showcases paid call duration statistics, advertising spend by channel, total sales by sales team, and top-performing consultants and training models. The dashboard allows for effective performance evaluation and decision-making within the Eco-Friendly sales team.

SQL

Cohort Analysis on Online Retail Data

Explore insightful articles on analytic projects, offering expert tips, trends, and strategies for data-driven decision-making.

Power BI

Website Traffic Data Visualization

This project showcases the process I followed to take website traffic data from my personal website, rafichowdhury.com, using Google Analytics 4 (GA4). I exported the data to Google Sheets for cleaning, and then visualized the cleaned data using Power BI. The final visualizations provide insights into the website traffic patterns and user behavior.

Power BI

Sample Payroll Sheet

Payroll Sheet Example This repository showcases a sample payroll sheet created using random names. The purpose of this project is to demonstrate how to generate and manage payroll data, which can be helpful for learning and reference purposes.

Workstreams involving my PROJECT

POWER-BI

Curated Bank Credit Card Choices

Comprehensive Business Insights

SQL

Impromptu Requests | Consumer Goods Domain

Insightful MySQL Data Analysis by Maven Analytics

AIRBNB Outlier Detection and EDA

Cohort Analysis on Online Retail Data

EXCEL

Eco-Friendly Sales Performance | Excel Dashboard

SQL

Cohort Analysis on Online Retail Data

Projects

Power BI

Website Traffic Data Visualization

Power BI

Sample Payroll Sheet

Workstreams
involving my
PROJECT