Let Walnut Innovation develop your Business Intelligence solution and generate insight and value from your data.
Working with leading BI platforms such as Microsoft Power BI, Walnut will design an elegant, intuitive dashboard that gives users secure self-service access to your data warehouse. If you have multiple data sources, we can supply an Extract-Transform-Load (ETL) solution that pulls them together.
Get in touch to discuss your next Business Intelligence project.
Our services//
A successful Business Intelligence project has several stages, and begins with a deep understanding of your data estate. Then we work with you to develop your requirements - what are the overall goals of the project? Who is the audience? Is the data live or historical?
Extract Transform Load
If your data is multiple locations, databases, files and formats, then an ETL solution can help collate it.
Modern BI solutions are capable of pulling data from multiple sources, but a separate ETL process can help by separating concerns.
The ETL process reduce the volume of data, lessening the load on the BI solution and simplifying its data model. And it can be easier to diagnose problems as the pipeline is split into discrete stages.
Traditional ETL products are monolithic, but serverless solutions like AWS Data Pipeline are now available which integrate with your other cloud services.
Model design
If your data is multiple locations, databases, files and formats, then an ETL solution can help collate it.
Modern BI solutions are capable of pulling data from multiple sources, but a separate ETL process can help by separating concerns.
The ETL process reduce the volume of data, lessening the load on the BI solution and simplifying its data model. And it can be easier to diagnose problems as the pipeline is split into discrete stages.
Traditional ETL solutions are monolithic, but serverless solutions like AWS Data Pipeline are now available which integrate with your other cloud systems.
Dashboard design
Careful design of the reports and dashboards can fully unlock insight into your data.
We will work with you to ensure each consumer has the right dashboard for them, is available where they need it, and has matching corporate branding.
And if the right visual is not available in your chosen BI product, we can develop custom visuals to meet your exact requirements - see below for details.
Custom visuals//
Business Intelligence platforms include a rich set of charts and other visuals, but sometimes a customised solution is needed. Walnut has developed several custom visuals for Microsoft Power BI to provide a bespoke dashboard solution that meets the specific requirements of the customer.
Read more about this custom slicer for Power BI, available for free in the Microsoft AppSource store.
Customer case study//
Power BI solution for client self-service
RealService helps their clients create great places to live, work, shop and relax.
RealService collects and analyses thousands of in-person and web-based interviews - all managed on a bespoke platform developed by Walnut.
Recently Walnut worked with RealService to implement self-service dashboards for their clients, using Microsoft Power BI to offer rich, real-time data self-service.
