Databricks Notebook Templates

SQL

• Zur Übersicht der SQL-Notebooks

Data Sets

• Zur Übersicht der Datensätze

Applied Analytics

• Fallstudie Teil 1 - Verkaufsanalysen (HTML)
• Fallstudie Teil 1 - Verkaufsanalysen (Source)
• Template - Campusbier 1.0 - Vorbefragung (HTML)
• Template - Campusbier 1.0 - Vorbefragung (Source)

WS 20/21

• What is SQL and what can it do? (including Chicago Sex Offenders Data) (Source)
• What is SQL and what can it do? (including Chicago Sex Offenders Data) (HTML)
• Template für Übung: Deskriptive Analysen mit SQL (HTML | SQL)

Big Data Analytics

• Amazon Reviews Template (HTML)
• Amazon Reviews Template (Source)
• Twitter Data Template (HTML)
• Twitter Data Template (Source)
• Mars Twitter Data Template (HTML)
• Mars Twitter Data Template (Source)
• Arrays mit SQL abfragen (HTML)
• Arrays mit SQL abfragen (Source)
• Texte für SQL Analyse vorbereiten (HTML)
• Texte für SQL Analyse vorbereiten (Source)
• Themen in Texten identifizieren (HTML)
• Themen in Texten identifizieren (Source)
• Text Analytics mit Azure ML (HTML)
• Text Analytics mit Azure ML (Source)
• Image Analytics mit Azure ML (HTML)
• Image Analytics mit Azure ML (Source)
• Hashtag Paare für Gephi exportieren (HTML)
• Hashtag Paare für Gephi exportieren (Source)

SS 2020

• Explore Tweets (HTML)
• Explore Tweets (SQL)
• Twitter Data Import Template (HTML)
• Twitter Data Import Template (SQL)
• Search in Text with SQL (HTML)
• Search in Text with SQL (SQL)
• Date and Time with SQL (HTML)
• Date and Time with SQL (SQL)
• Arrays with SQL (HTML)
• Arrays with SQL (SQL)
• NLP with SQL - Prepare Data (HTML)
• NLP with SQL - Prepare Data (SQL)
• Extract and analyze emojis (HTML)
• Extract and analyze emojis (SQL)
• Load data from Google Spreadsheets (HTML)
• Load data from Google Spreadsheets (SQL)
• Word Clouds with Python (HTML)
• Word Clouds with Python (PYTHON)
• Visualizations with Python (HTML)
• Visualizations with Python (PYTHON)
• Clean-Up Databricks Files and Tables (HTML)
• Clean-Up Databricks Files and Tables (SCALA)
• Load Covid-19 Data from Our World in Data (HTML)
• Load Covid-19 Data from Our World in Data (SQL)
• NLP with Python and spaCy - First Steps (HTML)
• NLP with Python and spaCy - First Steps (PYTHON)
• Working with URLs (HTML)
• Working with URLs (SQL)
• Network visualization with D3.js (HTML)
• Network visualization with D3.js (SQL)
• Export hashtag pairs for visualization with Gephi (HTML)
• Export hashtag pairs for visualization with Gephi (SQL)

SQL Tutorial

• #1 - Der SELECT-Befehl

Empirisches Arbeiten

• Template - Orangenlimonade (HTML)
• Template - Orangenlimonade (Source)
• Template - Agrar@Twitter (HTML)

• Template - Agrar@Twitter (Source)

• 2 - Machine Learning - Beispiele
• 3 - Text Analytics

WS 20/21

• Template für das Laden eurer Tweets (HTML | SQL)
• Erste Schritte mit SQL am Beispiel von Tweets (HTML | SQL)

Information Management

Notebook Templates

• Databricks Notebook - Template - Crimes in Chicago 2018
• Databricks Notebook - Template - Wine Reviews
• Databricks Notebook - Template - Craft Beer
• Databricks Notebook - Template - Simpsons
• Databricks Notebook - Template - Beer Sales 1.0 (HTML)
• Databricks Notebook - Template - Beer Sales 1.0 (Source)

Illustrative Notebooks

• Example Notebook - SQL Joins
• Subqueries and Window Functions

Case Study Templates

• Template Case A: Crimes in Chicago
• Template Case B: Crimes in LA

Web Engingeering Examples

• Google Maps Example I

Databricks Notebooks:

Fallstudie

• Databricks Notebook - Template Phase 1
• Databricks Notebook - Template Phase 2
• Databricks Notebook - Template Phase 3
• Databricks Notebook - Template Phase 4

Übungen

• Databricks Notebook - Beispiele auf dem 2. Termin
• Databricks Notebook - Beispiele auf dem 3. Termin
• Databricks Notebook - Beispiele auf dem 4. Termin
• Databricks Notebook - Beispiele auf dem 5. Termin