Olap Training on CD-ROM
Olap Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
SQL Server 7 0 Data Warehousing Set of 4
...hniques into one DTS Package 4.0 Cubes (30 Mins) 4.1 OLAP Manager 4.2 Introduction to Cubes 4.3 Cube Structure & Components 4.4 Identifying a Fact Table 4.5 Private VS Shared Dimensions 4.6 Managing Aggregations 4.7 Incorporating a Fact Table & Dimensions into a Cube SQL 7.0 Data Warehousing Level 3 (1 Hr 28 Mins) 1.0 Storing & Processing Cubes (32 Mins) 1.1 MOLAP,
more...
SQL Server 7 0 Data Warehousing Set of 4
SQL Server 7 0 Data Warehousing Level 2
SQL 7.0 Data Warehousing Level 2 (1 Hr 48 Mins) 1.0 Building the Data Warehouse (15 Mins) 1.1 Overview 1.2 Build Database 1.3 Build Dimension Tables 1.4 Using Scripts & Building a Fact Table 2.0 Validating and Transforming Data (53 Mins) 2.1 Process Overview 2.2 Methods of Populating a Data Warehouse 2.3 Tools for Populating a Data Warehouse 2.4 Transact-SQL 2.5 Distributed Query
more...
SQL Server 7 0 Data Warehousing Level 3
... Mins) 1.0 Storing & Processing Cubes (32 Mins) 1.1 MOLAP, ROLAP, & HOLAP Storage Structures 1.2 Comparing ROLAP & MOLAP 1.3 Review & Compare Storage Options 1.4 Storing Partitions & Processing Cubes 1.5 Calculated Members 1.6 The Virtual Cube, Cube Security & Roles 2.0 Analyzing Data Using Clients (28 Mins) 2.1 Navigating Warehouse Data & Data Mining 2.2 Local Cubes 2.3 OLAP
more...
SQL Server 7 0 Data Warehousing Level 4
...0 Data Warehousing Level 4 (1 Hr 32 Mins) 1.0 Building OLAP Clients (27 Mins) 1.1 Overview of Client/Server Architecture 1.2 ADO MD, Catalog Object & Cubedef Object 1.3 Retrieving Data About Cubes & Using Cellsets 1.4 Creating Local Cubes through MDX & ADO MD 2.0 Microsoft English Query (35 Mins) 2.1 Introduction to Microsoft English Query 2.2 Domains, Entities, & Relationships
more...
SQL Server 2000 Data Warehousing Set of 5
...ata Warehouse Defined 1.4 Data Warehouses vs. Data Marts/OLAP 2.0 Dimensional Modeling & Planning 2.1 Entity-Relationship Modeling vs. Dimensional Modeling 2.2 Elements of the Dimensional Model 2.3 The Role of User Requirements 2.4 Identifying Source Data 2.5 Implementing the Data Warehouse Bus 3.0 Planning Facts 3.1 What is a fact? 3.2 Measures 4.0 Planning Dimensions 4.1
more...
