Kameswara Sarma Uppuluri


SSAS 2012

Your Instructor for this course is Kameswara Sarma Uppuluri.

He is an accomplished Senior Technical Corporate Trainer here in India and a consultant. He has been a Microsoft Certified Trainer since 2004 and a Microsoft Certified Professional since 1998. He has delivered various trainings at client places, on Microsoft Technologies for top MNC's in India .

He is passionate about teaching developers how to make the most out of their chosen technologies and doing web development in the best way possible.

He has spent years of developing course materials and teaching professional developers online throughout the world.

He has worked in technology for 16 years, specializing in web Development,Content Management Systems,databases and business intelligence.

He is an independent consultant that enjoys development and teaching.

He is a consultant based in Hyderabad, India. He has over 16 years of experience in the IT field, and over a decade of experience as a trainer.

He is an expert in SharePoint Development/Configuration/,Administration and .NET development and Database business intelligence technologies.


Watch Free Training Videos

See our Microsoft Certified Expert Trainers in action!

We've got Free Videos for you.

ITAcademy.IN has hours of free IT training videos online for each course.
Watch these videos taken directly from our "Live Instructor-led training sessions.

These videos are exactly the same quality that you get if you purchase one of our courses.

Our Complete List of
Free Videos

What is SSAS ?

SQL Server 2008 Analysis Services (SSAS) is the multidimensional online analytical processing (OLAP) component of Microsoft SQL Server 2008 that integrates relational and OLAP data for business intelligence (BI) analytical solutions.SAS is an enterprise-level Extract,Transform and Load (ETL) Development tool.

 What are the benefits of SSAS?

• User friendly BIDS (Business Intelligence Development Studio) editor helps you to create,
maintain and
deploy,process SSAS cubes.
• Monitoring Analysis Services Using Windows Reliability and Performance Monitor
• Analysis Services Dynamic Management Views

 Audience Profile:

This course is equally beneficial for those people who want to learn SSAS from scratch or who are

already involved in developing cubes using earlier versions of SSAS..


This course assumes that Students have already been introduced to any one database software like Access,Oracle,MySql,SqlServer etc. We provide you 6 hours of free Sql Server 2008 Development course, in case, you don’t have any exposure to any database software.

 Our Trainer's Profile :

• Our Trainers speak from Experience
• Our Trainers Are Subject Matter Experts
• Our Trainers Are Expert instructors
• Our Trainers are Microsoft Certified
• Our Trainers have more than 16+ years of experience on Microsoft Technologies
 Career Path:

After completing this course you will be able to take up the roles of
• SSAS Developer
 Certification Path:

Those who completes all 3 modules of this course, will be able to prepare for the following Microsoft Certification Exam:

Exam 70-467: : Designing Business Intelligence Solutions with Microsoft SQL Server 2012

SQL Server Analysis Services 2012


Due to your time schedule / time zone differences, If you cannot attend our courses live, you can now as well buy the complete course videos from us. You can download our videos and can be played offline at your end.

SQL Server Analysis Services 2012
Beginners to Advanced
Release Date
Exercise Files
We have got Free Videos for you, Please Click here.
Why you should choose ITAcademy.IN as your Online Training provider?
    • We are into training industry for more than 16+ years.
    • Scenario Based Training.
    • Certification Exam preparation.
    • Our trainers are certified and qualified with Real-World experience.
    • Our Large List of Satisfied Students & Clients Around the World.
    • Students will have access to soft copies of all the Case Studies and other examples used during the sessions.
    • We provide complete guidance towards MCP Certification Exams.
    • Step by Step Lab Manuals and Course Materials.
    • Resume and Interview Preparation Guidance.

Lesson 1 - Introduction to SSAS

In this lesson, we will cover the following topics.


•Overview of SSAS
•Attributes in Data Analysis
•Hierarchies in Data Analysis
•Dimensions in Data Analysis
•Understanding Fact Table
•Understanding Dimension Tables
•Surrogate Keys
•Multidimensional OLAP

Lesson 2 - Developing Cubes

In this lesson, we will cover the following topics.


•Understanding the development environment
•Creating Data Sources
•Creating Data Source Views
•Creating cubes
•Browsing Cubes

Lesson 3 - Developing Cubes

In this lesson, we will cover the following topics.


•Creating a Cube
•Creating Named Calculations
•Creating Named Queries

Lesson 4 - Aggregations

In this lesson, we will cover the following topics.


•Aggregation Concepts
•Using Aggregations
•Aggregation Wizard Optimizations
•Aggregation Designer

Lesson 5 - Creating Partitions

In this lesson, we will cover the following topics.


•Partitioning Strategy
•Partition Storage
•Configuring Storage Modes
•Partition Design
•Using the Partition Wizard
•Merging Partitions

Lesson 6 - Creating KPI's, Perspectives, Tranlations

In this lesson, we will cover the following topics.


•Developing KPI's
•Creating Perspectives
•Creating Translations

Lesson 7 - Working with Actions

In this lesson, we will cover the following topics.


•Attaching Drill-Through Actions
•Creating Reporting Actions
•Creating Regular Actions

Lesson 8 - Security

In this lesson, we will cover the following topics.


•User Security
•Dimension Security
•Applying Dimension Security
•Working with Multiple Roles
•Working with a Default Member
•Cell Security
•Administrator Security
•Service Account Configuration

Lesson 9 - Deployment

In this lesson, we will cover the following topics.


•BIDS Deployment
•Project Properties
• Understanding the Deployment Process
•Deployment Wizard
•Storage Modes
•Configuring the Storage Mode
•Process Options
•Processing a Cube

Lesson 10 - Using MDX Queries

In this lesson, we will cover the following topics.


•Basic syntax
•Using the MDX query editor in SQL Server Management Studio
•Working with MDX Functions

Due to your time schedule / time zone differences, If you cannot attend our courses live, you can now as well buy the complete course videos from us. You can download our videos and can be played offline at your end.

Q)How do i get access to demo videos of this course?
A)Please write to "support@itacademy.in" to have our "Live Demo Videos". We shall arrange you 2 demo videos to your end. Upon watching the same, if you find yourself happy, you can buy the complete videos of this course.

Q)What payment options do i have?
A)Please Write to "Support@itacademy.in" for payment options or for any other queries, you may have related to buying the course videos.

Q)How have you recorded these sessions?
A)Please be noted, all these videos are of live recording videos. It means, while our trainers delivers online training to participants, these sessions were recorded. Thus at times, you might hear the conversation between the participants and trainer as doubts being clarified.

Q)What should I do, if i find a faulty video file / corrupted video file?
A)We have ensured to a greater extent, that our videos are free from any kind of noise disturbances. If we have overlooked any such video, and you find any video of such type, please write back to us and we shall replace the video file with a fresh one, within 3 days from the date of your request at free of cost.

Q)What do I do, if i get a doubt, while watching videos?
A)While watching videos, if you get any doubts, you can write to "support@itacademy.in" and our trainer will attend your query, either by email with in 24 hrs from the date of receipt of your query, if that can be clarified so, else, our trainer will invite you for a live meeting on a specific date at free of cost.

Q)When do i get access to your videos?
A)Upon receiving the payment, we shall send you "URL's" to download our complete course videos. Please be noted, you are supposed to complete downloading the videos within 7 days from the day, download URL is been arranged to you by email. Afterwards, URL will be deactivated automatically.

Q)How do i play your videos?
A)You can play the videos using "Windows Media Player". All our video files, have an extension of ".WMV".

Q)Can i download exercise files as well?
A)Yes, all exercise files, that were used by the trainer as part of sessions, are downloadable along with the videos.

Q)Will i have access to future videos of this course?
A)Yes, as and when, we add new set of topics to courses, we intimate you to download new set of videos by email.

Q)What do i get from you, once I buy a course?
A)You get access to download complete course videos along with Exercise files.

Q)Will i get discount offers, if i wish to buy more courses from you?
A)Yes, you can write to "support@itacademy.in" stating the same and we shall assist you on the same.

Final Note : We request you to use these videos, for your personal purpose. We hope you understand, the efforts that our trainers / any trainer for that matter, puts up in making these videos.


Client Testimonials

What really impressed me, is their "Day Wise Course Outlines" of MSBI 2008 Course.  So at the time of paying fee, I know, what  for I am paying for.  All topics that were put in "Course Outline" were covered and that too, in the same order.



Client Testimonials

"As a student, I look for trainers who can communicate their subject in an easily understood manner and at ITAcademy.IN, I found their trainers just too good. I have learned MSBI 2008 at ITAcademy.IN and this course fits my bill."

Tarun Reddy
New Delhi


Client Testimonials

" I enjoyed MSBI 2008 course at ITAcademy.IN. So simple to listen to their trainers explanation and understand."



© Copyright 2010 - 2014 | ITAcademy.IN | All trademarks and logos are the sole property of their respective owners.