Microsoft Excel is an extremely powerful tool that allows users to manage and analyse databases of all sizes. In 2010, Microsoft added a new tool called PowerPivot to Excel’s […]
A Closer Look at Excel PowerPivot and Power View
I’m sure that we can all agree that Microsoft Excel is an incredible application. You can do so much with it, but broadly speaking, there are 3 main functions […]
PowerPivot and Analysis Services Tabular Data Models
Have you tried using Excel’s PowerPivot? For those of you who have, it’s awesome, isn’t it? If you haven’t, have a crack, you’ll find the experience rewarding. What I […]
Owning the runway with BI Semantic Model
I believe there’s some confusion about the BI Semantic Model (BISM), multidimensional models, and tabular models. Further to this is the question of “when can I use MDX and DAX?” […]
PowerPivot’s CALCULATE function to the rescue
One of the most commonly used DAX functions in PowerPivot is the ‘CALCULATE’ function, and in my opinion, it’s one of the most interesting functions because it’s a very […]