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 10. Business Analysis (OLAP)
In This Chapter
Getting a no-hype picture of OLAP
Looking into OLAP features
Checking out some OLAP vendors
A man walks down the street in Manhattan carrying a data warehouse under his arm. From the other direction, a woman approaches, carrying an OLAP. (Bear with me — this stuff will make sense in a second.)
The man sees a billboard advertising a watch he's had his eye on, and now it's on sale. To catch the ending date for the sale, he keeps his eyes on the billboard while he walks.
The woman notices a crowd of people gathered outside a theater and looks in that direction to see what the commotion is. She too continues walking.
Suddenly, the man and woman collide. Stunned for a moment, the man looks down and then says to the woman, "Hey, you got OLAP in my data warehouse!" The woman recovers from her surprise, looks down, and says to the man, "Hey, you got a data warehouse on my OLAP!"
Together, they both say, "Mmmmm . . . "
If you're at least as old as I am, this scenario should bring back memories of a mid-1980s series of commercials for a certain chocolate-covered peanut-butter-cup candy. If it doesn't sound familiar, check out the retromercials (old, original television commercials) on YouTube. You might see this one.
Step over from TV Land to Data Warehousing Land. Without OLAP, data warehousing would hardly be what it is today. At the same time, the roots of OLAP — or, more precisely, multidimensional business analysis — go back to the 1960s.
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.