Kursen har inget datum. Ring vår kursbokning 077 186 10 37 för information om en privat utbildning.
Översikt
| Kurskod | 2K014SE | Leveranstyp | Instructor Led - Online Training
(Hands-on labs) |
|---|---|---|---|
| Kurslängd | 3.0 dagar | Kurstyp | |
| Listpris | Kontakta IBM |
IBM Clarity Education is pleased to offer you our courses in an exciting learning format, Instructor-led Online (ILO). Students are offered a similar experience to live classroom training, with the convenience of having it delivered directly to their desktop.
The IBM® Clarity: Designing MSAS Solutions course is a hands-on instructor-led course that provides Back-end Developers with knowledge on how to build an OLAP cube from start to finish including building dimensions, building cubes, ETL, and Automation.
Nyckelområden
Basic OLAP Concepts
Designing the MSAS Solution
SQL Server Management Studio Basics
- Connect to a Server and Database in SSMS
- Create a New Database in SSMS
Cube Manager
- Viewing Dimensions in Cube Manager
- Creating a New Parent-Child Dimension
- Adding Members to a Dimension
- Importing a Flat List of Dimension Members
- Creating a New Parent-Child Dimension using Import
- Migrating to the Production Data Warehouse
- Copy Cube Manager Dimension Tables to DW Tables
- Clean up Members
- Convert from PC to Standard Dimension Tables
- Create Fact Tables
- Create Staging and Production Fact Tables
- Building the Cube
- Working with BIDS - Analysis Services
- Create a New Data Source in Analysis Services
- Create a New Data Source View in Analysis Services
- Setting up the Relationships with the Fact Table
- Building a Time Dimension
- Reordering the Members in the Dimension Hierarchy
- Build, Configure, and Process the Standard Dimensions
- Build, Configure, and Process the Parent Child Dimensions
- Building the Cube
- Building a Calculated Member and a Calculated Cell
- Setup Cube Writeback
- Design Cube Aggregation
Using SSIS for ETL, and Automation
- Populate the Staging Fact Table
- Loading Data from Staging to Production Fact Table
- Automation of Data Load
- Propagating Cube Manager Changes
MDX
Best Practices