How to organize a database with visualization in Google Data Studio without programming skills?

Question

Database

Good afternoon!

Please provide ideas on how to organize the storage of ticket sales data in such a way that they can be visualized in Google Data Studio. The required update frequency is once a day. Programming knowledge is very low.

Current situation.
Information about tickets sold is given by bus stations on paper. The dispatcher processes statements through a Google form. Data for several routes are summarized in a single table. Financial indicators are also calculated there.

A filter is used to collect the daily report.

Problem: after 2000 rows, the pivot table starts to work more slowly. The filter is processed for several minutes (3-5).

After the end of the month, the data is uploaded and saved to an Excel file on a PC. Because of this, every month you need to load the dataset. Not to mention that daily visualization is unacceptable because of the time that would be spent on it.

Answer 1

Spend some money and order what you need. The order of amounts is from 20 to 60 thousand. And you will have an application that works quickly on a mobile phone and visualizes. I'm sorry if I hurt your feelings and you're not ready to spend money