Hi. We are trying to make a decision as to whether or not Tableau is the right tool for our PPM (project and portfolio management) analysis and reporting needs. I have not found any examples of Tableau being used for this purpose. Is there anyone who has done this with the product? Some details follow….
We have typical PPM data: not all departments have active projects each month, departments which have never made a request before can make one at any time and new departments are formed periodically. (Have to cope with departments merging too, but let's put that to the side right now.) We're currently using Excel to generate reports and charts: the data consists of about 500 rows/month with about 100 fields, with an expected growth rate of possibly 10% of rows/month and potential addition of fields over time. The data source is currently Excel but can be changed to Access if that helps. Charting of trends is very important to us, as is exception reporting.
Two basic sample needs are:
1. a count and distribution of all data elements (text strings) in a field on a monthly basis, trended by month, quarter and year, in data table and chart form (currently histogram, with trend lines, but would love to get flashier....) The text strings encountered (typical fields are department names, project manager names, project statuses) in some fields can vary by month (not an infinite variety of strings but the list of strings can be added to at any time, and not all which existed last month will appear in a future month.) A simple example: show count and percent of all active projects, by status (Green, Yellow, Red), trended by month and by quarter and year. We also need counts, distributions and trends based on date comparisons (e.g. number of projects late per type over time.)
2. determining data intersections and charting them. For instance identification of specific projects for which certain artifacts (such as a charter, project plan) had been generated, which were managed by a particular IT group and were delivered on time. We also need to generate intersection charts (Venn diagram would be great) of: all projects delivered on time, all projects with charters, all projects delivered by a particular IT department.
The list goes on...
We need to generate our reports in an automated production manner and not have this production become a fulltime job. We also do not want to have to worry about missing a new string (e.g. a new department, new project manager) or receiving an error if a string that existed last month does not exist this month.
Looking forward to hearing from you! Thanks!