Change Approval Bottleneck Analysis
In this article you will use PowerBI to create a dashboard to analyze bottlenecks using Change Approval. This dashboard will have drill-down capabilities and provide you with important metrics that will increase the understanding of the specific strengths and weaknesses in each area of business.
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: Begin by opening up PowerBI and type in your on-premises server (xxxxx@domain) or SaaS server name (ex: https://public.xxxxxxxxx.com) to the Server field and select ‘OK’
Step 2: In the ‘Navigator’ section, select the ‘ITIL Metric for ITSM 4075 – RemDash’ multidimensional database (MDB)
Step 3: Select the ‘CHG – Change Signature’ cube
Step 4: Select ‘Ok’
Step 5: Move over to the ‘Visualizations’ section and select the ellipsis symbol.
Step 6: Select the first selection ‘Import from file’
Step 7: Select ‘Import’ at the pop-up
Step 8: To get the visualization we need, use the file that holds Super Bubbles
Step 9: Select ‘Ok’ in the pop-up.
Step 10: Open up a new ‘Super Bubble’ visualization.
Step 11: Open the ‘Change Signature (Measures)’ folder
Step 12: Select the ‘Change Signature Count’ field
Step 13: Next open the ‘Change Signature’ folder
Step 14: Next select the ‘Full Name’ option
Step 15: Next, open up a ‘Slicer’ visualization
Step 16: Next select the ‘Approval Status’ option
Step 17: In the ‘Approval Status’ Slicer select ‘Pending’ to change the Super Bubble
Step 18: Next open up a ‘Table’ visualization
Step 19: Next open up the ‘CHG – Change Management’ folder
Step 20: Select the ‘Hierarchy – Product’ option
Step 21: Under the ‘Visualizations’ section close out the fourth selection under ‘Values’, ‘CHG – Change Management’ [Hierarchy – Product]’
Step 22: Also close out the value immediately above it.
Step 23: Finally, select ‘Change Signature Count’
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.