Implementing Data Warehousing
Overview
This practical course provides you with an in-depth understanding of data warehousing its application to business intelligence. You will learn the concepts and skills necessary to build a successful data warehouse to enable your business intelligence program on the first implementation. In addition, the course covers how the business intelligence arena is changing the way companies do business including, how the data warehouse provides corporations with the backbone to their e-business solutions and is critical for making better strategic decisions. Real-world case studies of business intelligence and data warehousing implementations will be used to leverage the lessons learned on these projects.
Through team interaction, attendees will be provided with a full lifecycle strategy and methodology for defining system requirements, capturing and integrating source data, meta data repository fundamentals, accessing the information in the data warehouse, and integrating your data warehouse with your e-business solution.
Benefits To Your Company
- Learn a full lifecycle methodology for implementing a business intelligence system using data warehouse technology.
- Know how to integrate your e-business solution with your data warehouse.
- Understand how to define requirements that yield positive ROI.
- Identify the challenges of implementing a data warehouse.
- Understand how to build a data warehouse that is flexible to the changing technical marketplace.
Who Should Attend
- CIO’s
- Executive management
- Project managers
- Decision support system architects
- Database designers/data architects
- Lead designers
- Business analysts
Learning Objectives
CIOs and executive management will learn to...
- Cost justify and build a business intelligence system using data warehouse technology for a competitive advantage in the marketplace.
- Understand how to manage risk and anticipate the stumbling blocks before they occur.
Project managers and decision support system architects will learn to...
- Organize and manage their teams.
- How to create accurate project plans.
- Learn to define requirements that prevent scope creep.
- How to build an architecture that is extendible, robust, and flexible over time.
Database designers will learn to...
- Identify the key business data necessary to store in the physical data models in order for the data warehouse to provide value to its end users.
Lead designers and business analysts will learn how to...
- Design attainable requirements for the data warehouse.
- Understand how to create e-business solutions that deliver value.
What Makes This Certified Course Unique
This ICCP-certified course provides participants with practical, in-depth understanding of how to implement a successful data warehouse. Through case studies and team interaction attendees will attain the real-world implementation skills necessary to build a data warehousing program for their organization. Hands-on workshops throughout the course will reinforce the learning experience and provide the attendees with concrete results that can be used in their organizations.
Course Outline
- Understanding data warehousing
- Analyze the current state of the data warehousing industry
- Data warehousing fundamentals
- Defining meta data and its critical role in data warehousing
- Challenges in the data warehouse industry
- Selling the concept of building a data warehouse to management (ROI)
- Cutting through the vendor hype
- How to implement a data warehouse and an e-business
solution
- Keys to a sound architecture
- Defining system requirements
- Integrating legacy system sources
- Accessing data warehouse
- Approaches to data warehouse development
- Data model walkthrough (3rd normal form and dimensional)
- The data warehouse team
- Creating the data warehouse team
- Data warehouse team role walkthroughs
- Creating the data warehouse project plan
- Data warehouse ROI definition
- Constructing the data warehouse scope document
- Create a data integration strategy for your company
- Understanding the key business intelligence vendors
- The battle for meta data standards (Meta Data Coalition vs. Object Management Group)
- Evaluating data warehousing tools, including ETL (extract, transform, & load), OLAP (online analytical processing), and portals
- Real-world analysis of tool vendors
- Understand the trends in business intelligence
- Data warehousing changing landscape
- Meta data
- XML
- Workshop conclusion
- Summary, additional exercises, sources for further reading, etc.
Standard Duration
- 3 days (may be customized as needed)
To learn more about how EWSolutions can provide our World-Class Training for your company or to request a quote, please feel free to contact David Marco, our Director of Education at DMarco@EWSolutions.com or call him at 630.920.0005 ext. 103.