Table for collecting and analyzing transactions

Data Processing — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

It is necessary to visualize data on incoming payments, the information about which we provide in the form of CSV or Json.

The data must be visualized in Google Sheets, where they will be grouped by days, months, senders, and there will also be an analysis of total amounts and the number of transactions over a certain period.

The table should be user-friendly and have the ability for quick viewing of statistics.

Functional requirements:

Structuring, filtering capability

Grouping: days, months, senders, counting total amount and number of transactions over a certain period

Visualization:

Creating charts/graphs to display total amounts by day/month/senders

Chart analyzing the percentage share of each sender

Non-functional requirements:

Performance

Ease of use/intuitiveness

Pleasant visualization

Expected result: a working tool for collecting and analyzing transactions with the ability to filter, group, and view statistics.

Proposals 5 Discussions 1

Vladislav S.

102 0

Budget: 50 USD Deadline: 2 days

Good day. I would be happy to help. Are you considering the option of visualization in Looker Studio?

Nadiia G.

19 0

Budget: 45 USD Deadline: 6 days

Good day!
I will create the table you described.
When data is entered into the table, all statistics will be automatically calculated and displayed, and you will be able to filter the necessary data. Transaction amounts by days, weeks, months. Separate summarized data by senders and corresponding charts for easier perception of information.
You can send a test file, I will demonstrate how I see the result. If you are satisfied, we will continue working on the file.