|
|
|
|
EDUCATIONAL SERVICES DATA WAREHOUSING WORKSHOP ABSTRACT
This is a 3 week course that will take the IT professional through all the
steps of designing, developing and implementing a Data Warehouse. AUDIENCE
IT professionals involved in the analysis, design, development, implementation and
maintenance of the Data Warehouse - Project Managers, System and Business Analysts, System Architects, Data Modelers, Data Base Administrators,
Project Leaders, Application Developers. Week 1
Data Warehouse - Querying And Reporting Development Course
Lab Times: 2 Weeknights, 1 Weekend Day Queries And Reports
• What Is Querying And Reporting? • Querying And Reporting Catalogs • DW Reports • DW Catalogs Creating A Catalog
• Defining The Database • Selecting Database Gateway • Testing Database Connection • Specifying The Right Tables • Incorporating Data From Different Data Sources (Use Of Hot Files) Making The Right Joins
• Customizing The Join Structure • Adding Value To Your Catalog • Creating User Profiles • Designing And Structuring Folders • Ad Hoc • Filtering Data • Filtering Data Security • Optimization And Timing • Optimizing DW For Best Performance • Examining Connection Issues • Choosing Your Data Retrieval Options • Balancing The Client/Server Load • Installation And Deployment • Addressing Maintenance Issues • Updating Catalogs • Backing Up Catalogs DW Reporting
• Selecting Style Of A Report • Organizing Report Data • Building Report With Frames • Selecting Style Of A Report • Create Quick Reports Using Templates Supplied With DW • Creating Custom Templates Week 2
Data Warehouse Development And Administration Utilizing OLAP/MOLAP
Lab Times: 2 Weeknights, 1 Weekend Day Development Tools
• Introduction To Transformer • Designing The Dimension Map • Preparing The Query Data • Building Dimensions • Alternate Drill Downs • Time Dimensions • Measures • Allocations • Drill Through • Define And Create PowerCubes • PowerCube Production And Maintenance • Optimize Performance Workshops
• Plan The Application • Design The Dimension Map • Identify And Collect The Required Data • Build The Model • Create And Explore A PowerCube • Compare The Model To Your Plan And Identify The Differences • Enhance The Model • Create Multiple PowerCubes If Required • Plan And Implement The Rollout • Creating Cube With A Single Query • Metadata Management Week 3
Advanced Topics : Data Warehouse Modeling, Design, Development, Deployment And Customization
Lab Times: 2 Weeknights, 1 Weekend Day Course Outline
• Data Warehouse Development Methodology • 4-Tier Data Warehousing Architecture Overview • Data Warehouse Database Design • Analytical Model Overview • Data Warehouse Population Strategies • Components And Their Functionality • OLAP/ROLAP/MOLAP Considerations • Workshop Data Warehouse Database Design
• Metadata Management • Business Metadata • System Metadata • Star Schemas • Dimensional History Design Considerations DW Population Strategies • Time Box Methodology Data Warehouse Development Methodology
• Data Mapping • Map Table Structures • Data Adaptation • Columns And Data Types Match, Table Name Is Different • Columns Match, Data Types Are Different • Single Table/View • Multiple Tables/Views • Changing Layer • Define Changing Layer Strategy • Test Changing Layer Workshops
• Dimensional Modeling • DW Entity Modeling • Data Mapping • DW Population |
