Techstern helped the client to implement an accelerated data warehouse using SQL , high-performance tabular models and visually appealing on-premise Power BI dashboards. Data was consolidated quickly from the sources and the company now had a ‘single version of the truth’, that was trusted by the whole business. KPIs were standardized and were instantly available via Power BI.
To start with, we did a small POC, where we fetched the data from the excel sheets & showed them a visualization which plotted – the sum of accidents by Weekday & Time Range. This gave them the answer to some of their very simple questions. The best part was, they could compare this year on year, quarter on quarter & month on month. Then started the flow of reports, where we developed the following different kinds of reports: