The schema you need to know to build reports in Excel and Power BI with multiple tables using the Excel Data Model.