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
- without solutions (link)
- with solutions (link)
