Project 2 - Supply and Demand Gap Analysis
11/29/2023
|
USING POWER BI | SELVA |
AIM:
The Aim Of This Project Is To Fulfill The Gap Between The Demand And Supply In The UBER Cabs By Using The Data Which Is Provided By The KAGGLE.
INTRODUCTION:
Uber Provides The 2016 Data. By Using This Data Find Out The Demand And Supply Analysis Gap Of The Cab.
The Main Objective Of This Project Is To Analyze The Data On, Uber Request Data. Through The Analysis Of Data, We Can Find Some Important Insights.
PROBLEM STATEMENT:
In This Project, We Can Find Out How Many Pickup Point Are Placed In The Each Pickup Point, How Many Trips Are Completed, How Many Trips Are Cancelled And How Many Trips Are Cancelled Due To Cars Are Not Available, How Many Drivers Are There.,
METHODOLOGY;
v In Uber, The Request Data Set The First Column Is Request Id In This Column The Request-Id Is Present The Placed By The Customer.
v In The Second Column, The Pickup Point Is Present In This Data Only Two Airport And City Pickup Point Is Present.
v The Next Column Is Driver Id In This Column So Many Drivers Are Present Each Driver Assigns A Separate Driver ID.
v Another Column Is Status In This Status Column Three Statuses Are Present Completed, Cancelled And No Car Available.
v The Last Two Columns Are The Request Timestamp And Drop Timestamp In This Column The Request Time And Drop Time Are Present,
v The First Step Is Cleaning The Data. 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.
v After Data Cleaning Performs The Data Interpretation Step. In Data Interpretation Found Some Important Information.
v The Data Set Was Almost Clean And Completed.
v Replace The Null Values With 0.
v There Are A Total of 6746 Rows and 6 Columns Are Present.
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.
COUTN OF PICKUP POINT:
In The Table Chart We Can Find Out The Count Of Pickup Point In Airport And City.
COUNT OF TRIP STATUS:
In The Clustered Column Chart, We Can Find Out The Number Of Trips Completed, Cancelled And No Cars Available Status.
COUNT OF DRIVER ID:
In This Visual We Can Find Out The Count Of The Driver Id And The Number Of Driver Id Is Not Avilable In Each Pickup Point.
ANALYSIS:
From The Above Visualization Find Some Interesting Points That Are Mentioned Below:
v In The Table Chart, Almost 1327 Trips Are Completed For Airport And 1504 Trips Are Completed For City.
v For A Total Of 1713 Trips, There Is No Car Available For Airport Trips And 937 Trips With No Car Available For City Trips.
v A Total Of 198 Trips Are Cancelled For Airport And 1066 Trips Are Cancelled For City Trips.
v The Total Of 301 Drivers Is Available In 2016.
v 297 Drivers Have Completed the Airport Trip and 299 Drivers Are Completed the City Trip.
v The Total Of 145 Drivers Cancelled The Airport Trips And 291 Drivers Cancelled The City Trips.
INSIGHTS:
In Conclusion, We Can Take A Look At The Final Dashboard For Further Analysis.
We Analyzed The Data According To The Request ID.
RECOMMENDATION:
v We Can Analyze The Data Of The Overall Trips In The City.
v Like This Dataset, We Can Analyze The Data According To The Different Cities-Area It Takes More Clarity To How To Fill The Supply And Demand Gap.
v We Can Analyze The Data With The Proper Format
v We Can Collect Good Datasets For More Effective Analysis By Using Charts.
CONCLUSION:
In Conclusion, We Can Take Look At The Dashboard For Further Analysis.
v According To Analysis, Almost 1713 Trips Are Cancelled For Airport Trips. In Airports, Trips Need To Increase The Drivers That Help To Increase The Business.
v The Second Points Are That Almost 1066 Trips Are Cancelled By The Customer In The City Area And Need To Improve Some Features.