The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights
- 6h 36m
- Robert (Bob) Laberge
- McGraw-Hill/Osborne
- 2011
Empower your users and drive better decision making across your enterprise with detailed instructions and best practices from an expert developer and trainer. The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights shows how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. Learn how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered in this comprehensive guide.
- Understand the components of BI and data warehouse systems
- Establish project goals and implement an effective deployment plan
- Build accurate logical and physical enterprise data models
- Gain insight into your company's transactions with data mining
- Input, cleanse, and normalize data using ETL (Extract, Transform, and Load) techniques
- Use structured input files to define data requirements
- Employ top-down, bottom-up, and hybrid design methodologies
- Handle security and optimize performance using data governance tools
About the Author
Robert Laberge is a lead principle consultant for the IBM Industry Models and Assets Lab in Dublin which focuses on data warehousing and business intelligence solutions. He has helped more than 50 large organizations in 20 countries by mentoring, training, and demonstrating data warehouse and business intelligence solutions, including Target, Qwest, ING, Mayo Clinic, Canadian Tire, Shoppers Drug Mart, BMW, Korea Telecom, Scotiabank, Capital One, Reliance Infocomm, and Tata Group. Robert has a Masters of Business Administration from the University of Durham (UK) and has nearly 30 years of experience in IT.
In this Book
-
Data Warehouse and Business Intelligence Overview
-
Data in the Organization
-
Reasons for Building
-
Data Warehouse and Business Intelligence Strategy
-
Project Resources: Roles and Insights
-
Write-It-Up Overview
-
Business Intelligence: Data Marts and Usage
-
Enterprise Data Models
-
Data Warehouse Architecture: Components
-
ETL and Data Quality
-
Project Planning and Methodology
-
Working Scenarios
-
Data Governance
-
Post-Project Review
