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 →

Getting the Power BI sertification….

A few weeks ago, I decided to get certified in Power BI. The closest certification I could find is the MSCA BI Reporting sertification from Microsoft. So I will be writing a short series covering the journey. It will be a bit longer than what I first foresaw. The MCSA sertification is awarded after passing... Continue Reading →

Do you really need a data strategy?

Historically, differentiation as a business strategy has focused on product and marked development. Data and analytics have been mere support functions. In the age of digital disruption however, executing a successful data strategy can be a competitive advantage on its own — and that is extremely exciting. With the vast amount of data companies have... Continue Reading →

Blog at WordPress.com.

Up ↑