Product Manager Dashboard

Brent Christenson
MBA 614

Executive Summary
For my VBA project I developed a “Product Management Dashboard” for a local software as a service provider (SAAS). Since I interned with SAAS over the summer, I was given permission to perform this project. I will refer to this company as SAAS to protect its identity. I am under a non-disclosure agreement to not share propriety information collected by this tool, but I have documented to process to demonstrate how the dashboard works.
SAAS is a leader in its industry. The two existing SAAS products, SAASHome and SAASPro are managed by the Product Management department. As part of this management, 6 different surveys are deployed each month to users of the SAAS. Survey administration is provided by a third party, Question Pro. These monthly surveys are a basic Net Promoter survey. The traditional Net Promoter survey asks two questions: First, “How likely is it that you would recommend our company to a friend or colleague?" Respondents select from 10 to 0 with ten being “highly likely to recommend” and zero as “would not recommend”. Second, is a question that asks the respondent to elaborate on their rating. SAAS also asks some follow up questions on customer support, ease of use, and overall satisfaction.
The Product Management Dashboard solves the problems of retrieving, interpreting, organizing, and combining the results of the 6 monthly surveys into one central dashboard. In essence, not only does the dashboard save time, but also creates a standard in which the survey results can be viewed and measured by the company. Hopefully, this will help streamline the information that will lead to better decision making.

http://gove.net/courses/excel/projects/Brent/PMDashboard.pdf

excel files have been withheld due to NDA with SAAS company