Home > Software Training Academy, Inc > SQL > SQL Server 2005 Analysis Services SSAS
Provided by: Software Training Academy, Inc

SQL Server 2005 Analysis Services SSAS

Computer

In this course, you will learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services..
LEARNING OBJECTIVES
Learn to define what Business Intelligence is and how it applies to a database.
Understand how the cube structure works for viewing data information.
View cubes using Excel 2007 and SQL Reporting Services.
See how to create cube models using SQL Server Business Intelligence Development Studio (BIDS).
Create Data Source, Data Source Views and then create cubes with the Cube Wizard.
Learn how to create key performance indicators (KPIs).
Work with changing and advanced dimension types.
Use relational and SSAS partitions.
Understand how to use MDX syntax for queries, functions and tasks.
Learn data mining concepts and mining structure processing.
Implement security, XMLA scripts, backups and restores for SSAS.
Prerequisites:
This course does not require any prior experience with Analysis Server 2008. It is assumed that students have working experience with SQL Server 2005 or 2008; basic relational database concepts (e. g., tables, queries, and indexing); data transformation services; Excel 2007; and SharePoint Server 2007.
This is primarily ilt training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
self directedThis is a self-directed course
study at homeThis course may be available for home-study
instructor led trainingThis class may be available at a classroom in Toronto, ON,
Course Level:introductory
Duration:flexible
Training Presented in:English
Training Provided by Software Training Academy, Inc
Click here for more information or to take this course
  • K asked: Hi, This is , i want project support and training on ssas & ssis. please contact me- or send me a mail to com
  • T asked: I like to do this course online. Can you please provide pricing etc.
  • R asked: How many hours is this training? How much does it cost?
  • S asked: I will be using SQL Server Design Management Studio to write reports pulling data from a Meditech Data Repository. I am very familar with MS Access, Visual Basic and MS Excel, but am not familiar with SQL Server. What would a good class (or series of classes) be for me? Thanks, , MPH Clinical Analyst Port Angeles, Washington
  • K asked: I would like to have a training on the SQL Server Analysis Services SSAS. Please send me the quote. I would like to have a online training if available. If it iw good i will recommend to my compnay. regards, .
SQL Server 2005 Analysis Services SSAS
v
About The Training Provider: Software Training Academy, Inc
Software Training Academy, Inc - Software Training Academy is company based in Seattle, WA (USA) and Toronto, ON (Canada) and it offers highly customized IT Training. Our portfolio includes Java, .NET, Web Development (PHP, Ruby on Rails, etc), Databases (Oracle, SQL Server, MySQL, DB2, etc) and Advanced courses for Microsoft Office. We deliver courses either onsite or in class throughout North America and Europe, and...
Click here for more information or to take this course
Home > Software Training Academy, Inc > SQL > SQL Server 2005 Analysis Services SSAS
Advertise With Us
Want to market your database training?
Custom Search
tcw11-v473M-01/21/12-07:01:41-()[B]-[A]-[B] -01:51:50