Feed Your Data! OData Data Feeds for PowerPivot Users
summary
Demos pull a public Excel survey from Office 365 into Excel, PowerPivot and Data Explorer via OData, with a live run capturing 48 responses despite Wi‑Fi hiccups; country names get standardized by calling Wolfram Alpha and flag images are fetched from Bing so Power View can show maps and flags (demo falters but process is shown). Also shows OData query patterns ($select, $filter, metadata), uses visual studio light switch to publish feeds and the Azure Marketplace and Reporting Services R2 as sources.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 1:05Internet reliance and disclaimers
- 3:32Audience survey setup
- 11:35OData for PowerPivot
- 17:09OData data sources
- 21:26OData in Excel and PowerPivot
- 25:53Demo: Import survey data
- 29:01SharePoint and survey mashup
- 31:55Reporting Services integration
- 35:53Cleaning data with Azure
- 45:04Power View reports
- 50:17OData query basics
- 54:19OData URL tools
- 55:03Custom OData feeds
- 59:19Summary
- 1:00:50Q&A
related talks
18mEmpowering Business Through Data
01h 13mDiscover, Acquire, and Transform Your Data with Power Query
01h 04mBest Practices for Collecting and Analyzing Data with Power Query and Excel
45mRebooting your SME Data Analysis Strategy
54mUsing Premium Data for Analysts
54mWhat's new in Power Query in Power BI, Fabric and Excel?
11mMicrosoft & Power BI
57mStop waiting to explore your data: use Azure Data Explorer!