|
|
|
|
EDUCATIONAL SERVICES DATA WAREHOUSING FOR TECHNOLOGISTS WORKSHOP ABSTRACT
This seminar is intended to provide your technical staff with an understanding
of what a Data Warehouse Architecture is, how to select the right
Data Warehouse tools and how a Data Warehouse can turn legacy data
into information - Business Intelligence. Also introduced in this
seminar is the Meta Model Management and Data
base Design techniques such as Star Schema and Multidimensional Modeling. AUDIENCE
IT Professionals involved in the analysis, design, development, implementation
and maintenance of the Data Warehouse - Project Managers, System and
Business Architects, Data Modelers, Data Base Administrators, Project
Leaders, Application Developers and Business Managers/Analysts. What is the Data Warehouse?
• Business Benefits • 'What It Is, What It Is Not' • The Evolution Of Data • Knowledge Worker Evolution Four Tier Architecture
• Operational Tier • Data Acquisition Tier • Analytical Tier • Data Presentation Tier • Functions Within Each Tier Data Warehousing Tools
• Relational DBMS, OLAP, ROLAP • Multidimensional Databases • Data Mapping, Scheduling, Cleansing • Metadata And Repositories • Data Mining, Reporting, Visualization • GI, Detect, And Alert Agents • Information Catalogs Implementation Methodology
• Data Warehouse And Data Re-enginnering • Meta Data Management • Data Replication Strategies • Integration With Operational Data • Workflow Integration DW Data Base Design
• Measures & Dimensions • Star Schema, Snow Flakes, Etc… • DW Data Modeling • Managing Dimension History • Supporting OLAP, ROLAP Requirements • Normalized And Dimensional Designs • Performance Tuning Project Organization
• Where To Start • Teams, Roles And Responsibilities • Critical Success Factors • Planning For Ongoing Support Real Time Demonstration Of Tools And Industry
• Applications • Reporting, Visualization And Ad-hoc Tools • Data Acquisition Tools • OLAP, ROLAP Tools • Data Mining Tools • Geographic Information Systems (GIS) • Detect And Alert Tools • Information Directory/Catalogs • CASE/Data Modeling Tools Industry and Business Applications
• Health Care • Brokerage • Marketing • Pharmaceutical • Manufacturing • Profit & Loss • Entertainment/Performing Arts • Subscription Services • Telecommunications • Brand Analysis/Category Management |
