Big Data Analytics with Excel 2013

on YouTube ↗58m

" 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)

1. 0:00Big Data Analytics intro
2. 1:46What is Big Data and Hadoop
3. 5:15Microsoft HD Insight
4. 9:15HD Insight setup
5. 10:19Hive table for web logs
6. 16:48Querying Big Data challenges
7. 18:56Excel to HD Insight via ODBC
8. 21:05Power Pivot introduction
9. 24:01Power Pivot in Excel 2013
10. 27:12Power Pivot data loading
11. 34:51Data model relationships
12. 40:43Model hierarchies and measures
13. 49:40Power View visualization
14. 55:01Big Data modeling benefits

" related talks

• 02h 05mUsing Hadoop with Excel and Power BI, Plus Data Discovery 101Andrew J. Brust · PASS Business Analytics Conference 2015
• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 58mProductivity Revolution in ExcelAvi Singh, Purna Duggirala · PASS BA Marathon 2015
• 01h 01mDiscover, Manage, Analyze, and Visualize Your Data with Power BIMiguel Martínez · PASS Business Analytics Conference 2015
• 01h 04mThe Art of Prototyping AnalyticsKen Raetz · PASS Business Analytics Conference 2015
• 20mConnect Excel to Power BI data with Live Connected TablesChris Webb · SQLBits 2024
• 02h 05mBig Data and the Data Lake from the Analyst PerspectiveScott Shaw · PASS Business Analytics Conference 2015
• 43mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure Virtual 2021