How Complicated Data of a Luxury Retail Group of Companies Turned Into Beautifully Visualized Data

The Situation

The finance team of a luxury retail group of companies would spend more than 25 days to generate important financial reports that were critical for taking important business decisions. Most of the data to create the financial reports, was collected from Microsoft Dynamics AX 2012 ERP directly.

Generating reports after pulling the data from the ERP was quite a tedious task, thus delaying reporting and further delaying important decision-making.

Click here to get more info about: power bi dashboard

The same situation applied to marketing and sales departments as well.

The Problem

Taking key business decisions was much slower in the company as a result of redundant investment of time in generating important Business Intelligence reports. The data came from disparate data sources, considering the group of companies had eight independent finance teams.

The retail giant’s IT team could facilitate pulling information from most of this data sources by using default MS Dynamics AX Operational Reports , the IT team couldn’t identify & automate the exact methodology to pull data from MS Dynamics AX ERP.

Additionally, there were a lot of eliminations in financial consolidation, considering multiple transactions between the different subsidiaries of the luxury retail group of companies, making ad-hoc analysis a further problem.

Talk to us directly to know more details about the case study

The Objective

To optimize the BI reporting process and cut down wastage of time in order to enable swift decision-making for key business functions. To enable this, the company required to create a single source of truth from disparate and isolated data sources. Extract, Transform and Load (ETL) the data from various sources for data modelling to generate BI reports.

The Solution

Data Semantics identified that generating BI reports for this retail giant required automating the data extraction & Transformation process.

The team of developers used MS Integration Services to extract & automate the data from Microsoft Dynamic AX12. Team also used Python to pull data automatically from sources like CRMs (Salesforce), Google Analytics, Social Media and MS Excel. This was quite a breezy affair.

The main challenge was to pull the data from Microsoft Dynamics AX ERP as the IT team of the retail giant couldn’t identify the exact Framework & tables to pull the data.

Pulling data from such an elaborate ERP system can be daunting task as it requires specialized expertise. MS Dynamics AX shows limited indications in the database to identify the exact data tables , making it difficult to automate data extraction.

For more info visit here: tableau business intelligence software

Data Semantics CTO, Imaduddin Shah, having massive experience in Microsoft Dynamics and Azure ecosystem, could identify the exact tables from the MS Dynamics AX database to pull the data from. This critical knowledge led to saving tons of time and expediting the building of data-pulling automation algorithms.