Excel Power Pivot IntroductionWhat is Power Pivot? It is an add-in, and according to Microsoft: “Power Pivot is a data modeling […] November 7, 2022 in Excel tagged data / query / pivot / power / KPI / measure / BI / Excel Power Pivot by Mike
Power Pivot Kevin CookieLet’s work with Kevin here on the fictitious Kevin Cookie Company’s data. Have a look at the YouTube […] November 9, 2022 in Excel tagged pivot / power / excel / Excel Power Pivot by Mike
Itzik Ben Gan’s DatabaseAs a more complex and realistic example, let’s look at the database that Itzik Ben-Gan used in his […] November 14, 2022 in Excel tagged data model / left join / Ben / Gan / sql / null / Itzik / transform / Excel Power Pivot by Mike