BUSINESS EXPANSION / BUSINESS INTELLIGENCE (BEBI): Dashboard for Tracking Progress and KPIs on Business Profitability and Expansion by Ifeyinwa Ezeanokwasa

Through a wide variety of mobile applications, we’ve developed a unique visual system.

  • Client PQPLUS
  • Date April 2024
  • Services Developed a Progress Tracking Dashboard displaying key performance indicators (KPIs) related to business profitability and expansion.
VIEW PROJECT

BUSINESS EXPANSION/BUSINESS INTELLIGENCE (BEBI)

Apr 2024 – May 2024

 
Associated with PQP Marketing Consult

    • Features:

      Dashboard:

      An easy-to-understand dashboard that provides real-time insights into candidate registrations, revenue generation, and the data collation process in a user-friendly format.
      Technologies Used:

      Power BI (ETL and Power Query) for data cleaning and transformation.
      Observations:

      1. Higher revenue generation observed.
      2. Improved efficiency in tracking candidate registrations and payments.
      3. Informed decision-making enabled by accurate data insights.
      4. Targeted expansion strategy for optimal market penetration of the Island part of Lagos using the Pro Bar on the dashboard.

      Design Thinking:

      During the project building phase, the following were considered:

      1. Tracking candidate registrations, payments, and their locations (Island or Mainland).
      2. Developing a progress chart indicating data collation advancement.
      3. Displaying registration distribution between the Mainland and the Island.
      4. Comparing revenue from the Island area of Lagos with the Mainland.

      Components of the Dashboard/Report:

      1. Progress Bar
      2. Conversion Rate Bar
      3. Candidate Locations
      4. Daily, Monthly, and Yearly Revenue
      5. Location Category
      6. Total Activations by Year