Two common PowerPivot error messages
Been meaning to post this for awhile now. Here are two error messages I see all the time now, about once per day: UPDATED: I’ve found a third message that […]
Category: Page Type
Calling a Stored procedure in PowerPivot
By Kasper de Jonge, crosspost from PowerPivotblog.nl While building a new PowerPivot workbook i wanted to use Time Intelligent functions. One of the golden rules of PowerPivot time intelligent functions is […]
The Superheroes of DAX, and derived measures
“Did someone say DAX?” I wanted to start today’s post with a quick thank-you to the guys who tirelessly answer my DAX questions. Marius Dumitru, Howie Dickerman, and Karen Aleksanyan. […]
Quick Data Prep Trick: Use a Flat Pivot!
Today I had a huge source table that looked like this: Store Month Payment Type Some Number A Jan Cash 10 A Jan Credit 12 A Jan Debit 13 A […]
PowerPivot Data in Scatter Charts, etc.
This was going around on the MS-internal discussion list this past weekend: At right is a list of all chart types in Excel. But not all of them are supported […]
The death of pie charts?
A few weeks back, a BI analyst posted a list of factors to consider when selecting a new BI tool. Shortly thereafter, a BI blogger posted a scathing critique of that article
Microsoft Unveils New Programming Language: XL#
OK, yeah, that’s not a real story. I just made it up, sorry 🙂
Putting the “Intelligence” in “Business Intelligence,” Pt 3
In Part One I described how standardized corporate BI bummed me out my first time around, then in Part Two described how PowerPivot recharged my batteries and brought me back into the fold.
Putting the “Intelligence” in “Business Intelligence,” Pt 2
“I’ve always believed that the mind was the most dangerous weapon.” -John Rambo …which explains the huge muscles and machine gun, right John? A View of BI that Henry […]
Putting the “Intelligence” in “Business Intelligence,” Part 1
I remember the first time I heard the term “Business Intelligence.” I had been working on Excel for awhile at that point and loved crunching data, but boy, “Business Intelligence” […]