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 →

The beginners guide to dashboards

I love dashboards! Cognos, Click View, Power BI, Tableau or the pure Excel and Powerpoint version — I think it's amazing. Before even considering what to include in a dashboard, think about the purpose and the strategy of your company. Where are you going and how are you going to compete? Check out 5 reasons... Continue Reading →

Are you delivering on strategy?

In several places I have worked, I have seen the need for a simple, regular report with key figures relevant to the execution of strategy. Strategy must be measurable and you have to follow-up regularly so you can respond quickly to any red flags. Simple, relevant and regular information, in the same format from week... Continue Reading →

Blog at WordPress.com.

Up ↑