Imagine you’ve got a very simple Power Pivot model that looks like this: There’s a Date table with dates, months and years in, and an Internet Sales table with sales data ... So for example, here’s a ...

For example ... data tables into the Power Pivot data model from Excel or external sources. Establish relationships between tables using shared columns, such as product IDs or employee numbers ...

Sometimes, when you’re analysing data, you need to be able to change variables and see what the impact is: for example ... need to create a table containing all possible variable values in advance.