Analytic reports system was developed as additional tool to analyze and manage data which was collected by our scraper tool. Software has wide features for working with collected data and database and the main goal of this software is to build reports for analyzing data and saving results in Excel.
Our customer has large array of data and need to get analytics from this data. We need to find optimal structure of database for this data and upload it. Database should to provide ability to perform different analytics reports.
The solution was found in using free MySQL database which has large potential for data store and operations of processing data. We have developed C# software which has following functions:
- remote connection to MySQL database on hosting via MySQL Connector component,
- processing CSV files, linking data from files and uploading them in database,
- several reports for getting analytics,
- ability to save reports in CSV files which can be using in MS Excel.