Japan Shah
New Member
Hello,
I am currently working on spreadsheet data which has some inconsistent data. I need help in sorting, cleaning, and making a proper table out of data. My ultimate goal is to get consistent table before loading into BI tool to generate graphs.
I need to automate the process. For instance, I am exporting data from sharepoint into excel and from excel into BI tool. I need to automate this entire process which would take data from sharepoint into excel and then do appropriate calculation in spreadsheet and load it into BI tool to generate graphs.
Thanks.
I am currently working on spreadsheet data which has some inconsistent data. I need help in sorting, cleaning, and making a proper table out of data. My ultimate goal is to get consistent table before loading into BI tool to generate graphs.
I need to automate the process. For instance, I am exporting data from sharepoint into excel and from excel into BI tool. I need to automate this entire process which would take data from sharepoint into excel and then do appropriate calculation in spreadsheet and load it into BI tool to generate graphs.
Thanks.