Setting up restaurant dashboards in Google Looker Studio

It is necessary to set up analytical reports for the restaurant. Taking into account: the number of visitors, total revenue for the restaurants, for each zone of the restaurant, in amounts in %, set the ability to select dates and periods, taking into account (men, women). Compare statistics by dates and periods. Transfer statistics to the MySQL database and connect Google Looker Studio to the database and configure reports.