I was building executive dashboards for project management offices. I would have a portfolio of projects. Mainly, it was for opening new units and new markets. I would have project plans and action item logs, and I would use those in Smartsheet, and then I would ingest those up into Domo and I would be able to run statistics and metrics to track the progress of any given project. I would be able to calculate things like percent complete according to the calendar, percent complete of the budget, percent complete of the scope, number of tasks, percentage of tasks against total tasks, et cetera.
I could, for each project, if I wanted to drill down, go in, and see the detail of the tasks. I could also go see the action items, the risks, the issues, and the action items associated with the project. Therefore, I could see how many of those there were, what were critical, high, medium, or low, and which ones were late in terms of the due dates and things like that. I could run both a general project status meeting for a given project and also, at a high level, show a swift health check of a set of projects. That was very helpful for the executives.