Relational Databases and EDW data

July 10-12, 2017 
(Instrutor: Vikrant Deshmukh and Kathy Sward)

  1. SQL fundamentals – Kathy’s online course
  2. Data warehousing
    1. Data modeling – structures, approaches, schools of thoughts
    2. Provenance – extract, transform & load (ETL)
    3. Quality
    4. Metadata
    5. Vocabularies
  3. Datasets
    1. Regulatory – brief overview
    2. Requirements analysis
    3. Source hierarchies
    4. Queries
    5. Summary reports
  4. Business intelligence
    1. Platforms
    2. Tools & use-cases
  5. Longer exercises with actual data requests.