CALCULATING BUSINESS METRICS FOR A DELIVERY COMPANY

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. 

Task 1: Import data to Power BI

Task 2: Create a dashboard showing the average delivery times

Task 3: Create map chart using the Geographical coordinates 

Task 4: Calculate measures

a. Create a new DAX measure that calculates the median time that is taken for delivery. 

b. Create another new DAX measure that calculates the average time for delivery in sunny and stormy weather conditions.

c. Create another new DAX measure that calculates the difference in average delivery time between ordinary scooters and motorcycles.

d. Use the newly created DAX measures in your dashboard by creating card visuals for each of them.

Task 5: Provide Recommendations