In Microsoft Excel 2013, you can create power views using the OData information.
Note: If this is your first time using OData in Excel, click Options and make sure you have the Power View add-in. Select "COM Add-ins." Then, select Power View and Microsoft Office PowerPivot for Excel 2013 and click OK.
From the Data tab, select From Other Sources/From OData Data Feed.
Click Next.
Check the "ODataQuery.ashx" checkbox.
Click Next.
You can enter a description and change the name if you prefer.
Click Finish, and then click OK to import the data.
On the Import Data screen, select "Power View" and click OK. You can now use Excel to create charts and dashboards of your data.