Jacquiline Calderon

Calculating Business Metrics For a Delivery Company Using Dax Measures Project URL: https://drive.google.com/file/d/13vmT9wdK8oJPg9fuX0vhxEMOArzaqRml/view?usp=sharing Task Description: You work as a data analyst in an Indian delivery company. Top managers want to expand the business to other countries in Asia, so they asked you to make a report about delivery time to compare the company’s performance with competitors. Data is presented in a .csv file, with fields such as time of delivery, order date, traffic, weather, location, and other information. Goals: Create dashboard showing how the vehicle type, type of order, weather conditions, and road traffic affect the average delivery time. Calculate measures and add these calculations to the dashboard. 1. The median time that is taken for delivery. 2. The average time for delivery for sunny and stormy weather. 3. The difference in average delivery time between ordinary scooters and motorcycles. Data Preparation: I Clean the “Weather conditions” column. Remove duplicates and replace the values ‘NaN’ in the “Weather Conditions” and the “Road Traffic” columns with “no data”. Remove errors in the “Time Ordered” and “Delivery Person Age” Columns. I change the data type of the “time_taken(min) “column and split the word “min” to get the average time. Filter rows for delivery_location_latitude and remove outliers. Analysis: Calculate the required measures using DAX analysis. 1. The median time that is taken for delivery. 2. The average time for delivery for sunny and stormy weather. Average delivery time for sunny weather. Average delivery time for stormy weather 3. The difference in average delivery time between ordinary scooters and motorcycles. Average delivery time for Scooter Average delivery time for motorcycles. Difference between average delivery time for motorcycles and scooters. After Calculating, the dashboard was created, and the measures was added. Recommendations: As a data analyst, what would you suggest to the delivery company so they can collect better data and get more precise results? • • • The data collection processes should be in place and specified on what data should be collected, how it is collected and who will be the responsible on collecting it to ensure the reliability of the data and to reduce errors. Get feedbacks from the customers about the services they received. The company should invest digitalized devices to automate the collection and stored of data, and to track deliveries and shipments and also to ensure that the data collected is accurate and up-to-date.