Building a dashboard in excel with power query

i would like to build a excel dashboard to track performance of the factories on various parameters. Data is available in another data source. need to make visualization on performance, top & bottom 10 performer, top contributor, dilutor, ranking by site. Ability to slice by country and by site or by specific parameters.