Einführung

• Einführung in Business Intelligence

• First steps in Markdown

SQL

• Datenexploration (Selektieren, Ordnen und Filtern)

• Datentypen und Datentransformationen

• Gruppieren und Aggregieren

• Tabellen verbinden (Joins)

• Tabellen modifizieren

• Subqueries

• Microsoft Azure SQL Database

Literatur:

DeBarros, A. (2018). Practical SQL: A Beginner’s Guide to Storytelling with Data. No Starch Press.

R for Data Science

• First Steps in R

• Introduction to Data Science with R

• Basic Analytics in R

• Data Exploration in R

• Correlation Analysis in R

• Natural Language Processing with R

• Advanced Programming in R

• Erstellung von interaktiven Tutorials in R.

Literatur:

• Wickham, H., & Grolemund, G. (2016). R for data science: import, tidy, transform, visualize, and model data. O’Reilly Media, Inc.

• Wickham, H. (2019). Advanced r. Chapman and Hall/CRC.

• Silge, J., & Robinson, D. (2017). Text mining with R: A tidy approach. “O’Reilly Media, Inc.”

• Xie, Y. (2019). Bookdown: Authoring Books and Technical Documents with R Markdown. Chapman and Hall/CRC.