Day 26: CRM Business Performance | Zoho Analytics + SQL + Excel | CRM Churn & Revenue Insights

Channel:

Tech With Nicks

Subscribers:

10,900

Published on July 4, 2025 7:41:34 PM ● Video Link: https://www.youtube.com/watch?v=RTjqasBJWus

Duration: 0:00

104 views

0

Day 26: RM Business Performance Dashboard | Zoho Analytics + SQL + Excel | CRM Churn & Revenue Insights
Welcome to Day 26 of my 30-Day Data Analyst Challenge!
Today, I created a complete CRM Performance Dashboard using Zoho Analytics, PostgreSQL, and Excel — analyzing real-world CRM metrics to drive retention and performance improvement 📈

📊 Project Title:
RM Business Performance Dashboard (Zoho + PostgreSQL)

📂 Tools Used:
📘 Excel (raw data cleanup)

🐘 PostgreSQL (data storage, joins, SQL queries)

📊 Zoho Analytics (interactive dashboard + storytelling)

💡 Business KPIs Analyzed:
Churn % per month

Customer drop-off trend

Feature adoption by region

Revenue by country

Product usage segmentation

Identified 13.74% customer loss (June 2025), 73.6% churn spike in May

Proposed actionable retention strategies for CRM optimization

🎓 Built to simulate real CRM scenarios for business analyst portfolio
📅 #Day26 of #30DayDataChallenge
📺 Channel: Tech With Nicks
🔒 All data is fictional and for educational purposes only

🏷️ Tags (Copy-Paste Format):
txt
Copy
Edit
#Day26 #ZohoAnalytics #BusinessDashboard #CRMAnalysis #SQLProject #DataAnalytics