Notes: Session 2: Analytical data architecture

Note

TODO

Refer to the Davenport (2006) case: competing on analytics requires organizations to go beyond simple descriptive statistics. As such, traditional DWH may be the (historical) foundation for analytics.

Clarify: OLTP <-> OLAP OLTP -> ETL -> DWH -> OLAP

Distinguish fact and dimension tables

Learning objective: writing SQL queries!?

Illustrate: OLAP as a “systems approach”, notebooks as a more flexible data science approach

Rotating hypercube: similar to rotating in tidy-data preparation?

Extract exercises?

TBD: complete the exercise on paper? provide a PDF version?

References

Davenport, T. H. (2006). Competing on analytics. Harvard Business Review, 84(1), 98–107. https://cs.brown.edu/courses/cs295-11/competing.pdf