Forum Discussion
Analyze ServiceNOW Data Exported to Excel
Hi Anonymous,
I guess that I am trying to replicate the features and functionality of the plugin since I am curently unable to utilize it in my environment. I am essentially trying ot learn Power BI on my own for a self-assigned project within my team. We are an operations based team and currently utilize no information from ServiceNow to take advantage of Incident Management Metrics or KPIs. I've struggled to find some examples online that are either tutorials or examples of what I'm trying ot accomplish. I've gotten to the point that I can connect my Power BI instance to our Oracle database. I've setup a query to pull in the interesting data; however it came into one table. So I've been looking at making multiple queries to create different tables for modeling purposes. Now that I've got the data formatted correctly, I'm trying to figure out the best way to visualize it through reports and a dashboard.
I was able to get my Power BI connected to our internal Data Warehouse. Is there a way that I can recreate the same features and functions provided by the ServiceNow Plugin on a manual basis?
I am not familar with the different visuals and how Power BI interprets and reacts to the data.
a495760,
What features and functions do you refer to? Could you please give an example?
Regards,
Lydia
Hi Anonymous,
I guess that I am trying to replicate the features and functionality of the plugin since I am curently unable to utilize it in my environment. I am essentially trying ot learn Power BI on my own for a self-assigned project within my team. We are an operations based team and currently utilize no information from ServiceNow to take advantage of Incident Management Metrics or KPIs. I've struggled to find some examples online that are either tutorials or examples of what I'm trying ot accomplish. I've gotten to the point that I can connect my Power BI instance to our Oracle database. I've setup a query to pull in the interesting data; however it came into one table. So I've been looking at making multiple queries to create different tables for modeling purposes. Now that I've got the data formatted correctly, I'm trying to figure out the best way to visualize it through reports and a dashboard.