Using OData to analyze your Qorus activity

In Hub Central, you have the ability to create a username and password to access an OData service that is specific to your Qorus implementation.

Within this OData feed, you'll find tables that contain detailed information around user activity, collaboration and content usage, including searches and inserts.

In this article, learn how to setup OData access and use it in Excel or in Power BI to explore your data in ways that meet your particular business requirements.

• How to set your OData credentials
• How to access and analyze your data in Excel
• How to access and analyze your data in Power BI

How to set your OData credentials

• To get started, login to Hub Central at the following link: https://www.qorushub.com/

• In the left nav, under 'Settings', click on 'Hub Management' and then go over to the OData tab:

• Next, create a username and password to access your OData feed, and click on 'Save' when you're ready:

• You should get a success message like the one below if your details have been saved successfully:

Now that you've setup OData access, you can use it in Excel, Power BI, or any other analytics software that supports OData, to create your own custom reports.

Back to the top

How to access and analyze your data in Excel

In Excel, go over to the 'Data' tab and then under the 'Get Data' drop down, choose 'From Other Sources' and then 'From OData Feed':

Then on the next screen, copy and paste the OData feed URL: https://api.qorushub.com/customer

Next, enter your OData username and password. Then on the following screen, select the table(s) you want to load to Excel on the left hand side of the screen, then click on 'Load':

To learn more about working with OData in Excel, click here.

Back to the top

How to access and analyze your data in Power BI

Connecting your OData feed to Power BI is very similar to the way it works in Excel.

First, select 'OData Feed' from the 'Get Data' menu: 

Then, copy and paste the OData feed URL in the box provided:  https://api.qorushub.com/customer

Next, enter your OData username and password. Then on the following screen, select the table(s) you want to load to Excel on the left hand side of the screen, then click on 'Load':

To learn more about Power BI and how to use it, visit the Power BI learning center here.

Back to the top