Have a question?
Message sent Close

EventPro – Budget Optimisation Dashboard

Company Name: EventPro


Project Objective:

EventPro is currently facing challenges in managing budgets across multiple events, leading to inefficiencies in expense tracking and overspending in critical areas. The lack of a centralised system to monitor spending and analyse budget utilisation results in limited financial visibility for event managers. To address these issues, the project aims to create a comprehensive budget management dashboard that tracks spending, identifies optimisation opportunities, and provides real-time visual insights for decision-making.


Requirement:

Design a system that:

  1. Tracks Budget Allocation:
    • Monitor expenses across key categories such as venue, catering, marketing, and more.
    • Provide an up-to-date view of total spending and remaining budgets.
  2. Optimises Budget Usage:
    • Highlight areas of overspending or under-utilisation of allocated funds.
    • Recommend reallocation strategies to optimise budget usage.
  3. Provides Visual Insights:
    • Develop interactive dashboards that display budget utilisation and cost breakdowns.
    • Include features to compare planned versus actual spending.

Detailed Features:

  • App Features:
    1. Expense Tracker:
      • Input fields for event-specific expense categories.
      • Automated calculations for total spending and remaining budgets.
    2. Optimisation Insights:
      • Automated alerts for overspending.
      • Recommendations for reallocating funds.
    3. Visualisation Dashboard:
      • Interactive pie charts and bar graphs to analyse expenses by category.
      • Trend lines to track spending over time.
      • Comparison charts for planned versus actual budget.

Deliverables:

  • Phase 1 – Design and Mockups:
    • Wireframes for the budget tracking dashboard and expense optimisation tools.
    • Sample data sets for testing and refining features.
  • Phase 2 – Prototype:
    • Excel-based dashboard to track budgets and visualise expenses.
    • Functional analytics and optimisation recommendations.

Technology Suggestion:

  • Excel: For budget tracking and development of initial dashboard features.
  • Power BI: For creating interactive and dynamic visualisations.

Expected Output:

  • Phase 1: Wireframes, sample data insights, and detailed feature documentation.
  • Phase 2: Fully functional budget tracking dashboard with optimisation tools and visualisation features.

 

Category: Analytics
Technology: Excel Figma Power BI

Enroll in this project

If you are interested in this project, please fill out enrolment form that includes your team name and team member names

Allowed Type(s): .pdf, .doc, .docx

Institution Details

Team Details

Enter your team details

Content is Protected.