What is a data warehouse and why would you want one? Emily Morton-Owens @bradamant.

  • Published on
    01-Apr-2015

  • View
    215

  • Download
    3

Transcript

Slide 1What is a data warehouse and why would you want one? Emily Morton-Owens @bradamant Slide 2 Data warehouse Not for users Not operational or transactional Abstract/summary Normalized For analysis and strategy Slide 3 ETL: Extract, transform, load Correct granularity Ensure privacy Enforce consistency Examples: Holds data store Checkout summary Chat logs Operations data e.g. ILS ETL MAGIC Data warehouse Slide 4 Bridge silos ILS + demographics How much do Millennials use the library in comparison to their population in Seattle? EZproxy + academic department + publications How much do faculty access articles through the library by department? How does that correspond to the departments publishing output? Events+ e-materials Do people who check out e-materials come to events as much as people who check out print materials? Slide 5 Challenges Data problems that are unrelated Metrics that no one cares about Force people to agree on methods Slide 6 Wins Save time Let people do their own reporting More accurate Shared strategy

Recommended

View more >