Workstreams
involving my
PROJECT
POWER-BI
SQL
EXCEL
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
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.
Projects
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.