Microsoft ProClarity Administrator Training Analysis Services 2005
Starting dates and places
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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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!
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.