Skip to content
Ugly tables / pizza hackathon
  • AI Chat
  • Code
  • Report
  • Workspace Hackathon - Create a pizza sales dashboard!

    Introduction

    You just started an internship as a data analyst for a long-running pizza delivery service that operates in all of San Francisco. Your manager has assigned you your first project: developing a prototype dashboard that provides an overview of the business.

    Data

    Their recent data is a mess, so they have provided you with cleaner data from a few years ago. This data is distributed across four tables, three of which are joined together in the SQL cell below. For more information about the columns in each table, you can consult the data_dictionary.ipynb file in the data folder.

    Submission requirements

    The structure of the dashboard is up to you. You can opt for a series of plots, one large set of subplots, or any other format that you consider appropriate. Regardless of your choice, you will be required to provide an overview of the following:

    • Sales over different time periods (e.g., week, quarter, month).
    • Popular products and order sizes.
    • Peak hours for orders.

    Your manager has also encouraged you to include any other metrics that you feel would be helpful for them to monitor and grow their business.

    Some cell

    # Some code
    Unknown integration
    Data frameavailable as
    df
    variable
    -- Join together order, order details, and pizza details data
    SELECT 
    	*
    FROM 'data/orders.csv'
    LEFT JOIN 'data/order_details.csv' USING(order_id)
    LEFT JOIN 'data/pizzas.csv' USING(pizza_id)
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    Unknown integration
    Data frameavailable as
    df1
    variable
    -- SeQueL
    SELECT * FROM 'df'
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    df