Excel data transformation using SSIS
Budget: $30 – $250 AUD
I have multiple excel sheets linked with each other to transform the data and get insights. Everything gets stored in the output excel file after transformation which contains roughly 50 data points. I also have sheets that explain the process and the logic behind excel formulas, filters and how they are used.
I want to use SSIS for data transformation instead of doing the whole thing on excel to obtain similar results. Also, I only want to do the transformation on 4 data points initially and am mainly interested in the calculations that we can do the calculations in SSIS.
This is a simple project requiring simple calculations and maybe a walk in the park for someone who is well versed with SSIS. It also has a potential opportunity for extension once the Proof of Concept (4 data points) is successfully completed.
I want to use SSIS for data transformation instead of doing the whole thing on excel to obtain similar results. Also, I only want to do the transformation on 4 data points initially and am mainly interested in the calculations that we can do the calculations in SSIS.
This is a simple project requiring simple calculations and maybe a walk in the park for someone who is well versed with SSIS. It also has a potential opportunity for extension once the Proof of Concept (4 data points) is successfully completed.