S0_Content.py

# Databricks notebook source
# MAGIC %md
# MAGIC # Data Analytics & Manipulation Class Schedule

# COMMAND ----------

# MAGIC %md
# MAGIC ### Week 1: Python Data Fundamentals
# MAGIC 
# MAGIC Made for Jupyter or Kaggle Notebooks

# COMMAND ----------

# MAGIC %md
# MAGIC ### Week 2: Data Toolbox (Fundaments, Pandas, SQL)
# MAGIC 
# MAGIC Made for Databricks Notebooks

# COMMAND ----------

# MAGIC %md
# MAGIC #### Lesson 1: Tables Fundamentals & SQL Basics

# COMMAND ----------

# MAGIC %md
# MAGIC #### Lesson 2: Pandas Fundamentals & Analytics Concpets

# COMMAND ----------

# MAGIC %md
# MAGIC #### Project 1: Data Hands-On
# MAGIC <br>
# MAGIC 1. Find any open dataset online and create an SQL Table for it in a Database, in Databricks.
# MAGIC 
# MAGIC 2. Analyse the data using pandas and write down any findings or intersting things you think you can do with it, For Example:
# MAGIC   - We can use Linear Regression on this dataset to predict oil price <br>
# MAGIC   - We can create a dashboard from this dataset to track bird movement <br>
# MAGIC   - I learned about different kinds of foods <br>
# MAGIC   - Be creative!
# MAGIC   
# MAGIC **Resources:** 
# MAGIC You can find a variety of different open datasets from the following sites:
# MAGIC 1. Dubai Open Data: https://www.dubaipulse.gov.ae/data/category
# MAGIC 2. UAE Federal Open Data: https://bayanat.ae/
# MAGIC 3. Kaggle: https://www.kaggle.com/datasets

# COMMAND ----------

# MAGIC %md
# MAGIC ### Week 3: Data Application (Manipulate & Visualize Data)
# MAGIC 
# MAGIC Made for Databricks Notebooks

# COMMAND ----------

# MAGIC %md
# MAGIC ### Week 4: Further Data Application (Manipulate using Spark & Visualize Maps)
# MAGIC 
# MAGIC Made for Databricks Notebooks

# COMMAND ----------