Archive | Microsoft BI

SSRS evolution from 2008 to 2014

Result Data is preparing to launch its all new SQL Server Reporting Services (SSRS) introduction course. We want to make this training available to all students, no matter what version of SSRS they are equipped with. During the research phase, while designing this course, I found that there is quite a bit of confusion surrounding […]

Continue Reading

Defining the BI Center of Excellence. Do I need one?

This begins a series of articles on the subject of building a Business Intelligence Center of Excellence (BI CoE). Over the next several months we will look at: Defining a Center of Excellence. Do I need one? The organizational and logical structure of a BI CoE. The Information Intelligence Lifecycle (how data moves through your […]

Continue Reading

The SQL Table Variable

Introduction SQL Server has a special data type, table, which holds a dataset.  A user defined function can return a table data type and a variable can be declared using the table data type.  You can not define a column in a table or view as a table data type.  It is a special data […]

Continue Reading

Understanding Joins in SQL

Introduction A SQL join gives you the ability to take two or more tables that have a logical relationship and combine the data into one result set. There are a few different types of joins, including INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN. Each join statement will give you different result sets. I […]

Continue Reading

Window Functions in SQL Server 2012

A window function in SQL allows an aggregate value to be calculated on a defined sub set of rows.  Window functions were introduced into Transact-SQL with the release of SQL Server 2005. To use a window function you must use the OVER() clause to define the window. Assume we have a table containing sales data.  […]

Continue Reading

Simulating SQL Joins in Excel

Here is the setting: You have two tables of data that you have exported to Excel. These tables are in the same document, same sheet, side by side.   Now, what if you would like to find information in the table on the right, based on the data in the table on the left? With […]

Continue Reading