Category: Charts and Graphs

  • Tableau: Custom Date Range Picker

    For Tableau requirements like: Allow user to choose “Last 7 Days”, “Last 30 Days”, etc. this is your ticket. It turns out one parameter and one calculated field are all you need.

  • Find Your SSRS Target Server URL

    If you are looking to deploy your SSRS (SQL Server Reporting Service) reports directly from Visual Studio you will need to set the Target Server URL in the Properties of your project in the deployment section.  The trick here is that this is not the URL for your Report Manager. What you are in fact […]

  • 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 […]

  • It all comes back to the work that occurs behind the curtain…

    Couldn’t have said it better… RT @lanier: “80% of #datascience is infrastructure; 20% is the fun stuff—charts etc.” – @opower at #strataconf — Michael Cavaretta (@mjcavaretta) October 24, 2012  

  • 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 […]