Analytic reports system

Analytic reports system

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.

 

TASK
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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*



Visit Us On TwitterVisit Us On FacebookVisit Us On Linkedin