Microsoft Data Explorer for Excel: Data Discovery & Transformation
summary
Demonstrates an Excel add‑in that finds and previews 2 million Wikipedia tables, connects to SQL, Hadoop/HDInsight, web APIs and CSVs, and applies stepwise transforms (hide, type, merge, unpivot, fill down) as a reproducible query. Shows loading cleaned data into the xVelocity load to data model, geoflow maps from a 1,100‑row earthquake CSV, and a user‑defined function to fetch pages that stitches multiple web pages into one table; large‑file preview (120 GB sample) remains interactive.
AI-written summary · about
chapters (12)
- 0:00Data Explorer for Excel
- 1:25Microsoft data platform fit
- 6:00Key features and audience
- 8:30Data sources and connectivity
- 10:14Discovering public data
- 16:44Connecting external data
- 24:18Merging and transforming datasets
- 35:58Handling JSON data
- 44:02Web data scraping
- 51:36Authentication and refresh
- 56:28Roadmap and error handling
- 58:15Closing remarks
related talks
01h 13mDiscover, Acquire, and Transform Your Data with Power Query
18mEmpowering Business Through Data
57mStop waiting to explore your data: use Azure Data Explorer!
02h 05mUsing Hadoop with Excel and Power BI, Plus Data Discovery 101
45mRebooting your SME Data Analysis Strategy
01h 04mBest Practices for Collecting and Analyzing Data with Power Query and Excel
53mThe Pain and Glory of Data Preparation
11mMicrosoft & Power BI