Project Overview

45%

The goal of this project is to demonstrate my skills in database design, while teaching myself to simulate data. For this project I'll design a database for my delivery app, create synthetic data with a python script, run analysis on top of it using streamlit, and answer hard questions about the business model.

I'd like to also relate it to the real world by researching actual delivery apps, their pricing models, and make an educated guess on the simulation parameters I'd need to compare them.

Objectives

Design a delivery app database, simulate realistic data, and analyze business models to answer key questions.

Design

SQL

  • Local instance of SQL (probably SQLite, or other free option)
  • Will need data structure and database design
  • Ensure normalization

Order Simulation Script

  • Simulate different kinds of surges
  • Introduce randomness

Driver Simulation Script

  • Delivery driver availability

Data & Analysis

Data

  • Python script to generate synthetic data elements
  • order_id, customer_id, restaurant_id, order_time, delivery_distance, cost, delivery_fee, tip, surge_mult, final_price, delivery_type, etc.

Visualization

  • Streamlit
  • Distributions, charts

Analysis

  • Answer hard questions: expensive times, express cost vs time to deliver, surge pricing effect on consumer and business, impact of different values in simulated data

Conclusion

Results

TBD

Challenges

TBD

Future Work

TBD.

References

TBD

GitHub View on GitHub