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.
26 freelancer chào giá trung bình$193 cho công việc này
Hi, I'm a data engineer, with 11 years of experience. Please DM me so I can send you my linkedin profile to get some insights about my work. Regards,
I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations,I can complete your project on time and within your budget
I have a good experience in Excel, SQL, and data modelling. I have a very good typing skills. I can do a quality work. Pease give me an opportunity to work for you.
Tengo amplio conocimiento en SSIS visual studio, ETL, Exploracion-Transformacion-carga de datos entre sistemas, he trabajado con formatos de excel como origen de fuente de datos en SSIS.