Which tool to choose for visual data analysis (MySQL database)?

Question

MySQL

There is a database of retail transactions (6+ million records; id of the client, product, categories, amount, date / time), now loaded into the MySQL database. We also have a person who knows what to pull out of the database ("average check for buyers of categories 1, 2, 3", "turnover distribution by months", etc.), but is completely unfamiliar with SQL (and it is not advisable to teach).
What can the respected community recommend from tools/approaches in this case? Now all selections are made through the system administrator, which is very inefficient and not humane;)
I found this question , but here it’s more like a management tool with 1 plate and entering / searching for simple values ​​​​(like searching by last name).
Thanks ;)

Answer 1

Formulate requirements, apply for freelance, get a solution.

Answer 2

Tableau will do. It will connect to the database, and your analyst will be able to read his parameters in the program itself. True, certain types of queries that require joins will still have to be written in SQL.
Excel in its pure form will not pull, but there are add-ons like PowerPivot that allow you to use it with big data.
Last but not least, learn SQL. Analytics is 100% necessary, and it is not so difficult to teach it.

Answer 3

Excel has a completely wonderful Pivot table (Pivot table)
try

Answer 4

I recently came across PowerBI from Microsoft.
It seems to work with MySQL, but I did not check it myself.