Course Organization
Vlastislav Dohnal
PA220: Database systems for data analytics
14.12.2022 PA220 DB for Analytics1
Course Overview
• Overview of data warehousing
• Planning a data warehouse
• Modelling your data for BI
• Querying your data
• Tuning and physical optimization
• ETL – getting your data into a data warehouse
• Case Study
• Novel technology (e.g., for real-time BI) – Apache Hive
14.12.2022 PA220 DB for Analytics 2
Course Organization
• Lectures:
• slides – available for studying at anytime
• Assignments:
• 4 home assignments with optional online consultation
• consultations scheduled during lectures – see the interactive syllabus in IS
• grading also defined there
• Exam:
• written exam – about 6 tasks to solve (open answer)
• Evaluation:
• composite of assignment result (max. 40 points) and exam (max. 80 points)
• for passing – at least 60 points in total
14.12.2022 PA220 DB for Analytics 3
Practice
• PostgreSQL
• www.postgresql.org
• may use you own installation or a virtual machine on Stratus@FI
https://www.fi.muni.cz/tech/unix/stratus.html
• Microsoft Power BI Desktop
• https://powerbi.microsoft.com/en-us/desktop/
• install locally on your computer
14.12.2022 PA220 DB for Analytics 4
Sources
• Textbooks:
• Ralph Kimball et al.: The Data Warehouse Lifecycle Toolkit. Wiley Publishing, Inc.,
2008.
• William Inmon: Building the Data Warehouse. John Wiley and Sons, 1996.
• Christian Jensen et al.: Multidimensional Databases and Data Warehousing. Synthesis
Lectures on Data Management. Morgan & Claypool, 2010.
• Journal paper:
• Mark Levene and George Loizou: Why is the Snowflake Schema a Good Data
Warehouse Design? Information Systems, Elsevier, 2003.
• Courses:
• Data Warehousing – Jens Teubner, TU Dortmund
• Data Warehousing and Data Mining – Johann Gamper and
Mouna Kacimi, Univ. Bolzano
• Data Warehousing and Data Mining Techniques – Wolf-Tilo Balke,
TU Braunschweig
14.12.2022 PA220 DB for Analytics 5