1. Project Overview

• Title: Real-Time Visibility SGT – Swipht Green
• Objective
  • The primary objective of this project was to provide Swipht Green with a real-time, data-driven platform to effectively track and analyze key business and training metrics. The dashboard enables stakeholders to make informed decisions, optimize marketing strategies, enhance training program effectiveness, and streamline operations.
• Goals
  • Develop a Training Platform: A user-friendly system for courses in solar system design, energy audits, and project management.
  • Real-Time Visibility: Enable Swipht Green to track training program metrics, including enrollment, course progress, and candidate performance.
  • Data Integration: Seamlessly integrate candidate and performance data using ETL processes for better insights.
  • KPI Dashboards: Provide visual representations of key metrics to identify areas for improvement.

2. Project Description

This project involved developing a real-time business tracking dashboard to analyze revenue trends, enrollment performance, and location-based insights. Using Power BI and Power Query, the data was cleaned, modeled, and visualized to generate actionable insights for Swipht Green’s decision-makers.

3. Dashboard Features

• Revenue Tracking: Insights into yearly, monthly, and package-based revenue trends, with key contributions from managers like Enoch, Ifeoma, and Kunle..
• Registration & Activation Metrics: Track touchpoints such as Instagram, referrals, and online ads, alongside package-specific performance (e.g., Pro Max and Promo packages).
• Location Analysis: Revenue performance across top locations like Ikorodu, Ajah, Maryland, and Ebutte Meta.
• Conversion Rates: Monitor activation trends (e.g., 60% in March, 42% in September).

4. Implementation Highlights

• Automated Data Integration: Developed an ETL process to ensure seamless updates and accuracy across data sources.
• KPI Dashboards: Used Power BI to create dynamic visualizations for key metrics like conversion rates, package performance, and revenue trends.
• Error Handling: Resolved data inconsistencies and column mapping issues to ensure data integrity during refresh cycles.
• Training Platform: Designed a multi-course structure with progress tracking, certification issuance, and collaboration tools to enhance the learning experience.

5. Recommendations

To further enhance the impact of this project, the following recommendations were made:

• Optimize Marketing Efforts: Focus on high-performing touchpoints like Instagram and referrals, reallocating budgets to maximize conversions.
• Expand Training Offerings: Introduce advanced courses such as system maintenance and energy efficiency best practices to attract a broader audience.
• Improve Conversion Rates: Implement targeted campaigns for packages with lower activation rates, such as Promo 35k, to boost overall performance
• Leverage Location Insights: Focus marketing and sales efforts on top-performing areas like Ikorodu and Ajah, while addressing challenges in underperforming regions
• Monitor Trends Continuously: Use real-time dashboards to assess revenue, registrations, and activations, enabling timely corrective actions.
• Enhance Manager Contributions: Provide training and incentives to managers like Kunle to boost registration and activation rates.

6. Analysis Impact

• Empowered Decision-Making: The dashboards provided actionable insights, enabling Swipht Green to monitor both training programs and business performance effectively.
• Improved Data-Driven Strategies: Real-time insights allowed Swipht Green to make data-driven decisions, optimizing marketing efforts and improving resource allocation.
• Streamlined Operations: Automated ETL processes and dynamic dashboards eliminated bottlenecks in data management and reporting, improving operational efficiency.
• Enhanced Program Effectiveness: By monitoring key metrics and trends in real time, Swipht Green could adjust strategies promptly and boost performance across various areas of their operations.

7. Key Metrics

• Total Revenue: ₦965K for the latest reporting period.
• Activation Rate: 26.09% across programs.
• Top Performing Locations: Ikorodu and Ajah leading revenue contributions.
• Manager Contributions: Enoch and Ifeoma significantly contributing to overall registrations and activations.

8. Conclusion

• This project significantly improved Swipht Green’s ability to analyze and optimize their training program and business operations in real time. The dynamic dashboards provided the company with key performance insights, allowing them to focus on growth strategies, enhance marketing efforts, and achieve a greater impact within the renewable energy sector.

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.