I can highly recommend i-spark based on their expertise and extremely pleasant cooperation.

- Hans Krol, KAW Architects and Advisors

View case

Hans Krol, Quality Advisor at KAW Architects and Advisors started working on a dashboard himself, but soon ran into problems. Hans explains: I had already created a design of the desired dashboards. And I’ve been working on unlocking Simplicate’s data through the API. There I quickly ran into the so-called limit of 100. In addition, at first glance, the dashboard appeared to look extremely simple but in order to visualize the data, complicated calculations are needed to distribute, for example, the Sales forecast over the months, the same goes for project forecasts based on subsequent calculation. It turned out that this requires a lot of programming even in the user-friendly tools for Dashboards. For this, I approached i-spark and started this adventure with them.

For our financial projections, history is very important but it is not stored anywhere in Simplicate. Therefore, we chose a route, where every day a set of all the necessary data from Simplicate is stored in its own database and with Klipfolio the dashboard is visualized with this data. The data is retrieved with queries that I can’t write myself, but i-spark just can.

Insight

in profitability and revenues

Hans Krol - Quality Advisor at KAW Architects and Consultants

Without the help of i-spark, the dashboards could not have been realized. I especially appreciated the hands-on mentality and the practical thinking along and especially the experience with data that made them look beyond just building the dashboard with the urge to also make it as robust as possible. I can highly recommend i-spark based on their expertise and extremely pleasant cooperation.

read more about us

Does your company operate in the B2B service sector?

Do you run fixed-price projects and/or on a directional/after-the-fact basis, strip cards or subscriptions? Do you need more insight into the profitability of those projects and employees? Are you already using software for your timekeeping?

Where the accountant helps you with accounting and the business expert with your business processes and the choice of your business software, i-spark helps to unlock the treasures of information contained in those packages and translate them into a dashboard based on which you gain insight into profitability and sales. Not so much from and accounting perspective, but more focused on operations. In our experience and that of our customers, this component is often underexposed in this type of software.

Read more about this in our blog on this topic.

The goal

The goal of this assignment was to set up a data architecture so that the right data could be visualized in the dashboard. For KAW’s financial forecasts, having history in the dashboard is very important, therefore history is now stored via a database solution and retrieved with appropriate queries and displayed in Klipfolio.

Services

We used Data Analysis, Data Engineering and Data Visualization to develop KAW’s dashboards.

Wondering how we can help you? Contact us with no obligation!

get in touch

Technologies