Ride Sharing Case Study Through SQL

Study patterns in the ride-share business, measure Ride time statistics, analyze top routes, & catch false rides on the platform

Learn the following SQL Concepts:

• How to get N rows of data in SQL
• How to use Aggregate Functions in SQL
  • Count, Count Distinct, Sum, Maximum, Minimum etc.
• How to Group data and aggregate in SQL
• How to convert an aggregate column to percentage in SQL
• How to round a column to N decimal places in SQL
• How to concatenate columns and strings in SQL
• How to define and find outliers in SQL
• How to use Statistical Functions in SQL
  • How to find the mean of a column in SQL
  • How to find the median of a column in SQL
  • How to find the Nth percentile of a column in SQL
  • How to find the Inter-Quartile range of a column in SQL
    
• How to use and write a subquery in SQL
  • How to use a subquery as a table in SQL
• What are Common Table Expressions (CTE) in SQL
  • How to create a Common Table Expression (CTE) and use it in SQL
• How to use Date Functions in SQL
  • How to extract a part of date from a column in SQL
  • How to extract Year, Month, Date from a column in SQL
• How to find difference of time columns in SQL

Learn the following Concepts about Clickstream Analytics:

• Understand the various ride sharing metrics
• How to analyze total rides that happen on a platform
• How to find contribution of rides by vehicle type on the platform
• How to find contribution of rides by different kind of members on the platform
• How to analyze the top N routes on the platform by the number of rides
• How to find out the ride time for each ride on the platform
• How to find out false rides on the platform
• How to remove outliers and calculate average ride time on the platform
• How to perform statistical analysis of ride times on the platform
  • Find Mean, Median, Inter-Quartile range etc. for ride times on the platform
• How to analyze the daily/weekly rides on the platform