Section outline

    • During our first week, we will work together on a data project. Our goal is to forecast the Berlin visitors originating from the US. We will search for relevant data, create our first visualizations and try to forecast the development of visitors from the US.

    • Task
      • First we want to figure out who is visiting Berlin. What are the top residences of people visiting Berlin?
      • Try to find officially collected data covering who is visiting Berlin. Which time duration is covered by the data? How can you access this data? What is stored in these files?

      Since some German is helpful break up into groups of two making sure at least one person speak German.

    • The data is linked from https://www.statistik-berlin-brandenburg.de/archiv/g-iv-1-m. The linked page lists Excel files for each month starting 2009.

    • The files covered in this folder present the data available at https://www.statistischebibliothek.de/mir/receive/BBSerie_mods_00000050 but in a single CSV file for Berlin guests and residence for easy access. The data is also provided as SQLite files.