Categories > Purchasing, Inventory & Material Category:    Data Warehouse     Program Duration : 5 Days Program Date : 15-19 April, 2012 Program Location : Cairo, Egypt Program Fees : US$ 3200/Per Person       PROGRAM INTRODUCTION: This Program is geared towards giving practical information needed to design, manage, build and use data warehouses for virtually any type of business application. Employing many real-life case studies of data warehouses, the course provides clear guidelines on selecting the right architecture, right methodology and the right modeling techniques to implement data warehouse project successfully. This course is designed to equip delegates with the necessary skills required to effectively manage a data warehouse. This course consists of both theoretical and practical sessions and unlike others is product independent. PROGRAM OBJECTIVES:   The participants will be able to learn following: Basic concepts of business intelligence and data warehousing Critical success factors & risks involved in a data warehousing project Data warehousing & business intelligence development processes Best practices and Industry trends Various data warehouse architectures and how to select the one suitable for your organization Dependencies between data warehousing architecture and development methodology How to assess the cost and value implications of various architectures How to assess the time-to-delivery implications of various methodologies Project management implications of various approaches How to determine the best-fit architecture and methodology for your data warehousing program   WHO SHOULD ATTEND? Warehouse Project Managers Warehouse Developers Warehouse Consultants Warehouse Architects   PROGRAM OUTLINES: Overview, Concepts & Architecture            Definitions and Industry Terminologies Business justification for Data Warehouse Architectural concepts for business intelligence and data warehousing Hub-and-spoke, federated, and independent architectures Data Warehouse and Data Staging Dependent and Independent Data marts Extract, transform, and load (ETL) Concepts and Principles Understanding OLAP, ROLAP and MOLAP Choosing the right data warehousing approach for your organization Logical design vs. Physical design Data cleaning techniques Meta-data management SOA concepts in Data Warehouse Methodologies, Implementation Process & Project Management Data warehousing & business intelligence development processes Scoping your Business Intelligence requirements Top-down, bottom-up, and hybrid data warehousing methodologies Time boxing data warehouse project Project Management and Implementation Methodology Data warehousing roles and responsibilities Mitigating risk in data warehousing projects Case Studies & Lessons Learned Data Modeling Techniques Dimensional vs. Normalized modeling design Star Schema and Snowflake design Slowly changing dimensions Multi-valued dimensions Fact table delivery Managing Performance of Data Warehouse Running Complex Queries Data warehouse database performance design De-normalization Techniques Physical design considerations  Selecting the right Business Intelligence Software/Tool for your environment Dashboard, OLAP and Reporting Tool ETL/ELT and Data Cleansing Tools