Faster processes and greater insight into customer data
This desire started a search for a more efficient solution. The solution should make AURA's data more easily accessible so that the company could compile more data from several data sources.
On that basis, twoday kapacity has built a central Enterprise Data Warehouse, which has replaced some of the fragmented and local models in the organization, that came from Excel, Access and Power BI Desktop.
Data are displayed from the Data Warehouse for reporting and dashboards in Microsoft Power BI via a Tabular Model. Initially, data are included from AURA's source system, Microsoft Dynamics AX, where data are drawn from areas such as AURA e-commerce, Fiber, Finance and others, as well as budget data loaded via Master Data Services. In the longer term, the ambition is to activate more users and release resources at the people, who today spend time updating files.
As a result, AURA is no longer dependent to the same extent on manual processes such as data processing in spreadsheets and because data are already prepared in a Tabular Model, the process of creating reports and analyzes has become significantly faster.
AURA has also decided to implement Microsoft Power BI – which will run directly on the data cubes, and the possibility that central reports and key figures are always ready with updated figures, is also very well received in the organization. AURA's super users have been trained to build reports in Microsoft Power BI Desktop and subsequently share them in the organization via the Microsoft Power BI Service.
