Big Data Analytics with Excel 2013
summary
Demo builds a pipeline from HDInsight (preview) Hadoop (Hive) to Excel 2013 using the Hive ODBC driver, loading four years of CSV weblogs into a Hive external table, where a simple count query takes 42.9 seconds and returns ~100,000 rows. A HiveQL query pulls a filtered result into a PowerPivot tabular model (workbook ~2.5 MB), creates relationships, hierarchies and DAX measures (customers, sessions), and produces a fast map visualization in Power View after in‑memory compression.
AI-written summary · about
chapters (14)
- 0:00Big Data Analytics intro
- 1:46What is Big Data and Hadoop
- 5:15Microsoft HD Insight
- 9:15HD Insight setup
- 10:19Hive table for web logs
- 16:48Querying Big Data challenges
- 18:56Excel to HD Insight via ODBC
- 21:05Power Pivot introduction
- 24:01Power Pivot in Excel 2013
- 27:12Power Pivot data loading
- 34:51Data model relationships
- 40:43Model hierarchies and measures
- 49:40Power View visualization
- 55:01Big Data modeling benefits
related talks
02h 05mUsing Hadoop with Excel and Power BI, Plus Data Discovery 101
18mEmpowering Business Through Data
58mProductivity Revolution in Excel
01h 01mDiscover, Manage, Analyze, and Visualize Your Data with Power BI
01h 04mThe Art of Prototyping Analytics
20mConnect Excel to Power BI data with Live Connected Tables
02h 05mBig Data and the Data Lake from the Analyst Perspective
43mFrom Power BI to Excel - The best of two worlds