Preregistration background
Back
Roni's Challenge: Dashboard Building for Business Insights

Roni's Challenge Data

Link to data here

Challenge Overview

In this challenge, participants will design and develop a data-driven dashboard to help Roni's Mac Bar, a local Texas business with a location in College Station, gain valuable insights into their operations. The goal is to create a user-friendly, business-facing dashboard that provides actionable insights into customer preferences, order efficiency, and overall business performance.

Data Description

You have been provided with the following dataset:
  • A detailed log of every order made at the College Station location during the months of May to October

Challenge Objectives

Participants will:
  1. Analyze the Data: Explore the provided datasets to extract meaningful patterns, trends, and correlations.
  2. Develop a Dashboard: Build an intuitive and interactive dashboard that displays key insights. The dashboard should aim to improve Roni's understanding of their business operations.
  3. Provide Insights: Use the dashboard to potentially answer questions such as:
    • What are the most popular menu items?
      • Signature “Aggie” Bowl based on popularity
    • Are there any seasonal (days of week, month) trends or peaks in demand?
    • How can Roni's optimize meal preparation based on efficiency logs?
    • Are there any bottlenecks or delays in the meal preparation process?
  4. Optional Enhancements: Enhance the dashboard by integrating forecasting models, trend analyses, or other advanced analytics to support decision-making.

Requirements

  • Programming Language: Participants are free to use any programming language or tool of their choice (e.g., Python, JavaScript, Power BI, Tableau). No-code and low-code solutions are also welcome for beginners.
  • Data Visualization: Use appropriate charts, graphs, and tables to present insights clearly and effectively.
  • Dashboard Features:
    • An overview of key metrics such as total sales, popular items, and efficiency scores.
    • A section for deep-diving into customer preferences and order trends.
    • A section analyzing meal preparation times, highlighting areas for improvement.

Inputs and Outputs

  • Inputs: Three datasets (Sheet A, Sheet B, and Sheet C).
  • Outputs: An interactive, business-facing dashboard that helps Roni's Mac Bar gain insights into customer behavior and operational efficiency.

Evaluation Criteria

The dashboards will be evaluated by a judging panel based on the following criteria:
  • Data Insights: The depth and accuracy of the insights presented from the data.
  • Usability: How intuitive and user-friendly the dashboard is for business users.
  • Design and Visual AppealAesthetics and the clarity of data presentation.
  • Innovation: Creativity in the approach, such as incorporating predictive analytics or optimization suggestions.
  • Technical Execution: Was the data correctly cleaned and processed?

Resources

Participants can use the following resources:
  • Data Visualization Libraries: Tools such as Matplotlib, Seaborn, Plotly, or D3.js for coding solutions.
  • Dashboarding Tools: Power BI, Tableau, or Google Data Studio for low-code and no-code dashboards.
  • Machine Learning/Analytics:Optional use of tools like scikit-learn, statsmodels, or Prophet for forecasting and trend analysis.

Submission Guidelines

Participants should submit:
  • Source code (if applicable) in a zipped folder or a GitHub repository.
  • Dashboard files if created in a tool like Power BI or Tableau.
  • A README explaining the dashboard functionality and setup instructions (if any).
  • A brief report (1-2 minute) video explaining functionality.

Prizes!!!

1st place: Logitech Mouse

Challenge Prize

2nd place: Anker Speaker

Challenge Prize
Get Data