Microsoft ProClarity Administrator Training Analysis Services 2005

Level
Total time
Logo Perpetual Solutions
Provider rating: starstarstarstarstar 10 Perpetual Solutions has an average rating of 10 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Prerequisites:

Before attending this course, students must have:

MCDBA (Microsoft Certified Database Administrator SQL 2000) or MCTS (Microsoft Certified Technology Specialist SQL Server) certification or equivalent knowledge.
Understanding of relational database concepts.
Use of the MS SQL 2005 tools (Microsoft SQL Server Management Studio SSMS and Business Intelligence Development Studio) would be a great advantage.

Course Description:

This three-day ILT course is aimed at administrators and developers who will be creating and maintaining an analytics solution for their organisation that will employ both Microsoft SQL Server Analysis server and ProClarity technologies. The course will allow th…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft ProClarity, Data Warehouse, MCTS, Microsoft Visual Studio(.NET) 2010, and Microsoft Access.

Prerequisites:

Before attending this course, students must have:

MCDBA (Microsoft Certified Database Administrator SQL 2000) or MCTS (Microsoft Certified Technology Specialist SQL Server) certification or equivalent knowledge.
Understanding of relational database concepts.
Use of the MS SQL 2005 tools (Microsoft SQL Server Management Studio SSMS and Business Intelligence Development Studio) would be a great advantage.

Course Description:

This three-day ILT course is aimed at administrators and developers who will be creating and maintaining an analytics solution for their organisation that will employ both Microsoft SQL Server Analysis server and ProClarity technologies. The course will allow the delegates to gain the knowledge to correctly design and build MSAS 2005 cubes which will lead to efficient and maintainable cubes that will perform well when browsed using ProClarity applications.

Delegates will learn how to:

  • Design a data warehouse structure geared towards Analysis Server
  • Design a data warehouse structure geared towards Analysis Server
  • Create dimensions and cubes
  • Use the Business Intelligence Enhancements
  • Browse the created cubes using ProClarity Standard client
  • Create calculated items (KPI, members and sets)
  • Design the storage structure for dimensions and cubes (MOLAP, ROLAP and HOLAP)
  • Secure the cube structure
  • Design the deployment infrastructure

This course includes the following modules:

Microsoft SQL Server Analysis 2005 overview

  • Review of AS 2005 architecture
  • Review of DW architecture
  • Review AS 2005 features and services

Introduction to cube design

  • Good schema design
  • Create a database
  • Data Source and Data Source View
  • Create a dimension and cube
  • Measure Groups
  • Perspectives
  • Process, build and deploy

Advanced cube design concepts

  • Time dimensions
  • Business Intelligence Enhancements
  • Actions
  • Distinct counts
  • Linked items

Calculations, sets and KPIs

  • Calculated members
  • KPI
  • Business Logic Server

Visualisation with ProClarity

  • View SSAS cube using ProClarity
  • Integrate ProClarity with MS SQL Reporting Services

Processing and Storage

  • Processing options
  • Aggregations
  • Usage based optimisation
  • Storage modes
  • Proactive caching
  • Write-back

Security

  • Security architecture
  • Security database objects
  • Dimension data security
  • How ProClarity products work with the AS 2005 security

Deployment

  • Archive and restore cube data
  • Managing development to production environments
  • Using profiler to monitor query access

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.