/world-indicators-etl

World Indicators from Google BigQuery Postgres | ETL Project

Primary LanguageJupyter NotebookMIT LicenseMIT

World Indicators

In this project I used Open Data available from Google's BigQuery Public Database to create a Postgres Database. The goal was to link the datasets by Country which would make for quick analyses. The datasets were quite dense which became an issue for simple relational indices to be created, this led me to realize I was on the path to building a data lake, which was out of scope.

Getting Started

This project consists mainly of Jupyter notebooks with a Postgres Database. Run Extract.ipynb first then Load.ipynb

Prerequisites

pip install pandas

Authors

License

This project is licensed under the MIT License - see the LICENSE file for details