Data Warehousing For Dummies, 2nd Edition
- 5h 37m
- Alan R. Simon, Thomas C. Hammergren
- John Wiley & Sons (US)
- 2009
You don't need a forklift to work with a data warehouse, but you do need a hefty load of know-how to make wise decisions when setting one up. Data is probably your company's most important asset, so your data warehouse should serve your needs. Here's how to understand, develop, implement, and use data warehouses, plus a sneak peek into their future.
- Know your stuff — understand what a data warehouse is, what should be housed there, and what data assets are
- Get a handle on technology — learn about column-wise databases, hardware assisted databases, middleware, and master data management
- The intelligent view — see how business intelligence and data warehousing work together
- Ask the right questions — explore data mining and learn to find what you need
- Do the groundwork — choose your project team and apply best development practices to your data warehousing projects
- Keep the user in mind — involve your users in defining business needs through testing, and learn how to get valuable feedback
- Fix or replace? — learn how to review and upgrade existing data storage to make it serve your needs
- Buyer beware — be prepared when dealing with data warehousing product vendors
Open the book and find:
- What to expect from your data warehouse
- The difference between data warehouses and data marts
- All about specialty database technologies
- What to look for in a consultant
- How your data warehouse feeds dashboards and scorecards
- Secrets for managing a successful data warehouse project
- How to effectively capture business needs and requirements
- Ten signs your project is in trouble
About the Author
Tom Hammergren is known worldwide as an innovator, writer, educator, speaker, and consultant in the field of information management. Tom's information management and software career spans more than 20 years and includes key roles in successful business intelligence and information management solution companies such as Cognos, Cincom, and Sybase. Tom is the founder of Balanced Insight, Inc., a leading vendor of business intelligence lifecycle management software and services that also works on innovation in semantically driven business intelligence.
While working for Sybase, Hammergren helped design and develop WarehouseStudio, a comprehensive set of tools for delivering enterprise data warehousing solutions. At Cincom, Tom helped deliver the SupraServer product line to market, one of the first fully distributed data management solutions for highly survivable network implementations. During an earlier position at Cognos, he was one of the founding members of the PowerPlay and Impromptu product teams.
Tom has published numerous articles in industry journals and is the author of two widely read books, Data Warehousing: Building the Corporate Knowledge Base and Official Sybase Data Warehousing on the Internet: Accessing the Corporate Knowledge Base (both from International Thomson Computer Press).
In this Book
-
Introduction
-
What's in a Data Warehouse?
-
What Should You Expect from Your Data Warehouse?
-
Have It Your Way: The Structure of a Data Warehouse
-
Data Marts: Your Retail Data Outlet
-
Relational Databases and Data Warehousing
-
Specialty Databases and Data Warehousing
-
Stuck in the Middle with You: Data Warehousing Middleware
-
An Intelligent Look at Business Intelligence
-
Simple Database Querying and Reporting
-
Business Analysis (OLAP)
-
Data Mining: Hi-Ho, Hi-Ho, It's Off to Mine We Go
-
Dashboards and Scorecards
-
Data Warehousing and Other IT Projects: The Same but Different
-
Building a Winning Data Warehousing Project Team
-
You Need What? When? — Capturing Requirements
-
Analyzing Data Sources
-
Delivering the Goods
-
User Testing, Feedback, and Acceptance
-
The Information Value Chain: Connecting Internal and External Data
-
Data Warehousing Driving Quality and Integration
-
The View from the Executive Boardroom
-
Existing Sort-of Data Warehouses: Upgrade or Replace?
-
Surviving in the Computer Industry (and Handling Vendors)
-
Working with Data Warehousing Consultants
-
Expanding Your Data Warehouse with Unstructured Data
-
Agreeing to Disagree about Semantics
-
Collaborative Business Intelligence
-
Ten Questions to Consider When You're Selecting User Tools
-
Ten Secrets to Managing Your Project Successfully
-
Ten Sources of Up-to-Date Information about Data Warehousing
-
Ten Mandatory Skills for a Data Warehousing Consultant
-
Ten Signs of a Data Warehousing Project in Trouble
-
Ten Signs of a Successful Data Warehousing Project
-
Ten Subject Areas to Cover with Product Vendors
