...
oData is a standard for sharing Analytics data that is widely supported by Analytics software editors, such as Microsoft Excel, Microsoft PowerBI, Tableau…
Accessing the oData source from an Analytics tool
Wedia exposes the “raw” data that are used to build the analytics dashboard in an API endoint :
...
You can try it in our demo system : https://club-wed.wedia-group.com/api/wedia/analytics/odata/
Securing who can access the analytics data.
These data may contain private information, and you can set up who can access them.
...
Either this is secured by a list of roles Ids (4, 27 in our screenshot), or by user logins (comma separated), or both.
Starting with simple CSV file exports
In a vast majority of cases, an Excel file with the raw data export is sufficient. The oData API offers a simple system to publish raw data as CSV files, and it is a good starting point to get acquainted with the API.
...
This can be tested “live” by using the “Try it out” button, that will show a form where parameters can be filled to generate a proper endpoint :
...
In testing mode :
...
Connecting Excel with the oDATA source
The Microsoft Excel “Data” tab offer a way to connect to a oData source :
...
Only keep te first 150 first lines
Remove some columns (id, “session_type”)
Add conditions on columns value
etc.
...
Connecting PowerBI with the oDATA source
The Microsoft PowerBI desktop software can connect to a oDATA source :
...