Table of Contents

Lessons

• Introduction
• Challenge 1: Identify your population
• Challenge 2: Inspect the population's relations
• Challenge 3:
  • New:
    • Import population with labels, birth years and gender (MD)
    • Clean up and prepare (SQL)
  • Old: Import population with labels, birth years and gender (RDF)
• Challenge 4 (da1): Distribution of the population in time
  • New: Prepare the data (MD)
  • Distribution by birth year and gender
• Challenge 5 (da2): Distribution of the population's births in space (and time)
  • Get the data
  • Prepare the data for the analysis (SQL)
  • Distribution by birth year and gender
• Challenge 6 (da3): Bivariate analysis of categorical variables and Chi-square test
  • Regions bivariate analysis (da3)
  • Countries bivariate analysis (da3-1)
• Challenge 7 (da4): Correspondence analysis
  • Explore occupations and fields (da4, MD)
  • Explore occupations and fields (da4, SQL)
  • Correspondence analysis (da4)
• Challenge 8 (da5): Multiple Correspondence Analysis (MCA)
  • Explore employers (da5, MD)
  • Explore employers (da5, SQL)
  • Multiple correspondence analysis (da5)
• Challenge 9 (da5): Clustering (MCA K-means, K-modes)
  • Explore clusters (da5, SQL)
  • K-Means MCA clusters (da5)
  • K-Modes clusters (da5)

Installation instructions & Co

• My first GitHub repository
• Install VS Code and GIT
• Install Fuseki