NetSuite - ERP Data Extraction, Modelling and Visualization
What was our client's requirement?
Our client is a top Tier analytical Service Company that deals with lot of credit, banking, and financial information. They came to Datagene to assist with optimising the data extraction from NetSuite ERP and the reporting processes. What was already there? Well, they had an outdated way of data extraction and reporting process but asked our team to automate the process.
What was the solution?
We Extracted and Load the data from a CRM suite Specifically on NetSuite ERP and integrated it using SSIS Package and ODBD Driver.
The next process we embarked on was to model the data to ensure the Integrity of the data set and ease of performance.
While doing the modelling, we identified the Dimensions and Metrics (Fact), and we adopted the Star-Schema style of modelling.
We also interpreted the Extracted and modelled data into an insightful dashboard/visual where the business can draw insight about the trends and patterns of the data.
