~/talk

Modern Data Warehousing Strategy

on YouTube 01h 01m
Talkat PASS Business Analytics Conference 2013 · 2013-04-10..04-12· [databases, data-engineering]

speaker

name:Marco Russo
links:none on file

resources

video:https://youtu.be/Y9J_5VRr9k4
slides:none on file

summary

Argues that the data warehouse remains essential while Power Pivot, Data Explorer and Hadoop create new pressures and opportunities; recommends a hybrid SQL‑BI architecture mixing Inmon (normalized warehouse, natural keys) and Kimball (star marts), using a Hadoop or relational staging/mirror area, views to lock contracts, columnar engines for fast queries, and central ETL for complex quality rules while allowing self‑service tools limited, auditable transformations.

AI-written summary · about

chapters (10)

  1. 0:00Modern data warehousing intro
  2. 3:36Threats to classical warehouses
  3. 13:05Classical warehouse approaches
  4. 23:52Kimball methodology
  5. 30:39SQL BI hybrid explained
  6. 35:57Modern warehouse threats
  7. 44:55Self-service tools
  8. 53:07Optimizing data access
  9. 57:23Big Data in warehousing
  10. 59:08Warehouse future

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.