Forum Discussion

a495760's avatar
a495760
Frequent Visitor
7 years ago
Solved

Analyze ServiceNOW Data Exported to Excel

Hello,   I've been doing data analytics on the incidents for my support groups queue through exportation from ServiceNow into Excel and creating Pivot Tables. I do feel pretty comfortable and confi...
  • a495760's avatar
    a495760
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

a495760,

Yes. Single sign on is currently not supported for ServiceNow in Power BI, there is an idea about this issue, please vote it up.

In your scenario, you can directly connect to the Excel with pivot tables in Power BI Desktop using File->Import->Excel workbook contents option.


And you can connect to the other Excel files using Excel connector in Power BI Desktop, then create report and publish the report to Power BI Service.


Regards,
Lydia

  • a495760's avatar
    a495760
    Frequent Visitor
    7 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      a495760,

      What features and functions do you refer to? Could you please give an example?

      Regards,
      Lydia

      • a495760's avatar
        a495760
        Frequent Visitor
        7 years ago

        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.