Analytics in Action

Archive for May, 2011

Creating a SQL Server Reporting Services Report (SSRS) that contains a parameter query

In many reporting situations users need to restrict the data visible in a report. For example filtering a master report with a drop-down list box so that only information for a specific month or product is shown. This video demonstrates...

How to create a basic SQL Server Reporting Services project with drill down functionality using the Report Wizard.

This demonstration uses Business intelligence Development Studio (BIDS) to launch the SQL Server Reporting Services wizard and create a report through a series of simple steps. The demonstration involves 1) creating a new data source (shared in this case)...

Creating a Cluster Model using the Excel Addin for SQL Server.

Clustering is the classification of similar objects into different groups, or more precisely, the partitioning of a data set into subsets (clusters), so that the data in each subset (ideally) share some common trait - often proximity according to some...