1 / 6

What is a data warehouse

What is a data warehouse. and why would you want one?. Emily Morton-Owens @ bradamant. Data warehouse. Not for users Not operational or transactional Abstract/summary Normalized For analysis and strategy. ETL: Extract, transform, load. Correct granularity Ensure privacy

makana
Download Presentation

What is a data warehouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

  2. Data warehouse • Not for users • Not operational or transactional • Abstract/summary • Normalized • For analysis and strategy

  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

  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 department’s publishing output? • Events+ e-materials • Do people who check out e-materials come to events as much as people who check out print materials?

  5. Challenges • Data problems that are unrelated • Metrics that no one cares about • Force people to agree on methods

  6. Wins • Save time • Let people do their own reporting • More accurate • Shared strategy

More Related