Notes For Power Query & Power Pivot
Data Model in Power Pivot is nothing but relations between two or more tables. Here we create a link between tables using the primary key (from the lookup table, lookup table contains unique records only) & the foreign key (from the fact table, the fact table may contain duplicate records). In excel, we do the same by bringing related columns in one sheet using the Vlookup formula. Difference b/w normal pivot table & power pivot table. Look and feel is the same for both. We may use one data table to create more than one lookup table with unique records. Let say we have one data table with all the information like customer details, product details and product purchased by the customers. With the help of Power Query, we can create 2 lookup tables (customer_details & product_details) and one data table of product sale details.