Tag Archives | Chart

DAX Formulas To Know And Love

PowerPivot this. PowerPivot that. Blah, blah, blah. Sorry folks, I don’t have time to learn your new Excel plugin because I’m writing SQL! I’m hardcore! Well, I finally started using PowerPivot a few days ago and I’m pretty impressed (although I seem to be able to make Excel crash pretty frequently). So I’m starting a […]

Create A List In Your SSRS Tooltip: Not Impossible!

Warning!  This post is barely finished.  I putting it up as a reminder to myself that I had a hard time finding a post explaining how to do it and I should write a post on it. “It’s impossible” they said.  “It can’t be done!” they claimed.  “You’re mad (but still surprisingly handsome!)” the women […]

Execute Stored Procedure From Excel With Temp Table

Do you want to execute a stored procedure from Excel?  No problem!  Does your proc contain a temp table? Problem!  Actually, don’t panic.  The fix is incredibly simple.  Tracking down this post was probably the most difficult part.  When executing a SQL Server proc with a temp table you must remember to “SET NOCOUNT ON” […]

Most Effective Business Intelligence Charts And Graphs

As software vendors flood us with flashy dashboards and widgets for our BI projects, some of which clearly obscure information more than they illuminate, I started  hunting for research documenting which methods of charting are the most effective.  Naomi B. Robbins “Creating More Effective Graphs” presentation fits the bill (turns out the presentation is based […]