AT A GLANCE
Clear representationof data leading tomeaningful andinteractive insights
Annual costsaving ofapproximately
INR 51,75,000 / ($67852)
The reports contained a vast amount of complex data, making the results difficult to interpret.
The creation of the reports involved manual organisation of information which was time-consuming and not an efficient use of resources
The margin for error was very high as a result of the manual nature of data processing
Accurate reports that identified business performance across regions
Meaningful and interactive insights
Decision making based on clear, accurate data
The team also developed a drill down report usingPivot Table to summarize the data.
The hierarchy for the drill down report was
To elaborate further, one single drill down reportwould initially display revenue region wise. On drilling in each region, the report would display details of that particular region. Further drilling would display details of that branch.
Reports that provided clearlyorganised data
Reports that were accessible from one placeand that could be shared with multiple users
Classification of business based on differentregions/locations that would then enable acomparison of how the policies were performingin each location
Our team of experts used a Power BI report to unify data from the multiple locations and create an interactive report that used the map visualization to display the income location wise.
INR 51,75,000/ ($67852)