Case Study 2
Friday, October 1st, 2021
Background
Flexi Travel is a bus company that provides shuttle services between cities. They are a company with a passion to provide their clients with the best possible service. The owners wanted to reduce the number of accidents that involve their buses. They use OneDrive for Business to store Excel sheets they use to record the accidents. The figure below shows a sample of the data.
They now have more than four years’ worth of data.
Challenges
Flexi Travel does not know where to start the analysis. They require an effective solution within their budget.
Requirements
They want data to be fetched from OneDrive for business and produce visualizations. Considering the situation, where there was a budget constraint they expected to see the total number of accidents by day of week and time. Further, they want to compare year on year, quarter over quarter, and month over month statistics. The visualizations should be refreshed automatically to reflect updates to the OneDrive data.
They also want to predict future accidents using regression analysis. Finally, they want to track income and expenses.
When the data was imported into Power BI, Power Query did not correctly determine the column headers for the accident tracker table. The fifth row contains the headers, as shown below.
