Data Warehousing 101 - Business 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 tied to ROI, project management, architecture, critical success factors, risk factors, design, process, and tools.
This course is presented is a straight-forward, non-technical manner. It 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.
Who Should Attend
- CEO's
- CFO's
- CIO's
- Data warehouse project managers
- Data administrators
- Data warehouse developers
- Department managers
- End users
Course Outline
- Understanding business intelligence
- 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
- Data warehouse ROI definition
- Cutting through the vendor hype
- 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
- 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
- 1 day (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.
LEARN MORE ABOUT Data Warehousing