Ta strona wykorzystuje pliki cookies. Korzystając ze strony, zgadzasz się na ich użycie. OK Polityka Prywatności Zaakceptuj i zamknij X

Course 2074A Designing and Implementing OLAP

24-01-2012, 5:23
Aukcja w czasie sprawdzania była zakończona.
Cena kup teraz: 40 zł     
Użytkownik twarzu
numer aukcji: 2040702115
Miejscowość Wrocław
Wyświetleń: 14   
Koniec: 16-01-2012, 9:43
Dodatkowe informacje:
Stan: Używany
Okładka: miękka
Rok wydania (xxxx): 2001
Język: angielski
info Niektóre dane mogą być zasłonięte. Żeby je odsłonić przepisz token po prawej stronie. captcha

Course 2074A:

Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000

Course OutlineModule 1: Introduction to Data Warehousing and OLAPLessons

  • Introducing Data Warehousing
  • Defining OLAP Solutions
  • Understanding Data Warehouse Design
  • Understanding OLAP Models
  • Applying OLAP Cubes
Module 2: Introducing Analysis Manager WizardsLessons
  • Defining Terms
  • Previewing Analysis Manager
  • Preparing to Create a Cube
  • Building the Sales Cube
  • Processing the Cube
  • Viewing the Results
Module 3: Understanding Analysis Services ArchitectureLessons
  • Overview
  • Microsoft Data Warehousing Overview
  • Analysis Services Components
  • Metadata Repository
  • Cube Storage Options
  • Client Architecture
  • Office 2000 OLAP Components
Module 4: Building Dimensions Using the Dimension EditorLessons
  • Understanding Dimension Basics
  • Shared vs. Private Dimensions
  • Working with Standard Dimensions
  • Basic Level Properties
  • Working with Parent-Child Dimensions
Module 5: Using Advanced Dimension SettingsLessons
  • Working with Levels and Hierarchies
  • Working with Time Dimensions
  • Creating Custom Rollups
  • Introducing Member Properties
  • Understanding Virtual Dimensions
Module 6: Working with Cubes and MeasuresLessons
  • Introduction to Cubes
  • Working with Cubes
  • Introduction to Measures
  • Working with Measures
  • Defining Cube Properties
  • Using the Disabled Property
Module 7: Case Study - Creating the Store Expense CubeLessons
  • Building the Store Expense Cube
  • Updating the Store Expense Cube
Module 8: Managing Storage and OptimizationLessons
  • Analysis Server Cube Storage
  • The Storage Design Wizard
  • Analysis Server Aggregations
  • Usage-Based Optimization
  • Optimization Tuning
Module 9: Processing Dimensions and CubesLessons
  • Introducing Dimension and Cube Processing
  • Processing Dimensions
  • Processing Cubes
  • Optimizing Cube Processing
  • Troubleshooting Cube Processing
Module 10: Managing PartitionsLessons
  • Introducing Partitions
  • Creating Partitions
  • Using Advanced Settings
  • Merging Partitions
Module 11: Implementing Calculations Using MDXLessons
  • Understanding Calculated Members
  • Building Calculated Members
  • Creating Non-Measure Calculated Members
  • Using Functions Within Calculated Members
  • Understanding Other Calculation Methods
  • Introducing Solve Order
Module 12: Working with Virtual CubesLessons
  • Understanding Virtual Cubes
  • Obtaining Logical Results
  • Building a Virtual Cube
  • Creating Calculated Members
Module 13: Using Excel as an OLAP ClientLessons
  • Office 2000 OLAP Components
  • Using Excel PivotTables
  • Using PivotCharts
  • Working with Local Cubes
  • Creating OLAP-Enabled Web Pages
Module 14: Using Actions, Drillthrough, and WritebackLessons
  • Creating Actions
  • Performing Drillthrough
  • Understanding Writeback
Module 15: Implementing SecurityLessons
  • Introducing Analysis Services Security
  • Understanding Administrator Security
  • Helping Protect User Authentication
  • Understanding Database Roles
  • Implementing Dimension Security
  • Managing Cube Roles
Module 16: Deploying an OLAP SolutionLessons
  • Introducing DTS
  • Executing and Scheduling Packages
  • The Analysis Services Processing Task
  • Copying and Archiving OLAP Databases
Module 17: Introduction to Data MiningLessons
  • Introducing Data Mining
  • Training a Data Mining Model
  • Building a Data Mining Model with OLAP Data
  • Browsing the Dependency Network
Module 18: Case Study - Working with the Foodmart DatabaseLessons
  • Building the Warehouse Cube
  • Building the Sales Cube
  • Building the Warehouse and Sales Virtual Cube