Creating Reports with SQL Queries
I’m convinced you can combine this with reporting integrity and accuracy.
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: