1. Project Overview

• Title: Power BI Real-Time Visibility Dasboard
• Objective: To establish a Business Intelligence (BI) unit at PQPlus to enhance data analysis capabilities, improve strategic decision-making, and boost overall company success.

2. Description

• Conducted end-to-end data analysis process including data understanding, data cleaning, data modeling, analysis, and insight generation. Integrated and cleaned data from four tables (Abuja-Midweek, Abuja-Weekend, Lagos-Midweek, Lagos-Weekend) to create a comprehensive dataset named “Global”. Addressed challenges faced in achieving key performance indicators (KPIs) and converting visibility into successful outcomes.
• Aim: The aim is to establish a Business Intelligence (BI) unit at PQPlus to enhance data analysis capabilities, improve strategic decision-making, and boost overall company success.

3. Key Achivement

• Improved KPI success rate from 50% to 80%.
• Increased revenue by optimizing sales and marketing efforts.
• Enhanced customer acquisition and retention through data-driven strategies.

4. Key Performance Indicators (KPIs) Impact

• Total Revenue: N42.5M
• Total Registration: 989
• Activated: 457
• Non-Activation: 532
• Average Value Order: N93.1k
• Conversion Rate: 46%

5. Revenue Distribution Analysis

• Identified trends in revenue distribution over 4 years (2021-2024), with 2023 contributing 75.41% of total revenue.

6. User Behavior Analysis

• Analyzed registration and activation trends by month and identified actionable insights for stakeholders.

7. Recommendations

• Proposed strategies for improving KPI success rate, enhancing visibility conversion, and optimizing revenue generation. Which are;

• To enhance user experience, streamline the registration process by simplifying steps and allowing social media logins, while ensuring mobile-friendliness. Conduct user journey mapping to identify pain points for smoother transitions.

• Improving customer support is essential; introduce live chat for immediate assistance, create a comprehensive FAQ for self-service, and host webinars to address common concerns.

• For user retention, implement loyalty programs, schedule periodic check-ins for feedback, and use automated reminders for upcoming sessions.

• Implementing these strategies will improve KPI success rates, increase user conversion, and optimize revenue generation, with regular assessment to ensure ongoing effectiveness and adaptability to market changes.

8. Impact Analysis

The analysis of the real-time visibility dashboards has provided valuable insights for stakeholders, enabling informed decision-making in key areas:

• KPI Assessment: With 989 total registrations and a 46% activation rate, there is a clear opportunity to enhance user onboarding strategies.

• Revenue Insights: Tracking total revenue of ₦42.5 million allows for identification of revenue drivers and optimization opportunities.

• User Engagement: The gap between registered and activated users highlights the need for targeted engagement initiatives to boost conversion rates.

• Training Preferences: Analyzing the division between virtual and physical training registrations aids in tailoring programs to user preferences.

• Trend Analysis: Yearly and monthly trends provide insights into user behavior, facilitating strategic planning and resource allocation.

Overall, these insights position stakeholders to improve performance metrics, drive revenue growth, and enhance customer satisfaction.

Interactive Dashboard: Below, you can explore the interactive Power BI dashboard to test the full functionality and experience the KPIs, filters, and visualizations in real time.