Skip to content.

EWSolutions

Sections
Home » World-Class Training » World-Class Data Warehouse Training

World-Class Data Warehouse Training

  • Data Warehousing 101 - Business Professionals   link arrow

    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.

  • Data Warehousing 101 - IT Professionals   link arrow

    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.

  • Business Requirements for Data Warehousing   link arrow

    Creating business requirements for data and process is a difficult task for any development effort. For a data warehouse or other decision support endeavor this task is complicated by a traditional focus on transaction process requirements development practices.

    This course focuses on how to gather, define and document business requirements and perform analysis for data warehousing and related decision support applications. The course consists of an introduction to the business analyst function and proceeds to develop skill sets needed for gathering, documenting and analyzing requirements for any decision support initiative, including the development of appropriate meta data and non-functional requirements. In a workshop format, students will learn concepts of requirements management and their applicability to the data warehousing environment.

  • Data Warehousing Project Management   link arrow

    Data warehouse projects present a unique set of management challenges that can stymie many experienced information system project managers. This complex suite of database and applications requires a tailored methodology to ensure that the project is well-organized, analyzed and executed, delivering value to the data warehouse users. This course will offer a methodology for creating a successful data warehouse, based upon actual experiences. The attendee will gain an understanding of the importance of managing a data warehouse project using standard information systems project management techniques that have been enhanced for a data warehouse project, the critical success factors of data warehousing and offer some suggestions for avoiding common problems. As an added benefit, participants will examine and critique a data warehouse case study where they can apply the lessons learned in this workshop.

  • Data Modeling For Data Warehousing / Business Intelligence   link arrow

    Data Modeling for Data Warehousing / Business Intelligence is an in-depth, technical course that teaches the fundamental concepts for modeling a data warehouse, operational data store, and a data mart or other decision support application. Using both 3rd normal form, multi-dimensional (star schema and snowflake) modeling, and object techniques, attendees will learn how to represent the data requirements for a decision support system so that the resulting database is designed appropriately. The course includes a section on gathering data warehouse system requirements and examines the differences between requirements management and modeling for data warehousing versus transactional systems. With hands-on workshops, attendees will transform end users' requirements into physical data warehouse/data mart models.

  • Advanced Dimensional Modeling   link arrow

    Advanced Dimensional Modeling is an in-depth, technical course that teaches the advanced concepts for designing a dimensional Business Intelligence (BI) model for high-performance reporting and analytics solutions such as Business Performance Management (BPM), Customer Analytics, Supply Chain Analytics, etc. This course will review data warehouse architecture and basic dimensional modeling concepts but the primary focus will be on advanced dimensional modeling techniques and helping participants learn when to use which techniques. With hands-on workshops, attendees will transform end users' reporting and analytics requirements into Dimensional Models (using a phased modeling approach) which are understandable to the business and will perform well in the face of unpredictable query patterns.

  • Data Warehouse Full Lifecycle Development Guide   link arrow

    This practical course provides you with an in-depth understanding of data warehousing and its application to business intelligence. You will learn the concepts and skills necessary to build a successful data warehouse to implement your business intelligence program on the first implementation. Real-world case studies of business intelligence and data warehousing implementations are 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/integrating source data, and accessing the information in the data warehouse.

  • ETL Architectures – Concepts and Implementation   link arrow

    ETL Architectures is an in-depth, technical course that teaches the concepts for designing and implementing the appropriate architectures to use in managing the extraction, transformation and loading (ETL) of data for:

    • High performance decision support environments (data warehouses, dimensional data marts, Operational Data Stores (ODS), etc)
    • Master Data Management hubs (Customer Data Integration (CDI), Product Information Management (PIM), etc)
    • General data integration (e.g. Service Oriented Architectures (SOA))

    This course will review these architectures and concepts with the primary focus on the concepts and techniques that apply to various approaches to ETL. Participants will learn when to use certain techniques, based on their technical and business requirements. With hands-on workshops, attendees will study different ETL products and methodologies for implementation in today’s heterogeneous system environments.

  • Fundamentals of Data Warehouse Testing   link arrow

    This course introduces the student to the phases of testing and validation in a data warehouse or other decision support systems project. Students will learn the role of the testing process as part of a software development project, see how business requirements become the foundation for testing cases and test plans, develop a testing strategy develop audience profiles and learn about how to develop and execute effective tests, all as part of a data warehouse / decision support initiative. Students will be able to apply the data warehouse concepts in a series of related exercises that enable them to create and refine the various artifacts of testing for their data warehouse programs.

  • Implementing Data Warehousing    link arrow

    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.

    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.