Data analyst starter kit:
- Become an expert at SQL and data wrangling.
- Learn to help others understand data through visualisations.
- Seek to answer specific questions and provide clarity.
- Remember, everything ends up in Excel.
- Become an expert at SQL and data wrangling.
- Learn to help others understand data through visualisations.
- Seek to answer specific questions and provide clarity.
- Remember, everything ends up in Excel.
β€13π8
The Salary Expectation Question: How to Make It a Win-Win!
πInterviewer: What are your salary expectations for this role?
πInterviewee: I'm looking for a competitive package that reflects my experience and the value I bring to the team. I did some research and found that the industry standard for this role ranges from Rs.X to Rs.Y.
πInterviewer: We appreciate your research. Can you share more about what you prioritize in a compensation package?
πInterviewee: While salary is important, I also value health benefits, opportunities for professional development, and work-life balance. I'm looking for a role where I can grow and contribute to the company's success.
πInterviewer: It's great to hear you're looking at the bigger picture. We'll take this into account as we move forward. Any flexibility on the range?
πInterviewee: Yes, I'm open to discussing the details and finding a package that works for both of us.
Itβs okay to state your expectations confidently and be open to negotiation!
πInterviewer: What are your salary expectations for this role?
πInterviewee: I'm looking for a competitive package that reflects my experience and the value I bring to the team. I did some research and found that the industry standard for this role ranges from Rs.X to Rs.Y.
πInterviewer: We appreciate your research. Can you share more about what you prioritize in a compensation package?
πInterviewee: While salary is important, I also value health benefits, opportunities for professional development, and work-life balance. I'm looking for a role where I can grow and contribute to the company's success.
πInterviewer: It's great to hear you're looking at the bigger picture. We'll take this into account as we move forward. Any flexibility on the range?
πInterviewee: Yes, I'm open to discussing the details and finding a package that works for both of us.
Itβs okay to state your expectations confidently and be open to negotiation!
π16π₯2β€1
Many people reached out to me saying telegram may get banned in their countries. So I've decided to create WhatsApp channels based on your interests ππ
Free Courses with Certificate: https://whatsapp.com/channel/0029Vamhzk5JENy1Zg9KmO2g
Data Analysts: https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02
MS Excel: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i
Jobs & Internship Opportunities:
https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
Web Development: https://whatsapp.com/channel/0029VaiSdWu4NVis9yNEE72z
Python Free Books & Projects: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L
Java Resources: https://whatsapp.com/channel/0029VamdH5mHAdNMHMSBwg1s
Coding Interviews: https://whatsapp.com/channel/0029VammZijATRSlLxywEC3X
SQL: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v
Power BI: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c
Programming Free Resources: https://whatsapp.com/channel/0029VahiFZQ4o7qN54LTzB17
Data Science Projects: https://whatsapp.com/channel/0029Va4QUHa6rsQjhITHK82y
Learn Data Science & Machine Learning: https://whatsapp.com/channel/0029Va8v3eo1NCrQfGMseL2D
Donβt worry Guys your contact number will stay hidden!
ENJOY LEARNING ππ
Free Courses with Certificate: https://whatsapp.com/channel/0029Vamhzk5JENy1Zg9KmO2g
Data Analysts: https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02
MS Excel: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i
Jobs & Internship Opportunities:
https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
Web Development: https://whatsapp.com/channel/0029VaiSdWu4NVis9yNEE72z
Python Free Books & Projects: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L
Java Resources: https://whatsapp.com/channel/0029VamdH5mHAdNMHMSBwg1s
Coding Interviews: https://whatsapp.com/channel/0029VammZijATRSlLxywEC3X
SQL: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v
Power BI: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c
Programming Free Resources: https://whatsapp.com/channel/0029VahiFZQ4o7qN54LTzB17
Data Science Projects: https://whatsapp.com/channel/0029Va4QUHa6rsQjhITHK82y
Learn Data Science & Machine Learning: https://whatsapp.com/channel/0029Va8v3eo1NCrQfGMseL2D
Donβt worry Guys your contact number will stay hidden!
ENJOY LEARNING ππ
π9β€8π«‘5π1
Template to ask for referrals
(For freshers)
ππ
(For freshers)
ππ
Hi [Name],
I hope this message finds you well.
My name is [Your Name], and I recently graduated with a degree in [Your Degree] from [Your University]. I am passionate about data analytics and have developed a strong foundation through my coursework and practical projects.
I am currently seeking opportunities to start my career as a Data Analyst and came across the exciting roles at [Company Name].
I am reaching out to you because I admire your professional journey and expertise in the field of data analytics. Your role at [Company Name] is particularly inspiring, and I am very interested in contributing to such an innovative and dynamic team.
I am confident that my skills and enthusiasm would make me a valuable addition to this role [Job ID / Link]. If possible, I would be incredibly grateful for your referral or any advice you could offer on how to best position myself for this opportunity.
Thank you very much for considering my request. I understand how busy you must be and truly appreciate any assistance you can provide.
Best regards,
[Your Full Name]
[Your Email Address]π19β€2
American Express is hiring!
Position: Business Analytics
Qualification: Bachelorβs Degree
Salary: 7 - 10 LPA (Expected)
Experiencο»Ώe: 0 - 3 (Years)
Location: Work From Home/ Office
πApply Now: https://aexp.eightfold.ai/careers/job/24638280?domain=aexp.com&utm_source=linkedin
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
Position: Business Analytics
Qualification: Bachelorβs Degree
Salary: 7 - 10 LPA (Expected)
Experiencο»Ώe: 0 - 3 (Years)
Location: Work From Home/ Office
πApply Now: https://aexp.eightfold.ai/careers/job/24638280?domain=aexp.com&utm_source=linkedin
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
π9β€1
Fractal is hiring for Data Engineer (AWS + Python Developer)
Experience: 0 - 3 years
Expected Salary: 10-16 LPA
Apply here:
https://fractal.wd1.myworkdayjobs.com/Careers/job/Bengaluru/Data-Engineer--AWS---Python-Developer-_SR-26409
Experience: 0 - 3 years
Expected Salary: 10-16 LPA
Apply here:
https://fractal.wd1.myworkdayjobs.com/Careers/job/Bengaluru/Data-Engineer--AWS---Python-Developer-_SR-26409
Data cleaning is the first step in the journey to discover the truth hidden in your data.
Data cleaning in some points :
πRemove Duplicate Data: Use tools to eliminate repeated entries that can skew analysis.
πHandle Missing Values: Replace, remove, or interpolate missing data points to ensure completeness.
πCorrect Data Types: Ensure all data is in the correct format (e.g., dates as datetime objects) for accurate processing.
πStandardize Data: Convert data into a consistent format, such as standardizing text cases or units of measurement.
πFilter Outliers: Identify and address extreme values that may distort analysis.
πNormalize Data: Scale numerical data to ensure features contribute equally in models.
πRemove Irrelevant Data: Drop columns or rows that do not contribute to the analysis or modeling goals.
πValidate Data Integrity: Check for inconsistencies or errors, such as typos or incorrect data entries.
πDocument Cleaning Steps: Keep a record of all changes made during cleaning for transparency and reproducibility.
Below most used tools :
βοΈPandas (Python): A powerful data manipulation library for handling missing data, duplicates, and more in Python.
βοΈOpenRefine: A free, open-source tool for cleaning messy data, particularly useful for transforming and reconciling datasets.
βοΈExcel/Google Sheets: Widely used for basic data cleaning tasks like removing duplicates, filtering, and standardizing data.
βοΈSQL: Useful for querying databases, handling missing data, filtering out outliers, and data type conversions.
βοΈR: With packages like dplyr and tidyr, R is excellent for cleaning, transforming, and managing data.
βοΈTableau Prep: A tool designed for visual data cleaning and preparation, ideal for those who prefer a graphical interface.
βοΈAlteryx: A data analytics platform that provides tools for blending and cleaning data without needing to write code.
βοΈTrifacta: A data wrangling tool that offers intuitive interfaces for cleaning and preparing data at scale.
βοΈTalend: A data integration tool that includes robust features for data quality, cleansing, and transformation.
Data cleaning in some points :
πRemove Duplicate Data: Use tools to eliminate repeated entries that can skew analysis.
πHandle Missing Values: Replace, remove, or interpolate missing data points to ensure completeness.
πCorrect Data Types: Ensure all data is in the correct format (e.g., dates as datetime objects) for accurate processing.
πStandardize Data: Convert data into a consistent format, such as standardizing text cases or units of measurement.
πFilter Outliers: Identify and address extreme values that may distort analysis.
πNormalize Data: Scale numerical data to ensure features contribute equally in models.
πRemove Irrelevant Data: Drop columns or rows that do not contribute to the analysis or modeling goals.
πValidate Data Integrity: Check for inconsistencies or errors, such as typos or incorrect data entries.
πDocument Cleaning Steps: Keep a record of all changes made during cleaning for transparency and reproducibility.
Below most used tools :
βοΈPandas (Python): A powerful data manipulation library for handling missing data, duplicates, and more in Python.
βοΈOpenRefine: A free, open-source tool for cleaning messy data, particularly useful for transforming and reconciling datasets.
βοΈExcel/Google Sheets: Widely used for basic data cleaning tasks like removing duplicates, filtering, and standardizing data.
βοΈSQL: Useful for querying databases, handling missing data, filtering out outliers, and data type conversions.
βοΈR: With packages like dplyr and tidyr, R is excellent for cleaning, transforming, and managing data.
βοΈTableau Prep: A tool designed for visual data cleaning and preparation, ideal for those who prefer a graphical interface.
βοΈAlteryx: A data analytics platform that provides tools for blending and cleaning data without needing to write code.
βοΈTrifacta: A data wrangling tool that offers intuitive interfaces for cleaning and preparing data at scale.
βοΈTalend: A data integration tool that includes robust features for data quality, cleansing, and transformation.
π17β€2
Liven is hiring for Junior Data Engineer (Remote)
Experience: 0 - 1 years
Apply here: https://ats.rippling.com/liven/jobs/65a9816d-7b41-4a1a-ad7c-0226766276e1?jobSite=LinkedIn
Experience: 0 - 1 years
Apply here: https://ats.rippling.com/liven/jobs/65a9816d-7b41-4a1a-ad7c-0226766276e1?jobSite=LinkedIn
β€1π1
Goldman Sachs is hiring!
Position: Internal Audit Analyst - Data Analytics
Qualification: Bachelorβs Degree
Salary: 6 - 10 LPA (Expected)
Location: Hyderabad; Bengaluru, India
πApply Now: https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/134698?mode=job&iis=LinkedIn&utm_medium=jobshare
https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/133519?mode=job&iis=LinkedIn&utm_medium=jobshare
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
Position: Internal Audit Analyst - Data Analytics
Qualification: Bachelorβs Degree
Salary: 6 - 10 LPA (Expected)
Location: Hyderabad; Bengaluru, India
πApply Now: https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/134698?mode=job&iis=LinkedIn&utm_medium=jobshare
https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/133519?mode=job&iis=LinkedIn&utm_medium=jobshare
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
π7β€4
Data analytics is not about the the tools you master but about the people you influence.
I see many debates around the best tools such as:
- Excel vs SQL
- Python vs R
- Tableau vs PowerBI
- ChatGPT vs no ChatGPT
The truth is that business doesn't care about how you come up with your insights.
All business cares about is:
- the story line
- how well they can understand it
- your communication style
- the overall feeling after a presentation
These make the difference in being perceived as a great data analyst...
not the tools you may or may not master π
I see many debates around the best tools such as:
- Excel vs SQL
- Python vs R
- Tableau vs PowerBI
- ChatGPT vs no ChatGPT
The truth is that business doesn't care about how you come up with your insights.
All business cares about is:
- the story line
- how well they can understand it
- your communication style
- the overall feeling after a presentation
These make the difference in being perceived as a great data analyst...
not the tools you may or may not master π
π28π1
Data Analyst Openings
Accenture - https://www.accenture.com/in-en/careers/jobdetails?id=R00226183_en&SRC=RECNau
Via - https://jobs.lever.co/viacom18/3dd4b857-45d3-4c44-b6d7-4a4ab6358f9a
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
Accenture - https://www.accenture.com/in-en/careers/jobdetails?id=R00226183_en&SRC=RECNau
Via - https://jobs.lever.co/viacom18/3dd4b857-45d3-4c44-b6d7-4a4ab6358f9a
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
β€4π4
IBM is hiring Data Engineer!
Qualifications: Bachelorβs/ Masterβs Degree
Salary: 6.8 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore; Hyderabad; Pune, India
πApply Now: https://careers.ibm.com/job/20893219/data-engineer-data-modeling-pune-in/?codes=SN_LinkedIn&Codes=SN_LinkedIn
https://careers.ibm.com/job/20738482/data-engineer-bangalore-in/?codes=SN_LinkedIn&Codes=SN_LinkedIn
https://careers.ibm.com/job/20815821/data-engineer-hyderabad-in/?codes=SN_LinkedIn&Codes=SN_LinkedIn
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
Qualifications: Bachelorβs/ Masterβs Degree
Salary: 6.8 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore; Hyderabad; Pune, India
πApply Now: https://careers.ibm.com/job/20893219/data-engineer-data-modeling-pune-in/?codes=SN_LinkedIn&Codes=SN_LinkedIn
https://careers.ibm.com/job/20738482/data-engineer-bangalore-in/?codes=SN_LinkedIn&Codes=SN_LinkedIn
https://careers.ibm.com/job/20815821/data-engineer-hyderabad-in/?codes=SN_LinkedIn&Codes=SN_LinkedIn
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
π4β€1
As a data analyst, your focus isn't on creating dashboards, writing SQL queries, doing pivot tables, generating reports, or cleaning data.
Your focus should be solving business problems using these skills
Your focus should be solving business problems using these skills
π37β€19π€·ββ5π5π₯°2
ServiceNow - Work From Home!
Position: Data Informatics Analyst
Qualification: Bachelor's/ Masterβs Degree
Salary: 5 - 9 LPA (Expected)
Experiencο»Ώe: Freshers/ Experienced
Location: Home (Remote)
πApply Now: https://careers.servicenow.com/en/jobs/744000010245340/sr-data-informatics-analyst/
Position: Data Informatics Analyst
Qualification: Bachelor's/ Masterβs Degree
Salary: 5 - 9 LPA (Expected)
Experiencο»Ώe: Freshers/ Experienced
Location: Home (Remote)
πApply Now: https://careers.servicenow.com/en/jobs/744000010245340/sr-data-informatics-analyst/
π11β€2
Goldman Sachs is hiring Internal Audit Analyst - Data Analytics
Location: Hyderabad; Bengaluru, India
https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/134698
https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/133519
Location: Hyderabad; Bengaluru, India
https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/134698
https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/133519
π2
Latest Jobs & Internship Opportunities ππ
Company β C2FO
Role β Data and BI Analyst
Exp. β 0-3 yrs
Apply Here β https://jobs.dayforcehcm.com/en-US/c2fo/CANDIDATEPORTAL/jobs/808?source=LinkedIn
Company β United Airlines
Role β Associate - Data Scientist
Exp. β 0-2 yrs
Apply Here β https://careers.united.com/us/en/job/UAIUADUSGGN00001710EXTERNALENUSTALEO/Associate-Data-Scientist?utm_source=linkedin&utm_medium=phenom-feeds
Company β JLL Technologies
Role β Data Analyst 2
Exp. β 2-5 yrs
Apply Here β https://jll.wd1.myworkdayjobs.com/jlltcareers/job/Bengaluru-KA/Data-Analyst-2_REQ378268?source=APPLICANT_SOURCE-6-42
Company β Sattva Consulting
Role β Data Analyst- India Data Insights
Exp. β 1-3 yrs
Apply Here β https://www.sattva.co.in/join-us/careers/?jobId=veQNWIXHDUgt&ft_source=6000202916&ft_medium=6000146766
Company β Poshmark
Role β Data Analyst
Exp. β 1-3 yrs
Apply Here β https://poshmark.wd5.myworkdayjobs.com/Poshmark_Careers/job/Chennai-Tamil-Nadu-India/Data-Analyst_R-200114-1?source=LinkedIn
Company β UL Solutions
Role β Process Engineer - Data Analyst with PowerBi
Exp. β 1+ yrs
Apply Here β https://fa-eups-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/ULSolutionsCareers/job/3759?utm_medium=jobboard&utm_source=linkedin
Company β Canam
Role β Data Scientist
Exp. β Fresher
Apply Here β https://www.canam.com/en/job/data-scientist/?utm_campaign=wrap&utm_medium=referral&source=linkedin&utm_source=Linkedin
Company β Exponentia.ai
Role β Data Engineer
Exp. β 3 yrs
Apply Here β https://careers.exponentia.ai/exponentia/jobview/data-engineer-mumbai-maharashtra-india-2024090219313393?source=linkedin
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
Company β C2FO
Role β Data and BI Analyst
Exp. β 0-3 yrs
Apply Here β https://jobs.dayforcehcm.com/en-US/c2fo/CANDIDATEPORTAL/jobs/808?source=LinkedIn
Company β United Airlines
Role β Associate - Data Scientist
Exp. β 0-2 yrs
Apply Here β https://careers.united.com/us/en/job/UAIUADUSGGN00001710EXTERNALENUSTALEO/Associate-Data-Scientist?utm_source=linkedin&utm_medium=phenom-feeds
Company β JLL Technologies
Role β Data Analyst 2
Exp. β 2-5 yrs
Apply Here β https://jll.wd1.myworkdayjobs.com/jlltcareers/job/Bengaluru-KA/Data-Analyst-2_REQ378268?source=APPLICANT_SOURCE-6-42
Company β Sattva Consulting
Role β Data Analyst- India Data Insights
Exp. β 1-3 yrs
Apply Here β https://www.sattva.co.in/join-us/careers/?jobId=veQNWIXHDUgt&ft_source=6000202916&ft_medium=6000146766
Company β Poshmark
Role β Data Analyst
Exp. β 1-3 yrs
Apply Here β https://poshmark.wd5.myworkdayjobs.com/Poshmark_Careers/job/Chennai-Tamil-Nadu-India/Data-Analyst_R-200114-1?source=LinkedIn
Company β UL Solutions
Role β Process Engineer - Data Analyst with PowerBi
Exp. β 1+ yrs
Apply Here β https://fa-eups-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/ULSolutionsCareers/job/3759?utm_medium=jobboard&utm_source=linkedin
Company β Canam
Role β Data Scientist
Exp. β Fresher
Apply Here β https://www.canam.com/en/job/data-scientist/?utm_campaign=wrap&utm_medium=referral&source=linkedin&utm_source=Linkedin
Company β Exponentia.ai
Role β Data Engineer
Exp. β 3 yrs
Apply Here β https://careers.exponentia.ai/exponentia/jobview/data-engineer-mumbai-maharashtra-india-2024090219313393?source=linkedin
πWhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
πTelegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more β€οΈ
All the best ππ
π16β€2
Hiring for data analyst at accenture (0-2 years)
https://www.accenture.com/in-en/careers/jobdetails?id=R00226183_en&SRC=RECNau
https://www.accenture.com/in-en/careers/jobdetails?id=R00226183_en&SRC=RECNau
π5
Company β Poshmark
Role β Data Analyst
Exp. β 1-3 yrs
Apply Here β https://poshmark.wd5.myworkdayjobs.com/Poshmark_Careers/job/Chennai-Tamil-Nadu-India/Data-Analyst_R-200114-1
Role β Data Analyst
Exp. β 1-3 yrs
Apply Here β https://poshmark.wd5.myworkdayjobs.com/Poshmark_Careers/job/Chennai-Tamil-Nadu-India/Data-Analyst_R-200114-1
π8
Business Analyst Problem Statement :-
Uber faces an issue where some drivers ask customers to cancel rides upon reaching the pick-up point and then unofficially complete the rides, impacting Uberβs revenue. As a data analyst, identify these drivers using available data points to address this problem effectively.
Solution:-
1. Fetch the List of Drivers with High Cancellation Rates:
- Objective: Identify drivers whose rides are frequently canceled by customers after reaching the pickup point.
- Approach: Query the ride data to find drivers with a high number of cancellations at the pickup point. This can be done by analyzing the timestamps and cancellation reasons.
2. Fetch Drop Points of the Canceled Rides:
- Objective: Gather data on the drop-off locations associated with rides that were canceled at the pickup point.
- Approach: Extract the drop-off locations from the ride data for the rides that were canceled.
3. Check GPS Location of Drivers Post-Cancellation:
- Objective: Determine the exact location of drivers immediately after the ride cancellation.
- Approach: Use GPS data to track the driver's location when they mark themselves as available again after the cancellation.
4. Proximity Analysis:
- Objective: Check whether the driver's post-cancellation location is within a 0-2 km radius of the drop-off point of the canceled ride.
- Approach: Calculate the distance between the driver's location (when they become available again) and the drop-off location of the canceled ride. Use geospatial calculations to determine if this distance is within the specified radius.
5. Identify Suspicious Drivers:
- Objective: Identify drivers who frequently appear within the 0-2 km radius of the drop-off points of canceled rides and immediately mark themselves as available.
- Approach: Compile a list of such drivers by analyzing the proximity data and their availability status. This list will include drivers who exhibit a pattern of cancellations followed by availability near the drop-off points, indicating potential misuse of the system.
By following these steps, you can systematically identify drivers who might be misusing the system.
Uber faces an issue where some drivers ask customers to cancel rides upon reaching the pick-up point and then unofficially complete the rides, impacting Uberβs revenue. As a data analyst, identify these drivers using available data points to address this problem effectively.
Solution:-
1. Fetch the List of Drivers with High Cancellation Rates:
- Objective: Identify drivers whose rides are frequently canceled by customers after reaching the pickup point.
- Approach: Query the ride data to find drivers with a high number of cancellations at the pickup point. This can be done by analyzing the timestamps and cancellation reasons.
2. Fetch Drop Points of the Canceled Rides:
- Objective: Gather data on the drop-off locations associated with rides that were canceled at the pickup point.
- Approach: Extract the drop-off locations from the ride data for the rides that were canceled.
3. Check GPS Location of Drivers Post-Cancellation:
- Objective: Determine the exact location of drivers immediately after the ride cancellation.
- Approach: Use GPS data to track the driver's location when they mark themselves as available again after the cancellation.
4. Proximity Analysis:
- Objective: Check whether the driver's post-cancellation location is within a 0-2 km radius of the drop-off point of the canceled ride.
- Approach: Calculate the distance between the driver's location (when they become available again) and the drop-off location of the canceled ride. Use geospatial calculations to determine if this distance is within the specified radius.
5. Identify Suspicious Drivers:
- Objective: Identify drivers who frequently appear within the 0-2 km radius of the drop-off points of canceled rides and immediately mark themselves as available.
- Approach: Compile a list of such drivers by analyzing the proximity data and their availability status. This list will include drivers who exhibit a pattern of cancellations followed by availability near the drop-off points, indicating potential misuse of the system.
By following these steps, you can systematically identify drivers who might be misusing the system.
π32β€5π1
Many people reached out to me saying telegram may get banned in their countries. So I've decided to create WhatsApp channels based on your interests ππ
Free Courses with Certificate: https://whatsapp.com/channel/0029Vamhzk5JENy1Zg9KmO2g
Data Analysts: https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02
MS Excel: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i
Jobs & Internship Opportunities:
https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
Web Development: https://whatsapp.com/channel/0029VaiSdWu4NVis9yNEE72z
Python Free Books & Projects: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L
Java Resources: https://whatsapp.com/channel/0029VamdH5mHAdNMHMSBwg1s
Coding Interviews: https://whatsapp.com/channel/0029VammZijATRSlLxywEC3X
SQL: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v
Power BI: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c
Programming Free Resources: https://whatsapp.com/channel/0029VahiFZQ4o7qN54LTzB17
Data Science Projects: https://whatsapp.com/channel/0029Va4QUHa6rsQjhITHK82y
Learn Data Science & Machine Learning: https://whatsapp.com/channel/0029Va8v3eo1NCrQfGMseL2D
Improve your communication skills: https://whatsapp.com/channel/0029VaiaucV4NVik7Fx6HN2n
Donβt worry Guys your contact number will stay hidden!
ENJOY LEARNING ππ
Free Courses with Certificate: https://whatsapp.com/channel/0029Vamhzk5JENy1Zg9KmO2g
Data Analysts: https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02
MS Excel: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i
Jobs & Internship Opportunities:
https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
Web Development: https://whatsapp.com/channel/0029VaiSdWu4NVis9yNEE72z
Python Free Books & Projects: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L
Java Resources: https://whatsapp.com/channel/0029VamdH5mHAdNMHMSBwg1s
Coding Interviews: https://whatsapp.com/channel/0029VammZijATRSlLxywEC3X
SQL: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v
Power BI: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c
Programming Free Resources: https://whatsapp.com/channel/0029VahiFZQ4o7qN54LTzB17
Data Science Projects: https://whatsapp.com/channel/0029Va4QUHa6rsQjhITHK82y
Learn Data Science & Machine Learning: https://whatsapp.com/channel/0029Va8v3eo1NCrQfGMseL2D
Improve your communication skills: https://whatsapp.com/channel/0029VaiaucV4NVik7Fx6HN2n
Donβt worry Guys your contact number will stay hidden!
ENJOY LEARNING ππ
β€8π6π1