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:
drive.google.com/open?id=1-WL...
Raw data and report (Act vs Bud):
drive.google.com/open?id=16v0...
--------------------------------------------------------
To subscribe:
/ @aaaexcelenglish
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on LinkedIn:
/ amratef

[@boissierepascal5755]

Very clear and usefull as usual !

[@aaaexcelenglish]

Glad you think so! thank you

[@Bhavik_Khatri]

Excellent video

[@aaaexcelenglish]

Thank you 🙏

[@jazzista1967]

Amr ; Great video . I usually create my relationships inside the powerpivot data model window . NIce alternative . Downloaded the file to practice. Thanks

[@aaaexcelenglish]

Great 👍 thank you so much

[@islamal-parody3593]

This is great, thank you Amr

[@aaaexcelenglish]

Most welcome Islam