Big Data and AI

Final Project – Part 2: Building the Calculations Layer In this second part of the Final Project, you will create the calculations layer that powers your Sales Dashboard. This layer transforms raw data into meaningful insights using formulas, helper columns, KPIs, and summary metrics. A well‑designed calculations layer is essential for any professional dashboard because it ensures: Clean and reliable results Easy updates when new data is added Clear separation between raw data and analysis Consistent formulas across the entire workbook You will apply skills from Modules 2, 3, 4, 5, and 6 to build a solid analytical foundation. 1. Create a New Sheet for Calculations Create a worksheet named Calculations . This sheet will contain: Summary metrics (KPIs) Helper tables Monthly totals Category totals Region totals Keeping calculations separate from the dashboard improves clarity and prevents accidental edits. 2. C...