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:

Get Pro SQL Server 2012 BI Solutions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.