Data Migration from SAP to Dimensions
This was a challenging project required due to organisational restructure which necessitated data separation.
Major challenge was lack of cooperation between the member parties, hence diplomacy required to overcome obstructions and reluctance to get the project off to a start following a stall.
Data extracted by data owner into CSV.
Data cleansed and transformed using EXCEL formulas.
Data loaded into Microsoft SQL Server database
Front end application developed, using Excel, for users to quickly query various aspects of historical data.
Hand-over documentation provided for both end users and administrators.
We recommended best database server and front-end solution for the client, after evaluation of existing investment and in-house expertise.
Project completed on time and with cost-savings.