May 04, 2023
In this project we cleaned the data by removing duplicates and
analyzing the processing time in which the invoices and disputes were settled,
and how much revenue were lost. We also provide conclusions and recommendations.
In this project I create a dashboard showing on how the given data affect the average time taken for delivery and calculate measures using DAX to get the Average Delivery Time for the kind of weather conditions and the type of vehicle.
In this project we clean and transform data using MS Excel,SQL, and Power BI and create dashboard in Power BI poviding the information requested by the stakeholder.
In this project I used MS Excel to clean and transform data. I used the pivot table to sort the necessary information and add it in the dashboard.