System Performance & User Engagement Analysis – Power BI Dashboard

Author: Israel Josiah
Industry: Telecommunications | SaaS | Cloud Infrastructure | Business Intelligence
Technologies Used: Power BI | SQL | DAX | AWS CloudWatch | Excel

---

📌 Project Overview

This project delivers a comprehensive Power BI dashboard that provides real-time insights into system performance, VoIP quality, user engagement, and customer support efficiency. It is designed to help organizations optimize operational uptime, improve VoIP call quality, monitor user behavior, and enhance customer service resolution rates.

The analysis was developed for FroggyTalk, a VoIP startup, and structured to seamlessly integrate with real-world datasets from AWS CloudWatch, CRM logs, and VoIP call records, making it scalable for any data-driven organization.

📊 Dashboard Preview

Click to view dashboard via Power BI web Link

---

🎯 Key Features & Metrics

1️⃣ System Performance Monitoring

• Uptime % – Tracks system availability over time.
• Mean Time to Resolve (MTTR) – Measures average downtime duration.
• Mean Time Between Failures (MTBF) – Analyzes system reliability.
  📊 Visuals: Gauge Chart | KPI Cards | Line Graph

2️⃣ VoIP Quality Metrics

• Mean Opinion Score (MOS) – Evaluates user-perceived call quality.
• Round Trip Time (RTT) – Monitors network latency for VoIP calls.
• Packet Loss Rate – Measures lost data packets affecting call quality.
  📊 Visuals: Stacked Area Chart | Clustered Column Chart

3️⃣ User Engagement Analysis

• Daily Active Users (DAU) / Monthly Active Users (MAU) – Tracks user activity.
• User Growth Rate – Measures the percentage of new active users.
• Churn Rate – Analyzes retention trends and lost users.
  📊 Visuals: Line Chart | Pie Chart

4️⃣ Customer Support Performance

• First Call Resolution (FCR) – Measures support efficiency.
• Customer Satisfaction Score (CSAT) – Captures user feedback on support interactions.
  📊 Visuals: 100% Stacked Column Chart | Gauge Chart

---

🔧 Tools & Technologies Used

Technology	Purpose
Power BI	Dashboard creation & visualization
SQL	Data extraction & transformation
DAX	Advanced metric calculations
AWS CloudWatch	Real-time system monitoring
Excel	Initial data cleaning & structuring

---

🔗 How to Use This Repository

1. Clone the repository

   git clone https://github.com/IsraelVow/System-Performance-User-Engagement-Analysis.git
   cd PerformanceAnalysis

2. Review the Power BI (.pbix) file

   • Open Performance Analysis.pbix in Power BI Desktop.
   • Explore visuals and adjust filters dynamically.

3. Integrate Real-World Data

   • Replace simulated data with live data sources from AWS, CRM, and VoIP logs.
   • Adjust Power Query transformations to fit organizational datasets.

4. Enhance with Cloud & Automation

   • Set up scheduled data refreshes in Power BI Service.
   • Automate alerts using CloudWatch & Power Automate.

---

🚀 Potential Use Cases

✅ VoIP & Telecommunications – Track call quality and minimize network issues.
✅ IT & Cloud Services – Monitor system uptime, failures, and resolution trends.
✅ SaaS & Tech Startups – Analyze customer retention and churn risks.
✅ Customer Support Teams – Improve service efficiency and satisfaction rates.

---

📌 Future Enhancements

🔹 Live API Integration for real-time data streaming.
🔹 Advanced Predictive Analytics for churn modeling.
🔹 AI-Powered Insights using Power BI’s AI visuals.
🔹 Custom Alerts & Notifications for system failures.

---

📬 Contact & Collaboration

I’m open to freelance opportunities, collaborations, and consulting in Power BI, Data Analytics, and Business Intelligence.

📧 Email: [email protected]
🔗 LinkedIn: Connect on LinkedIn
📂 Portfolio: My Website

---

If this project resonates with you, feel free to ⭐ star the repository and connect with me! 🚀