revenue-metrics-analysis-2022
🎮 Gaming Analytics: Revenue Metrics Over Time by User Segments (2022) | SQL + Tableau Dashboard
Gaming Analytics Adventure | הרפתקת ניתוח נתוני משחקים
🏰 Project Overview
Welcome to an epic data adventure through the mystical realm of gaming revenue analytics! This comprehensive analysis transforms raw payment data into actionable business intelligence, exploring the financial journeys of 383 brave gaming warriors who contributed $63,141 to our digital kingdom throughout 2022.
Like a skilled data knight navigating treacherous dungeons of complex datasets, this project decodes the secrets hidden within player payment patterns, uncovering legendary insights about user behavior and revealing treasure troves of revenue optimization opportunities.
🎯 Mission Objectives
- Advanced SQL Mastery: Complex 3-CTE architecture with LAG/LEAD window functions
- Revenue Intelligence: Complete MRR analysis (New, Churned, Expansion, Contraction)
- Interactive Storytelling: Tableau dashboard with 6 compelling visualizations
- Demographic Insights: Age-based user segmentation and behavior analysis
- Business Strategy: Actionable recommendations for growth and retention
📊 Key Discoveries
Our data expedition uncovered remarkable insights from the gaming realm:
- 383 Gaming Warriors contributed to our kingdom’s treasury
- $63,141 Total Revenue generated throughout the epic 2022 journey
- $165 Average ARPPU (Average Revenue Per Paying User)
- $14,186 New MRR from brave new heroes joining our realm
- $144.72 Customer Lifetime Value showing the true worth of each warrior
🗡️ Revenue Battle Metrics
The analysis reveals four sacred revenue pillars:
- New MRR: Fresh heroes joining our kingdom ($14,186 discovered)
- Churned Revenue: Warriors departing our realm (seasonal patterns revealed)
- Expansion Revenue: Heroes growing stronger (summer months peak)
- Contraction Revenue: Strategic power adjustments (winter patterns)
🧙♂️ Technical Sorcery
SQL Enchantments Used:
- Complex Common Table Expressions (CTEs) for data transformation
- LAG/LEAD window functions for time-travel analytics
- Date manipulation for monthly revenue aggregation
- Advanced CASE statements for revenue categorization
Visualization Spells:
- Monthly revenue trend analysis
- Revenue waterfall breakdown
- User churn rate patterns
- ARPPU behavior tracking
- Customer lifetime value insights
🏆 Business Impact & Strategic Insights
- Peak Acquisition Discovery: August emerged as the golden month with 50 new warriors
- Seasonal Patterns: Identified 100% churn spike in December requiring retention strategies
- Revenue Growth: Spectacular journey from $1,491 (March) to $9,344 (October)
- Demographic Intelligence: Age-based segments showing distinct monetization patterns
🛠 Technologies Wielded
- PostgreSQL: Advanced SQL with window functions and CTEs
- Tableau Public: Interactive dashboard creation and data storytelling
- HTML5/CSS3: Responsive web development for project presentation
- GitHub Pages: Professional project deployment and hosting
🤝 Acknowledgments
Special thanks to our wise mentors and guides in this data adventure:
- GOIT School for providing the mystical knowledge and powerful tools needed for this epic quest
- Nataliia Muzhytska Thank you very much for the knowledge and patience to my teacher on data analysis
- Oleh Maiboros for your wisdom and mentorship throughout this analytical adventure
🚀 Connect with the Data Knight
- LinkedIn: Artur (Sim) Pais
- Email: [isaart102@gmail.com]
- GitHub: Artisa111
⚔️ “In data we trust, in insights we conquer, in analytics we prosper!”
- Artur, Data Knight of the Gaming Realm 🧙♂️