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.
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… Continue reading Find Your SSRS Target Server URL
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
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
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
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