Tableau: Format Date As String mm/dd/yyyy hh:mm

gah. Why is some of this stuff so challenging in Tableau?  You have a date and you want to format it as a string? Why? So you can concatenate it with another string perhaps? Maybe you're creating a calculated field to use in a label (that's what I was doing). Unfortunately, when you convert a… Continue reading Tableau: Format Date As String mm/dd/yyyy hh:mm

Tableau – Where is the path to my extract!?!

Suppose you create an extract in your desktop version of Tableau and everything is running great. Then one of your peers casually asks "how big is that .tde file anyway?" You quickly check file explorer and discover the extract is not in the default location (What is the default path?). It seems like there should… Continue reading Tableau – Where is the path to my extract!?!

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… Continue reading DAX Formulas To Know And Love

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… Continue reading Create A List In Your SSRS Tooltip: Not Impossible!

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"… Continue reading Execute Stored Procedure From Excel With Temp Table

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… Continue reading Most Effective Business Intelligence Charts And Graphs