Chapter 3 of Analyzing data With Microsoft Power BI and Power Pivot for Excel discuss the use of multiple fact tables in data modeling.... Let' go! The challenge in module 3 Creating cross-filters between fact tables so that your dimensions, on both sides of your fact tables, are correctly related. A typical example is sales... Continue Reading →
Data modeling with header and detail tables
Chapter 2 of Analyzing data With Microsoft Power BI and Power Pivot for Excel discuss the use of header/details tables in data modeling. The scenario of header/detail tables appears when you have two fact tables with similar information, but with different granularity. Each of the fact tables has its own dimensions. It looks like two... Continue Reading →
