microsoft sql server 2008 analysis services

global knowledge canada
calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg, canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' learn how to implement an analysis services solution in an organization. in this course, you will explore using the analysis services development tools toan analysis services database and an olap cube and using the analysis services management and administrative tools to manage an analysis services solution.

this course incorporates material form the official microsoft learning product (omlp) 6234: implementing and maintaining microsoft sql server 2008 analysis services.

what you’ll learn


how sql server analysis services can be used to implement analytical solutions
create multidimensional analysis solutions with sql server analysis services
implement dimensions and cubes in an analysis services solution
implement measures and measure groups in an analysis services solution
query a multidimensional analysis services solution
customize an analysis services cube
deploy and secure an analysis services database
maintain a multidimensional analysis services solution
implement a data mining solution
course outline


1. introduction to microsoft sql server analysis services
overview of data analysis solutions
overview of sql server analysis services
installing sql server analysis services
2. creating multidimensional analysis solutions
developing analysis services solutions
creating data sources and data source views
creating a cube
3. working with cubes and dimensions
configuring dimensions
defining attribute hierarchies
sorting and grouping attributes
4. working with measures and measure groups
working with measures
working with measure groups
5. querying multidimensional analysis solutions
mdx fundamentals
adding calculations to a cube
6. customizing cube functionality
implementing key performance indicators
implementing actions
implementing perspectives
implementing translations
7. deploying and securing an analysis services database
deploying an analysis services database
securing an analysis services database
8. maintaining a multidimensional solution
configuring processing
logging, monitoring, and optimizing an analysis services solution
backing up and restoring an analysis services database
9. introduction to data mining
overview of data mining
creating a data mining solution
validating data mining models
labs


lab 1: using sql server analysis services
installing sql server analysis services
verifying installation
lab 2: creating multidimensional analysis solutions
creating a data source
creating and modifying a data source view
creating and modifying a cube
lab 3: working with cubes and dimensions
configuring dimensions
defining relationships and hierarchies
sorting and grouping dimension attributes
lab 4: working with measures and measure groups
configuring measures
defining dimension usage and relationships
configuring measure group storage
lab 5: querying multidimensional analysis solutions
querying a cube by using mdx
creating a calculated member
defining a named set
lab 6: customizing cube functionality
implementing a kpi
implementing an action
implementing a perspective
implementing a translation
lab 7: deploying and securing an analysis services database
deploying an analysis services database
securing an analysis services database
lab 8: maintaining a multidimensional solution
configuring processing
implementing logging and monitoring
backing up and restoring an analysis services database
lab 9: introduction to data mining
creating a data mining structure
adding a data mining model
exploring data mining models
validating data mining models
...''

Elements of this syllabus are subject to change.

Phone:1-800-courses

School Address:

global knowledge - canada
535 legget drive
suite 200
kanata, on k2k 3b8 canada



Jobs & Resumes: calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg
Houses & Roommates: calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg
Travel Agencies: calgary, montreal, ottawa, toronto, vancouver, winnipeg

Search other schools for microsoft sql server 2008 analysis services training resources.

Effective Technical Communication
Communication and Negotiation Skills
Six Sigma Master Black Belt Certification
six sigma black belt certification
Six Sigma Jumpstart
Six Sigma Green Belt Certification
writing effective requirements
requirements development and management
CBAP Exam Prep
Implementing a SQL Server 2008 Database
Microsoft SQL Server 2008 Integration Services
microsoft sql server 2008 reporting services
SQL Server 2008
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services
microsoft sql server 2005 reporting services
Database Administrator
SQL Server 2005 Administration
sql server 2005 for business intelligence

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.