LittleMetrics

LittleMetrics is a company in the small SME segment. The company is data-rich and has a data ambition, but the organization itself does not have the knowledge to fulfill this ambition.

Case

The company collects, produces and purchases data and stores it in various Excel files that which they misuse as a database. The company is growing and has now reached the point where this solution is no longer scalable, secure and efficient. The users make daily operational decisions based on analyses from these Excel files. This means that the reports have to be rebuilt on a daily bases. Their wish is to automate and visualize the reports, which saves them time to focus on the core business of the company.

Solution

MM Guide created a bisual web interface where has ensured that the data can be read into a data warehouse through a visual interface. The data is automatically processed periodically (daily) and then displayed as KPI’s in a dashboard. The users only need to log in to the dashboard to make be able to base their decisions on these new insightsit.

Success

This solution saves LittleMetrics at least an hour everyday of building Excel reports, which means that the investment has beenwill be recouped in 2 years. In addition, decision-rich users get their data clearly neatly arranged and visualized, so they can spend their time more effectivelyefficiently.

Tech

For this cloud solution we opted for an Azure SQL database, a .NET application and an Azure PowerBi dashboard.