Data Warehousing 101 - IT Professionals
Overview
Data Warehousing 101 is a comprehensive on-site overview of data warehousing, data marts, decision support architecture, and their utilization to attaining business objectives. The purpose of this course is to take attendees with little to no background in data warehousing to a functional understanding of business objectives and technical challenges tied to ROI, project management, architecture, critical success factors, risk factors, design, process, and tools. This course is presented is a straight-forward manner and assumes that attendees have no prior knowledge of decision support concepts or data warehouse/data mart implementations. This course is founded on the practical experiences of real-world implementations of data warehouse and data mart projects. This seminar provides the critical prerequisites for successful, profitable, and extendable data warehouse and data mart implementations.
Benefits To Your Company
This course lays the groundwork and provides the fundamentals required to leverage your company’s investment in an enterprise or department level decision support system. It quickly elevates the understanding of the value and objectives of a data warehouse. Provides a common terminology and basic architecture to use for future data warehouse discussions.
Who Should Attend
- CIO’s
- Data warehouse project managers
- Database administrators
- Data administrators/architects
- Data warehouse developers
Course Outline
- Understanding business intelligence
- Analyze the current state of the data warehousing industry
- Data warehousing fundamentals
- Operational data store
- Data mart
- 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
- The data warehouse team
- Data warehouse team role walkthroughs
- Reviewing the data warehouse project plan
- Data warehouse ROI definition
- Understanding the key business intelligence vendors
- Understanding 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
- Data warehouse project management overview
- Goals and objectives
- Critical success factors
- Business problems in data warehousing
- Measuring results
- Risks, issues, challenges in data warehouse project management
- Selecting the first data warehouse project
- Workshop conclusion
- Summary, additional exercises, sources for further reading, etc.
Standard Duration
- 2 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 Dr. Anne Marie Smith, our Director of Education at AMSmith@EWSolutions.com or call her at 856.468.6194
LEARN MORE ABOUT Data Warehousing