Please check out this December SQL Server BI TechNet Guru Gold Medal Winner:
It's short but sweet! Here's the…
Some of the examples in this article refer to data elements and interfaces specific to the Team Foundation Server. The data warehouse is a relatively standard relational database. The web management tools for TFS are also included in some of the examples. While the examples may be specific to TFS, the techniques used in this article are not and so can be adapted for use with other data sources and management tools.
And here are all the December winners for the SQL Server BI category:
|SQL BI and Power BI (SSAS, SSIS, SSRS, Power Pivot) Technical Guru – December 2013|
|Tim Pacl||Functional Reports: Making a Report Into a Management Tool||NN: "Terrific article! Very helpful and clean steps"
Ed Price: "Tim nails it again with a fantastic and descriptive narrative on a great topic! It could be improved with images to show what you're describing. Fantastic article!"
|Michael Amadi||A practical example of how to handle simple many to many relationships in Power Pivot/SSAS Tabular models||Ed Price: "Great topic and great formatting! The descriptions are helpful, the images and the tables help clarify. The bold text really pops! Great article!"
NN: "Great article explaining a common problem and solution"
|Tim Pacl||Using a Date Picker for an Analysis Data Query Parameter||NN: "Another interesting article by Tim"
Ed Price: "Another great article from Tim. Shorter but sweet!"
Also worth a mention were the other entries this month:
- SSRS – Dependent Parameter and Wild Search in Parameter by Rishab Sachdeva
Ed Price: "Good instructions made clear with images. I would tighten the formatting with consistent font sizes, consistent spacing around images, and better formatting on the code blocks. But the content is very well done!"
NN: "I like that the article is very detailed and easy to reproduce, but the queries it uses are not good from the optimization point of view. "
- Using parameters and variables in a Script Task by SSISJoost
NN: "Another good and short clear article by SSISJoost"
- Execute SSIS 2012 package with parameters via .Net by SSISJoost
NN: "Helpful article"
- Using parameters and variables in a Script Component by SSISJoost
NN: "One more good article by SSISJoost based on his blog post"
- Populate Excel table with custom MDX query & PivotTable filters by Christian Wade
- SSAS time dimension with semi-additive measures; dynamic set; calculated members by Minnie Shi
NN: "This article is hard to understand without samples"
Thanks to Tim Pacl for providing so many great articles!
– Ninja Ed