I need to create an attractive report Dashboard in Google Sheet -- 2

I need to build an attractive looking dashboard in Google Sheets. I will be having my company people updating the sheet on a daily basis and I would like to have a consolidated data where I can see the entire report in 1 glance. I shall provide you with the parameters of things I need in the report. Its mostly like excel Pivots. But needs to look like a proper Dashboard where I am able to get all the data at a glance.