Kamran A. Warsi

DoorDash Excel Project

• This case study is intended to simulate this scenario. In this case study, the scenario is being hired as a data analyst for DoorDash and I have been challenged to:

- Understand the data and find business opportunities & insights - Propose any data-driven action to optimize the results of the campaigns & generate value for the company,

• Reduced the number of bugs between python 2 and python 3 string object compatibility by 10% in process improvement coordinating with team and getting feedback in 6 months
• Maintain documentation and GIT version control for team collaboration and organization concerning data types, metadata being filtered, and SQL queries
• Collaborating with team members to verify correct encodings and serialization of metadata in Python 2 replicated over to Python 3 to maintain data compatibility
• Created corresponding tables in PostgreSQL and inserted the transformed data using INSERT
• As well as further transformation using CAST, JOINS, and aggregation functions such as: COUNT, AVG, and SUM for summary statistics.