Fashion brand Dante6 transforms ERP data into smart insights with Power BI

When Dante6 moved from Microsoft Dynamics NAV to the ERP system It’s Perfect, the trusted Excel reports directly connected to NAV came to an abrupt end. This transition not only created an information gap, but also exposed the limitations of the existing reporting setup:

• A lot of manual work
• Full dependency on one system
• Limited ability to combine data from other sources

Dante6 engaged XSARUS to develop a future proof BI solution together. One that not only solved the current challenges, but also created room for growth and further professionalization.

The solution

After a thorough analysis of the starting situation and requirements, XSARUS began developing a central BI environment. Built with Power BI and Azure, it brings multiple data sources together. Within this environment, Dante6 can build and maintain its own analyses.

The implementation was delivered in three agile sprints:

• Sprint 1: Set up the Azure BI environment and connected it to the new ERP system. Launched the first standard reports.
• Sprint 2: Migrated historical NAV data and mapped the old and new data structures.
• Sprint 3: Delivered a training program for internal teams and developed custom dashboards.

After sprint 3, we completed an evaluation and adjusted the scope for further optimization.

The result

In addition to It’s Perfect and Microsoft Dynamics NAV, data sources such as Exact, SharePoint (for budget information), Google Analytics 4, and Magento were also integrated. This resulted in one unified, future proof data model that can be used broadly across the organization.

The new BI solution delivers more than just time savings for Dante6. It brings control and flexibility. Where disconnected sources and manual work were once the norm, there is now one integrated platform with interactive dashboards and real time insights. No more complex Excel models.

Data analysts can now build reports independently, answer deeper questions, and easily combine data from different sources, from sales and inventory to marketing and finance. The solution is also system independent, meaning future ERP changes no longer lead to losing insights or reporting.

Growing together towards data driven working

The collaboration with Dante6 was intensive and built on co creation. By actively involving and training analysts and team members, the solution is not only technically strong, but also widely supported across the organization.

ERP migrations always bring unexpected challenges. But thanks to flexibility on both sides during the sprints, the impact stayed limited. The result? A stable, scalable solution that meets the expectations of everyone involved.