Data visuals in dashboard project for business owner clients.

I am looking for a way to combine incoming user data to a visual dashboard. Data will be persistent and real time demographic data coming into google sheets( name, address, gender, url, etc...) from ID resolution matching campaigns and web assets. Multiple sheets will be combined into a hosted database and assigned sheets will go to client accounts created in the hosted database environment. I want a web app that I can designate google sheet data into a web based data visualizer with filters based around certain criteria like USER data, location, etc... Including a compare feature. year to year, date to date range. I need to be able to onboard data quickly into interface that a client logs into. Also have admin panel that can combine all data sheets into one master interface. Google Data Sheets will have up to 200 points of x-axis data. Multiple types of graphs based record count, percentage, etc.. 2 User Roles - Admin, User/Client -Admin has access to add new clients, create client account, sync data, and share dashboards. -User/Client - Access front facing data dashboards, filters, reporting and sharing. Dashboard must have share view via url. Client Account Creation - Admin must first create client database and assign google sheets to pull from for that table and data set. Then the admin must create a dashboard instance for the client and assign the database to that clients account and UI. UI - Very modern and up to date, mobile friendly and responsive. Very simple UI. would like some basic pre-load animations if possible. The dashboard will be the same for all clients and include the following. Pie Graph showing percentage of users living per Zip code. List of top Zip codes Pie Graph for gender percentage Bar Graph for age ranges. List and number of users for each webpage visited. Map with pins of user geographic location based on physical address(automated GPS location ID if possible) Bar graph for Household Income Bar Graph For Credit Rating # of homeowners List of Insurance providers and leaders Pie Chart Occupational information percentage Pie Chart Ethnic Group Percentage Net Worth Bar Graph For Buying habits Pie Chart for Credit Card Brand Pie Chart For Interests Bar Chart for Car data Bar Chart for Motorcycle data Filterable query of full database of data by field or keyword. Preferred UI will be anchor link driven...one long single page for each client with left sided anchor link navigation. DATA FLOW CHART AND USER INTERFACE DIAGRAM - https://miro.com/app/board/uXjVMexIm0A=/?share_link_id=991942018864