1. Project Overview

• Title: Business Intelligence Business Expansion; Business Tracking Dashboard and KPI
• Objective: Increase market reach, optimize revenue, and strategically grow the business in the island area of Lagos.
• Tools Used: Power BI

2. Description

• Developed a business tracking dashboard and key performance indicator (KPI) analysis to support the company’s expansion into the island area of Lagos. Utilized Power Query and Power BI for data understanding, cleaning, modeling, analysis, and insight generation. The dataset consisted of 2 tables (Lagos-Midweek and Lagos-Weekend) containing 4 years of data, which was cleaned and appended to create a comprehensive dataset named “BEBI.” Created custom calculations and measures to drive key KPIs using DAX.

3. Key Achievements

• Improved market reach and revenue optimization strategies based on data-driven insights.
• Enhanced decision-making processes by providing a comprehensive business tracking dashboard.

4. Key Performance Indicators (KPIs) Impact

• Total Revenue: N15M
• Total Registration: 474
• Activated: 203
• Non-Activated: 271
• Average Value Order: N74.40k Conversion Rate: 43%

5. Data Analysis Insights

• Identified patterns and fluctuations in activated candidates across four years, indicating potential seasonal trends.
• Analyzed data collation progress, showing 72.36% known and 27.64% unknown locations in Lagos, highlighting progress made and areas for further data collection efforts.
• Examined total registrations and activations across different locations, revealing Mainland as the highest number of registered candidates and Eti-Osa as the highest number of activated candidates.
• Revealed diverse preferences for class types across different locations, with Mainland Lagos and the Island showing higher preference for physical classes.
• Analyzed revenue distribution across locations, with Mainland generating the highest percentage of revenue.

6. Recommendation

Based on data insights, the following strategies are proposed to enhance market reach and optimize revenue in Lagos Island:

• Implement a seasonal marketing strategy to boost activations during low periods.

• Conduct targeted data collection efforts in unknown locations.

• Optimize resource allocation based on activation trends.
  

• Scale revenue-generating strategies from the Mainland to other locations.

• Expand physical class offerings in high-demand areas.

7. Impact Analysis

The Business Tracking Dashboard and KPI analysis provided valuable insights that significantly influenced business expansion strategies.

• Improved Market Reach: Data-driven strategies enhanced visibility and customer acquisition in Lagos Island.

• Optimized Revenue: Insights into revenue distribution and activation trends enabled better resource allocation and sales strategies, contributing to ₦15M in total revenue.

• Strategic Decision-Making: The dashboard empowered stakeholders with real-time performance tracking, improving business expansion planning

These insights have positioned the company for sustainable growth and increased profitability.

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.