Disclaimer: First, I am a student worker that has limited experience with coding. I am not sure how much of this process can be solved this way. Second, I recently started using SharePoint so I'm not sure if embedding the graph/chart at the end needs to have any special requirements. Finally, hopefully this is in the right spot because it presumably uses things that aren't just in SharePoint but I would like the end result to be viewed in SharePoint so it made sense to post this here.
At my school we have a reporting tool that can automatically generate .csv files from our financial system. My task is to come up with some framework as to how we can get this data to automatically upload and embed into a SharePoint 2013 site after using the data to create a visualization (chart/graph). This is what we're envisioning:
The report (.csv file) will be automatically generated at X time each day and downloaded to a local folder. This part I know what to do and how to do it. One potential problem: how do I automatically delete files from the previous day before the next one is downloaded?
The downloaded .csv file will need to be uploaded to something that generates a basic graph or chart based on some predefined criteria. I do not know what program/coding to use for this.
The graph/chart needs to be automatically embedded/reloaded in the SharePoint 2013 site. This part seems straightforward enough, but I'm not sure if there are any specific requirements when using SharePoint.
Once this is all set up, they don’t want any human interaction with the process, allowing it to go on each day and automatically update the charts on the site. My overall question is: how do I accomplish this? What programs/sites/coding/etc. do I need to use? Will there be a cost factor or is everything I can use free?