In the last memo, netmagic users shared query within the netmagic community. The queries were designed to run over tables in worksheets that the user, both sharing-user and shared-user, already had –-having downloaded the excel file with the “source” snapshot of listing data. This model works fine, for teams of rea`ltors perhaps. It doesn’t work so well with realtors and homeowners.
So in the next trial, we make a workbook that references a public source – of the snapshot data. That is, we reference the odata feed (of the same data snapshot).
So, as a non-realtor to whom a realtor has granted access to the odata feed (of yesterdays snapshot of listing data, from BARS), we get our own local copy of the source data:
This process of course avoids having to download an excel file full of data sourced to an ODBC connection (that the typically users will NOT have). Immediately, we see the worksheet fill with the preview rows, and then the odata source is consulted:
we can now share to share our data, once we have netmagic/office use odata to sort and filter to look at properties measured in lot square footage.
one see then (and note what happens less than perfect data entry is treated this way)
we then share our BI query (over an odata source, that tied to a netmagic/sharepoint hosted excel file with table)
we see that niki has access to support170s work, filtering and sorting suitably for their professional conversation.
Niki is a power excel user, and loads the data into power pivot (the full cube-oriented data analytics tool that used to come only with high end servers).