I am a fairly new SharePoint Designer and I am swimming through projects for my company from the project level to the corporate level. We have recently been utilizing SharePoint online and I have created dozens of sites for the projects and the corporate office, and have integrated almost everything the company wants, but now I want to capture relevant information and project it in a streamlined "Dashboard" on the home site of any page.
I am currently researching pivot tables to find out whether they would be useful for embedding, but I feel like I'm chasing down this idea down many rabbit holes that wont really lead me to my end goal.
For starters I am wanting to create a dashboard for a help desk that gives me live updates on: How many tickets are open, how many tickets are closed, what type of problems are assigned to which technicians.
Any ideas on where I should start my research to create something like this?