22 August 2024

Requirements Analysis no sexy buzzword, but nevertheless indispensable

14 August 2024

Embracing ESG (& CSRD)

In the wake of global challenges such as climate change, social inequality, and corporate governance failures, Environmental, Social, and Governance (ESG) principles have emerged as vital metrics for evaluating the sustainability and societal impact of businesses.

30 July 2024

Jump start
your data lake with our meta data driven blueprint

By leveraging metadata and cloud technology, we enabled faster data ingestion, improved data exploration, and delivered significant cost savings and business insights.

22 July 2024

The five key takeaways you should know about the EU AI Act

16 July 2024

The Importance of Logging and Auditing in Data Integration

4 June 2024

Generative AI & Power BI: using Microsoft Copilot to enhance Report Creation

In a rapidly and constantly changing data-landscape, data-driven decision making is becoming more and more of a necessity rather than a possibility.

Spaas Candles
Leveraging Power BI’s Dynamic and Interactive Reporting for enhanced sales insights

Spaas Candle’s has been in operation since 1853, specializing in crafting candles. Their aim is to captivate and inspire people with their products. Thanks to Power BI they can always rely on having the most accurate information at their fingertips.

AUTHOR – Jannis Ramaekers

How we
supported Spaas

Before
For Spaas to visualize their data, they had to manually extract data from SAP and import it into Excel on a monthly basis. This process required labor-intensive manual transformations, taking up significant time and resources. As a result, the generated reports were slow-moving and inflexible, providing little room for customization. Furthermore, the manual nature of these tasks frequently resulted in errors.

The journey
We began by conducting a thorough analysis of the existing reports and underlying data, which we then structured into a star schema. This schema serves as a flexible foundation upon which to build our reporting framework. Following our analysis, we established a pipeline via ADF (Azure Data Factory) for nightly ingestion of data from SAP into our data warehouse. Once this data was curated and validated, we initiated the construction of Power BI dashboards and reports. Throughout this process, we prioritized listening to our clients’ specific objectives, ensuring that the reports delivered precisely the insights necessary for the company’s growth.

Challenges
and benefits

Challenges
• Manual labour
• Static reports
• Significant margin of error
• Time-consuming
• Limited adaptability

Benefits
• Dynamic
• Interactive
• Updated daily
• Fully automated
• Time-saving

Thanks to Power BI and Acumen there is no more manual labour
leaving more time for other pursuits.

What to
expect after

Dynamic reporting
With this reporting system, they have the autonomy to select the insights they wish to gain: whether it’s customer turnover, product margins, or any other metrics. The possibilities are limitless.

Updated Daily
Thanks to the daily updates, they can always rely on having the most accurate information at their fingertips.

Fully automated
No more manual labor for them, leaving more time for other pursuits.

Would you like more information?

Request a free demo.

Our team has the answers

Stay informed about our latest insights

By submitting your email address, you agree to receive marketing emails from Acumen, and accept our terms & conditions and privacy policy.