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 →

Løpsrapport fra Sentrumsløpet 27. april

Fjorårets julegaves fra mannen var startnummer til Sentrumsløpet og en haug andre goder som massasje, engasjert pt, barnepass osv. What?!? Jeg begynte selvsagt å løpe 1. juledag. Opptreningen har vært litt varierende. Løping med full A4-familie er ikke helt det samme som løping med samboer. På vei inn i startfeltet: Jeg må ikke tisse, jeg... Continue Reading →

Make over Monday week 6

Make over Monday week 6 This weeks data set is a set of metrics comparing the Chinese New Year and the American Thanksgiving celebrations. Looking at data per inhabitant changes the picture quite a lot. Especially Retail and Restaurant spending during the holiday. For this weeks challenge I kept it simple and I did the... Continue Reading →

Blog at WordPress.com.

Up ↑