Project 2 - Supply and Demand Gap Analysis

Aim:-

This project aims to collect and analyze the data of Request id and drive id data and analyze it in detail by each status , Request timestamp, Drop timestamp ,Pickup point etc. on that site.

Introduction:-

The main objective of this project is to identify the root cause of the supply and demand gap of cabs to and fro airport.

Problem Statement:-

• We can find out how many drive and request id in status .
• Maximum drive id ,minimum drive id ,count ,total and how many status are there these show u in Q & A Chart.

Methodology:-

Step 1: Data cleaning

In data cleaning I cleaned the data with the transform data option present in Power BI because the dataset was not cleaned and included some missing values, so with the help of the duplicates function in Power BI, I cleaned the data and replace the null values with 0 and then started working on it.

Step 4: Data interpretation

I found some important information about the data set in this data interpretation step.

• The data set was almost clear and completed.
• I replaced the null values with 0.
• I m using all data as it is.

Step 5: Visualization

In visualization, I took the help of Power BI Desktop software to make graphs and charts here some relevant graphs and charts are attached.

Analysis (Datasheets about it):-

In observation found some interesting points that are mentioned below.

• You can see the blowing table pink color indicates the request id in light blue values indicate the drive id in line chart .
• • In pie chart you can see complete value indicates the dark blue colour and sky blue colour indicates trip completed and orange indicates no car available .
  • We create bar chart , line chart , gauge chart , Q & A charts.

  Insights:-

  • In conclusion, we can take a look at the final Dashboard for further analysis.
  • We can see status wise request id and drive id.

  Recommendations:-

  • We can collect a large dataset for analysis.
  • We can analyze the data of the request and drive id .
  • Like this dataset we can perform operations with various types of status .
  • We can work on large datasets and analyze them with the proper format of the chart.

  Conclusion:-

  In conclusion, we can take a look at the final Dashboard for further analysis.