Embedded Files
SaaS Customer Churn & Retention Analysis
SaaS Customer Churn & Retention Analysis
Python · SQL · pandas · scikit-learn · Streamlit
PROJECT OVERVIEW
Built a SaaS customer churn and retention analysis project using Python, SQL, machine learning, and Streamlit. Analyzed customer behavior, identified churn drivers, trained a Random Forest churn model, and developed an interactive dashboard to support retention decisions. Read more..
Automated Financial Reporting System (AI-Powered Insights & Email Automation)
Automated Financial Reporting System (AI-Powered Insights & Email Automation)
PROJECT OVERVIEW
Built an end-to-end automated financial reporting system that ingests raw transaction data, processes and analyzes spending behavior, and delivers structured monthly insights via email — eliminating manual reporting workflows.
Designed to simulate how modern businesses automate financial visibility and decision-making.
THE PROBLEM
Manual financial tracking is time-consuming, error-prone, and often underutilized.
Users rely on spreadsheets but rarely extract meaningful insights due to:
Inconsistent data structure
Lack of automation
No real-time or scheduled reporting
This results in poor financial awareness and delayed decision-making.
Screenshot of Email Report
Screenshot of Email Report
Screenshot of Google Sheet
Screenshot of Google Sheet
Github Workflow run
Github Workflow run
This project reflects my interest in building systems that combine data, automation, and decision-making. View Code
Supermarket Sales Analysis - Power BI
Supermarket Sales Analysis - Power BI
Tools: SQL, Power BI, Excel
This Power BI Dashboard provides a comprehensive view of supermarket performance, highlighting sales trends, customer behavior, and financial health. By leveraging these insights, management can take data-driven decisions to boost profitability, enhance customer loyalty, and optimize operations. Read more
This Power BI Dashboard provides a comprehensive view of supermarket performance, highlighting sales trends, customer behavior, and financial health. By leveraging these insights, management can take data-driven decisions to boost profitability, enhance customer loyalty, and optimize operations. Read more
Customer Segmentation & Forecasting
Customer Segmentation & Forecasting
Tools: SQL, Power BI, Python, Excel
Conducted customer segmentation analysis, leading to a 15% increase in targeted marketing effectiveness. Developed interactive dashboards and predictive models for sales forecasting. GitHub Repository
Conducted customer segmentation analysis, leading to a 15% increase in targeted marketing effectiveness. Developed interactive dashboards and predictive models for sales forecasting. GitHub Repository
Sales Analysis & Forecasting
Tools: SQL, Power BI, Python, Excel
Queried and cleaned sales data, created a Tableau dashboard for real-time insights, and improved inventory planning. GitHub Repository
Queried and cleaned sales data, created a Tableau dashboard for real-time insights, and improved inventory planning. GitHub Repository
Superstore Sales Dashboard - Tableau
Tools: Tableau
This dashboard provides a comprehensive view of sales and profitability metrics, highlighting key performance indicators across different segments, categories, and regions. The data suggests a balanced distribution of sales across segments and categories, with notable variations in profitability ratios and significant contrasts in total profitability by country. Read more
This dashboard provides a comprehensive view of sales and profitability metrics, highlighting key performance indicators across different segments, categories, and regions. The data suggests a balanced distribution of sales across segments and categories, with notable variations in profitability ratios and significant contrasts in total profitability by country. Read more
My YouTube Channel Dashboard - PowerBI
Tools: PowerBI
In today's digital landscape, content creators must strategically analyze performance metrics to optimize growth and engagement. This YouTube dashboard provides valuable insights into the performance of DAPRINCETECH TUTORIALS, a tech-focused channel. By examining key metrics such as subscriber count, total videos, view distribution, and content engagement, we can identify trends that drive audience interaction.
From the data, it is evident that short-form content (YouTube Shorts) significantly outperforms long-form videos, with shorts contributing over 94% of total views. Additionally, Microsoft Office-related tutorials (Excel and Word) and tech tips generate the most traction, making them high-potential content categories for future uploads.
This analysis aims to answer critical business questions regarding content strategy, audience preferences, and engagement optimization. Based on these insights, recommendations will be made to help maximize subscriber growth, improve video visibility, and enhance content effectiveness. The goal is to develop a data-driven content strategy that ensures sustained growth and increased audience retention on the platform. 🚀. Read more
Employee Performance Analysis
Tools: SQL, Power BI, Python, Excel
Analyzed employee performance data, designed a Tableau dashboard, and improved retention by 10%. GitHub Repository
Analyzed employee performance data, designed a Tableau dashboard, and improved retention by 10%. GitHub Repository
Page updated
Google Sites
Report abuse