Question: Identify an online database (website that is fundamentally a database or contains a database) Consider the types of data per section 1.3 that the database
- Identify an online database (website that is fundamentally a database or contains a database)
- Consider the types of data per section 1.3 that the database contains (often this addresses the WHO, WHAT, WHERE, WHEN and WHY of a database, does it with your choice?)
- What are 2-3 'interesting questions' that the database might inspire?
- Change the title of your Post to reflect the website/database you have chosen
What do you think about the response below to the questions above? What do you find interesting about it? Do you agree with it? And why?
"Uber Data Analytics Dashboard
Kaggle hosts thousands of data sets that are freely available to the public from sports data to retail sales trends in Istanbul in 2024. If we look at a specific dataset, like in "Uber Data Analytics Dashboard," we can see:
Structured Data: Trip details, vehicle types, ratings and revenue information
Unstructured Data: None, dataset is structured
Quantitative Data: Trip duration (minutes), distance traveled (miles), fare amount (USD)
Categorical Data: Trip status, vehicle type, pickup and dropoff locations
This answers the 5 Ws for us: riders and drivers using Uber platform (who), ride-sharing trips (what), various urban locations within Uber's coverage area (where), specific dates and times of trips (when), to analyze and improve ride-sharing operations (why).
This raises some interesting questions regarding this database:
1. What are the peak hours for Uber rides in urban areas? This helps drivers and riders understand the most expensive times at specific places.
2. How does trip duration relate to fare amount? Do shorter, more frequent trips or longer, less frequent trips net the driver more?
3. What factors cause higher cancellation rates driver-to-driver? Is there a trend in the quantitative and/or categorical data that affects why riders cancel trips? "
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
