The Challenge
Erstwhile, the data was captured in flat files and then inserted into MS Excel spreadsheets based on the business requirements. Power BI would then pull the data from these excel sheets for report creation. Due to excel as data source for the Power BI, the time taken to produce the reports was higher and dimensions present for report generation were fewer.
The Solution
The team at Nalashaa started by drawing out the business requirements and aligning it their business goals. They planned and developed a new design that increased the data load speed 3 times than what it was before. The new architecture also allowed for 4 times more dimensions as compared to the older version. This enabled greater granularity in reports. To speed up the process, Data Marts were designed and developed after data load in db.
Benefits
- Reduction in Time – The process-time for data load and report generation was reduced in half from 12 days to 6 days.
- Better User Experience – Users are able to create reports from more dimensions, thus enabling better decision making
Technology Stack
- Power BI
- Snowflake