March 2009
Beginner to intermediate
384 pages
8h 40m
English
Content preview from Data Warehousing For Dummies®, 2nd EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 9. Simple Database Querying and Reporting
In This Chapter
Looking at basic querying and reporting functionality
Determining whether you need only basic querying from your data warehouse
Designing your relational database to support querying and reporting
Checking out some tools for your data warehouse
Querying and reporting is the low end of the spectrum of business intelligence functionality that applies to your data warehouse. (Chapter 8 provides an overview of business intelligence functionality.) Querying and reporting handles "tell me what happened" processing that's relatively static and predictable, for the most part. The data is retrieved in accordance with either regular standard reports or in response to a particular question (an ad hoc query, for example). Then, that data is formatted and presented to the user either on-screen or on a printout.
The interaction model for querying and reporting business intelligence typically follows a pattern of regular, predictable steps (these steps are also in Chapter 8, so you can skip ahead if you've already read that chapter):
Make a data request.
Retrieve the data.
Manipulate the data slightly.
Summarize or reorganize, for example, if necessary.
Format the data.
Present the data.
These steps don't vary much between tools, scenarios, or users. If a user decides that the presented result looks odd or otherwise needs to be augmented, the process usually just begins again with a new request.
What Functionality Does a Querying and Reporting ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.