Power Pivot | Create a Pivot Table from multiple tables | Actual vs Budget | One to Many Relations

Visit my website: aaa-power.net -------------------------------------------------------- 1- Simple power pivot example (Excel Data Model), actual sales vs budget report based on 2 separate reports with no v-lookup functions 2- Learn how to create a pivot table based on 2 tables that are not identical 3-Explore how to create relations between tables (a power pivot / data model capability) 4-How to create dimensional (lookup) tables to find the relation between 2 Fact (transaction) tables 5-See how excel can find the relation between tables automatically 6- Learn how to create relations manually 7- Manage many to many relations in excel data model / Power Pivot -------------------------------------------------------- To download the excel files: Raw data file: https://drive.google.com/open?id=1-WLg-ksDVUt2HXk4NG5S7JnEUAK-pQ3g Raw data and report (Act vs Bud): https://drive.google.com/open?id=16v0ogbuUrheWnmugLqfM3acpCP5oo71M -------------------------------------------------------- To subscribe: https://www.youtube.com/channel/UCAxOgfPN8XqlB-lGmORVB5g?sub_confirmation=1 --------------------------------------------------------------------- To follow on Facebook: https://www.facebook.com/excelispower --------------------------------------------------------------------- To follow on LinkedIn: https://www.linkedin.com/in/amratef