O'Reilly logo

Pro SQL Server 2012 BI Solutions by Caryn Mason, Randal Root

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 13

image

Creating Reports with SQL Queries

I’m convinced you can combine this with reporting integrity and accuracy.

—Jack Brickhouse

With the data warehouse completed and filled with data, it is time to realize some of the fruits of your efforts by making your first preliminary reports.

In this chapter, we take a look at the process of creating report code using the SQL programming language and some of the decisions that you have to make regarding this code. We walk you through the process of creating report queries from start to finish.

A data warehouse can have thousands of reports against it, and all reports have aspects in common:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required