Using Power View and Hadoop to Unlock Hidden Markets
summary
Uses Hadoop + Hive + Excel Power View to load CSVs from set‑top boxes, query via Hive ODBC, and analyze in PowerPivot. Works with one week of set‑top data (Jul 11–17 2012) aggregated at 5/15/60 minute buckets, discovers weekend peaks and large morning engagement. Defines engagement = viewed seconds / potential seconds and finds surprise results like Nick Jr showing ~92.6% engagement around 7 AM. Process exposes dirty records, scales by adding files, and the pipeline succeeds for exploration.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 2:08Big data challenges
- 8:53Unconventional data sources
- 12:23Relational databases vs big data
- 17:17Hadoop ecosystem
- 21:55Demo: Hadoop and Hive data load
- 26:55Traditional ETL pain
- 29:05ETL in Hadoop: ELT
- 32:00Formulating business questions
- 37:16Ideal vs real data sets
- 41:27Data cleansing in Hive
- 41:48Demo: Excel to Hive
- 47:07Visualizing with Power View
- 58:46Hadoop and Power View insights
- 59:30Resources for Hadoop
- 1:00:00Closing remarks
related talks
18mEmpowering Business Through Data
02h 05mUsing Hadoop with Excel and Power BI, Plus Data Discovery 101
01h 13mDiscover, Acquire, and Transform Your Data with Power Query
01h 35mDeep Dive into the Big Data Landscape
24mImprove your marketing reach using ...
45mRebooting your SME Data Analysis Strategy
56mSpark-driven Audience counting
21mPutting big data self-service analytics in the hands of business people