Dashboard

I'm looking to create a dashboard that visualizes my company's data, particularly inventory data, how much we have, where it is, and how long we have had it, in real-time. The dashboard can include both tables and lists displaying the relevant information. It needs to have the ability to quickly and accurately show changes in my data so I can stay on top of the most recent statistics and trends. This would be used to better understand where our inventory is and how long it has been there. No matter what type of data needs to be conveyed, I would like my dashboard to be able to clearly display it in an intuitive fashion. Data is managed on google drive.