If this is your first time using OData in Excel, click File > Options and make sure you have the Power View add-in. Select "COM Add-ins." Then, select Microsoft Office Power View for Excel and Microsoft Office Power Pivot for Excel and click OK
  1. From the Data tab, select Get Data > From Other Sources > From OData Feed
  2. Paste the URL you got from your query in Altru
  3. Click OK
  4. Click Basic
  5. Enter your Credentials
  6. Click Connect
  7. Click Arrow for the Load button > Choose Load To
  8. Choose the option for PivotTable Report or PivotChart
Note: If this is an additional query for an existing report, choose Existing Connection and mark the checkbox to Add this data to the Data Model
  1. Click OK 
You can now use Excel to create charts and dashboards of your data