How to Build a Change Management Dashboard to Examine Changes Closed by Month in Excel
In this article you will use Excel to create a table showing the changes that are closed every month by an assignee. This table will have drill-down capabilities and provide you with important metrics that will increase your understanding of change management.
To learn more about Northcraft, take a look at our Resources page.
This video provides step-by-step instruction, or you can follow the steps listed here.
Step 1: To begin, select your proper database
Step 2: Select your multidimensional database (MDB)
Step 3: Select a ‘Change Management’ cube
Step 4: Now click on the ‘Next >’ button
Step 5: Click on the ‘Always attempt to use this file to refresh data’ checkbox
Step 6: Now click on the ‘Finish’ button
Step 7: To finish importing the data, click on the ‘OK’ button in the pop-up
Step 8: Now click on the search field and type in ’changes closed’
Step 9: Click and hold on the ‘Changes Closed’ field
Step 10: Drag it into the ‘Values’ area
Step 11: Now click on the ‘Clear Search’ button so we can use the search field again
Step 12: Now click on the search field and type in ’status reason’
Step 13: Scroll down to the bottom of the search
Step 14: Click and hold on the ‘Status Reason’ field
Step 15: Now drag it down into the ‘Rows’ area
Step 16: Now we’re going to do a quick sort on the chart to arrange it. Right-click on one of the cells under ‘Changes Closed’
Step 17: Now select ‘Sort > Sort Largest to Smallest’
Step 18: Now click on the ‘Clear Search’ button
Step 19: Now click on the search field again and type in ‘submit date.month’
Step 20: Now click and hold on the ‘Submit Date.Month’ field
Step 21: Now drag it down into the ‘Columns’ area
Step 22: Now click on the ‘Clear Search’ button
Step 23: Now click on the search field and type in ‘hierarchy – assignee’
Step 24: Click and hold on the ‘Hierarchy – Assignee’ field
Step 25: Now drag it down into the ‘Rows’ area
Step 26: Now we’re going to open all the way down through the changes closed. We’re going to click the ‘+’ symbol next to the ‘Atlanta Journal Constitution’ cell and keep clicking it until we get to the bottom.
Step 27: Now right on one of the cells at the bottom of the hierarchy so we can add more fields using the OLAP tools.
Step 28: Now go to the top of the page and select OLAP Tools
Step 29: Scroll down a bit and select the ‘Priority’ field
Step 30: Bring the field into the display by clicking the ‘>’ button
Step 31: We can bring in any number of fields, but we’ll just stick with Priority for this example. Now click on the ‘OK’ button
Step 32: Now we’ve successfully added the Priority section to the table, and the table shows all the changes made by assignee per month, along with any additional fields we’d like to add
Support by website
You can obtain technical support from Northcraft Analytics 24 hours a day, 7 days a week at https://northcraftanalytics.desk.com. From this website, you can:
- Find the most current information regarding Northcraft Analytics products.
- Manage your account information
- Upload documents for content sharing exchange.
- View shared documents from other users.
- Order or download product documentation.
- Download products and maintenance releases.
- Report an issue or ask a question.
Support by telephone or email If you need technical support either by phone or email:
Call (+1) 800 565 1375
or by email using:
Every effort has been made to make this as complete and as accurate as possible, but no warranty or fitness is implied.
The information is provided on an “as is” basis. The author and Northcraft Analytics, LLC, shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this manual or from the use of the discs or programs that may accompany it.
Copyright © 2010 Northcraft Analytics LLC. All Rights Reserved.
Trademark Legal Notice. All product names, trademarks and registered trademarks are property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.