How to use Predictive Analytics for IT in PowerBI
This article will show you how to use static classification algorithms for ServiceNow (or any of our other solutions really) in the PoweBI desktop application to perform a simple basket analysis. We will use the Microsoft Quick Insights function to create a report, leveraging Northcraft solutions. This analysis is static and throw-away, but great for some initial data model exploration!
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: Open PowerBI
Step 2: Select ‘Get Data’
Step 3: Select ‘SQL Server Analysis Services database’ This is the Northcraft Analytics multi-dimensional database. The SQL Server relational database is called NCA_DW typically. Please log a support request at email@example.com to discuss the pros and cons of each.
Step 4: Select ‘Connect’
Step 5: 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 6: Select ‘Import’. Not ‘Connect live’ like usual.
Step 7: Select your multidimensional database (MDB) instance and corresponding cubes (typically the ITIL process area name)
Step 8: Select ‘INC – Incident Mangement’
Step 9: Select the cube associated with INC – Incident Management
Step 10: Open the ‘Incident’ folder
Step 11: We’re just going to collect some sample data. First, open the ‘Incident’ folder.
Step 12: We’re going to select ‘Average Time to Resolve’
Step 13: Next, select ‘Percentage of Incidents Meeting SLAs
Step 14: Open the ‘Counts’ folder
Step 15: Click the ‘Incidents Closed’ option
Step 16: Scroll down and select ‘INC – Incident Management’
Step 17: Click the ‘Hierarchy – Assignee’ option
Step 18: Next, we’re going to open the ‘Classification’ folder
Step 19: We’re going to get three options. First, ‘Subcategory’
Step 20: Then ‘Priority’
Step 21: And we’re also going to get ‘Category’
Step 22: Now open the ‘Configuration Items’ folder
Step 23: Next we’re going to open the ‘CMDB – Configuration Management’ to select a few more fields
Step 24: Scroll down to select ‘Manufacturer’
Step 25: ‘Model ID’
Step 26: And ‘Model Number’. Then click load.
Step 27: Wait for the data to load.
Step 28: Next, open a new table in the file.
Step 29: Now, we select all the options that we brought up earlier
Step 30: To make the data more useful, we’re going to filter out some of the ‘Not Specified’ fields
Step 31: Drag the Model ID field over to create a filter
Step 32: Change the filter type to ‘Advanced filtering’
Step 33: Set the filters to Show items when the value ‘does not contain’ . . .
Step 34: ‘Not Specified’ and apply the filter
Step 35: Now we’ll do that same thing to the ‘Subcategory’
Step 36: Drag it over to Filters again
Step 37: Again, change the filter type to ‘Advanced filtering’
Step 38: Again, filter out the items where the value ‘does not contain’ . . .
Step 39: ‘Not Specified’, and again apply the filter
Step 40: Next we click ‘Publish’
Step 41: Save the data in your files
Step 42: Publish the data to a destination of your choice. We’ll use “Demo”
Step 43: We’ll use ‘Demo’
Step 44: Select ‘Get Quick Insights to look at the results
Step 45: Next, select ‘Reports’ to see the report we just created.
Step 46: Hover over the lightbulb icon and select ‘Quick Insights’
Step 47: Now we’re able to look at all the data in a visually pleasing and dynamic arrangement with predictive analytics
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.