Slides

  • Intro (pdf)
  • Relational Data Model (pdf)
  • Spreadsheets versus Relational Data Model (pdf)
  • SQL Intro (pdf)
  • SQL Join (pdf)
  • SQL Aggregation (pdf)
  • SQL Subqueries (pdf)
  • SQL Case Studies (pdf)
  • Business Performance Management (pdf)
  • Business Intelligence (pdf)
  • ETL - Example (pdf)
  • Procurement Analytics (pdf)
  • Tableau Intro (pdf)
  • Machine learning Intro (pdf)
  • Machine learning Trees (pdf)
  • Machine learning classifier metrics (pdf)

Videos

External Ressources

  • SQL Learning Sites (link, link, link)
  • DB Visualizer User guide (link)
  • Tableau Desktop and Web Authoring Help (link)
  • Tableau Choose the Right Chart Type for Your Data (link)
  • Tableau Tutorial (link)
  • Python Cheat Sheet (link)
  • Visual Numpy (link)
  • Visual Pandas (link)
  • The Mechanics of Machine Learning (link)
    • A First Taste of Applied Machine Learning (link)
    • Exploring and Denoising Your Data Set (link)
    • Categorically Speaking (link)

Training Examination

  • Exercises (link)
  • Exercises with Solution (link)
  • Keine Stichwörter