Custom software application development for data management and analysis -- 2

Job ID: 36359078

Budget: $30 – $250 AUD

I require a custom computer software application to be developed that will enable me to easily manage and analyze customer data extracted from the Bitrix24 CRM system. Currently, I extract an MS Excel file containing data on over 2,000 customers every day, but it contains a lot of unnecessary data that I do not need.

I need a program that can generate a new report from the MS Excel file that removes all the unnecessary data and allows me to sort and organize data based on criteria such as who created the data, when it was created, country location of the customer, and other descriptions or labels. The application should also include search functions to easily find specific data and should be very user-friendly and easy to use by someone with limited Microsoft Excel skills or no computer programming knowledge.

The computer program would allow me to: 1) upload or drag a raw MS Excel file into the software developed, 2) indicate the report I want generated according to the filtering criteria, etc.; and 3) it will generate the simpler report that I need that removes all unwanted data

The application might be developed using a programming language such as Python, Java, or .NET and should include a user-friendly interface that allows me to easily select the data fields I want to include in the report. It should also include pre-built sorting options that allow me to sort the data by date, by creator, by country, or by any other relevant criteria.

I have a limited budget of AUD$80 for this project, and at this stage, I do not require more advanced analytical tools like drag-and-drop functionality or visualization tools such as charts and graphs.

The key functionalities required for this project are:

* Generate a new report from the MS Excel file that removes all unnecessary data
* Allow the user to classify, organize, and sort data based on different criteria
* Include search functions to easily find specific data
* Be user-friendly and easy to use by someone with limited Microsoft Excel skills or no computer programming knowledge.

A sample of such an MS Excel file with raw data is attached.

The project must be completed (that is, it has undergone testing and satisfies my requirements) within five working days from the time the project is awarded. A prototype must be sent to me within three working days for testing.

I will own full and all rights over the software that is developed.