> For the complete documentation index, see [llms.txt](https://redi-school-1.gitbook.io/teacher-applicant-hub/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://redi-school-1.gitbook.io/teacher-applicant-hub/data-ai-track/data-analytics-online.md).

# Data Analytics (Online)

{% hint style="warning" %}

### **🚨** L**ocation Priority May Affect Volunteer Placement**

Keep in mind that because in-person support is often necessary, we prioritize volunteers who **are located in Germany**, especially near **Berlin or NRW** where our organization operates.
{% endhint %}

### 📚 Course Details

* **Schedule:** Monday & Wednesday, 19:00–21:00 (Online)
* **Format:** Live online lectures with practical exercises. 
* **Final Outcome:** Mini Project & Final project.

***

### 👥 Volunteer Roles

* **Session Owner:** Leads classes and introduces new concepts.
* **Session Assistant:** Supports students and manages Zoom logistics during class.
* **Backup Teacher:** Steps in when regular teachers are unavailable.

***

### 🧩 Topics Covered

* SQL & Data Querying
  * Why SQL? Introduction to SQL and BigQuery
  * SQL in BigQuery: Basic Functions and Joins
  * SQL: Continuing with Joins & Introduction to Looker (Query-to-Graph)
  * SQL Advanced: Date, Aggregate, and Window Functions
  * SQL Visualization: Theory and Practice (Dashboarding)
  * SQL Review: Key Concepts and Feedback-Based Review
* Python for Data Analysis 
  * Intro to Pandas
  * Pandas Practice: Introduction Session
  * Pandas Data Transformation
  * Pandas Data Transformation & Joins (Exercises)
  * Pandas Data Cleaning & Handling Missing Data I
  * Pandas Data Cleaning & Handling Missing Data II
* Statistics & Experimentation
  * Descriptive Statistics
  * Statistics: Joint PDF & Conditional Probability
  * Bayesian Statistics
  * A/B Testing (Bayesian)

***

### 🎓 Final Project

At the end of the course, students complete a **final project** and give a **presentation** demonstrating their learning.

The project consists of applying real world database in a data analysis project.

Take a look at **an example** of what learners will have achieved by the end. 👇

[Heart disease symptoms analytics](https://drive.google.com/drive/u/4/folders/116VCgLbRNy7hQH0IWwOp2MghLFTsKH0X)

<div data-with-frame="true"><figure><img src="/files/s37XKVncRDlXVxwHfFMR" alt="" width="375"><figcaption></figcaption></figure></div>

***

<h2 align="center"><a href="/pages/0kchzzWzyDzTftgInaI5#volunteer-teacher-recruitment-are-limited-but-more-spots-will-be-reopened-on-thursday-january-8th-at"><mark style="color:orange;background-color:orange;">👋 Book your Meet &#x26; Greet Call!</mark></a></h2>

***

Thank you for supporting the ReDI students 🧡

### More info:

* Find out more [About ReDI](/teacher-applicant-hub/about/about-redi-school.md)
* Find out more [About DCP](/teacher-applicant-hub/about/dcp-online.md)
* Find out more [About this Course](https://www.redi-school.org/data-analytics/hamburg/dcp/data-analytics)
* Find out about our [How to Volunteer](/teacher-applicant-hub/about/your-volunteer-journey.md)

### FAQ

* Check out: [I can't teach tonight](broken://pages/wvc6VmyUFvn9NFRtwtJU), [I am dropping out](broken://pages/eUzENWHDhDiXk5y8XwYo), [I feel uncomfortable](broken://pages/yBP7yF6y0QPEZ9r2aK2L).
* In case you have questions, write an email to <dcp-volunteering@redi-schooll.org>.