Tag Archives: MSBI

Me, Data, and a conference hall full of people

This year I was asked to present at our company’s semi-annual User Meeting – normally a chance for our very capable Support staff to show off new software features, best practices – but this year, 2 of us software developers … Continue reading

Posted in BI, Geek, PowerPivot, Software Development | Tagged , , | Leave a comment

More PowerPivot & Excel bugs & quirks

Some more PowerPivot oddities to share tonight based on issues I had encountered while building dashboards. For returning readers, you may remember how not long ago I was plagued by a PowerPivot Slicer issue where the PowerPivot Field list would … Continue reading

Posted in BI, PowerPivot | Tagged , , , | Leave a comment

Practical Advice & (some) Best Practices for PowerPivot Dashboards

Here are the topics/best practices to talk about regarding creating Dashboards using PowerPivot based on what I have learned from others and a lot of trial & error.  (This is another one of those posts where the primary audience in … Continue reading

Posted in BI, Dashboard, PowerPivot | Tagged , , | 3 Comments

PowerPivot (well, BI) is like Geocaching

Why do I enjoy using PowerPivot so much?  Because it solves problems for me. When I first started digging into business intelligence, I started with building data marts, and then defining cubes in SSAS, but one problem kept cropping up … Continue reading

Posted in BI | Tagged , , , | 2 Comments