World Economy Data Warehouse

Ten macroeconomic indicators integrated from seven sources across six acquisition formats — REST JSON, bulk CSV, bulk TSV, a scraped HTML table, an Excel workbook and a SQL database — then modelled as a star schema and published as a static analytical mart. Where sources disagreed, an explicit one source was kept and every value records which one: see Sources. Countries and aggregates are distinct entity types, so a total is never formed by summing “World” with the countries inside it. Missing values stay missing — nothing is interpolated.

Course handout: 1: Gathering and Cleaning · 2: Cleaning and the Model · 3: Transformation · 4: Cube Operations · 5: Dashboard · also as PDF 1, 2, 3, 4, 5 · practice files: Excel workbook, SQL database