OData Tutorials with Excel PowerPivot
Posted by Austin Fossey
In case you missed this earlier post, Questionmark has an OData feed that allows users to get direct access to data in their Results Warehouse—the same data source that is used to drive the reports in Questionmark Analytics.
If you have not done so, I encourage you to check out our OData API for Analytics video to learn how to connect to the OData feed, import data and create a simple report.
There are three major benefits of having this access to the Results Warehouse data:
- You can grab your data anytime you wish to explore a new research question about your assessment results
- You can manipulate those data and run your own analyses or transformations in any way you see fit
- You can feed those data into your own reporting tools or many other programs that already consume OData
Of course, the only reason we create assessments and collect data is so that we can make informed decisions, and the data in the OData feed just come across in their raw state.
To help you make sense of the data, we are developing short video tutorials that walk through introductory OData examples using the free PowerPivot add on for Excel.
These tutorials will cover the following topics:
- Creating a response matrix with OData
- Using OData to analyze the distribution of correct choices in the items on an assessment
- Calculating a new variable in PowerPivot using the data from the OData feed
- Using OData to generate a list of scores for participants who took multiple forms of an assessment
We will announce these new videos in the blog in the coming weeks, and you will be able to find them in the Questionmark Learning Café.
If you have a research question that you think could be addressed with OData, please let us know! Your suggestion may lead to additional tutorials that will help other people expand their own research.