Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"SSAS" is no longer available

No Reviews Yet

Course type: Online Instructor led Course

Platform: Skype

Course ID: 24869

Course type: Online Instructor led Course

Platform: Skype

No Reviews Yet

About the Course

SQL Server Analysis Services

Topics Covered

What Is Microsoft Business Intelligence?
• Defining Microsoft Business Intelligence
• Understanding the UDM
• Building and Viewing a Sample Cube
• Viewing a Cube Using Excel
• Cubes in Reporting Services
• Using SSAS in BIDS
• Understanding BIDS
• Creating Data Sources
• Creating Data Source Views
• Creating a Cube Using the Wizard
• Refining Dimensions and Measures
Intermediate SSAS
• Creating KPIs
• Creating Perspectives
• Creating Translations
• Creating Actions
• Advanced SSAS
• Working with Multiple Fact Tables
• Using Advanced Dimension Types
• Working with Changing Dimensions
• Using the Business Intelligence Wizard
Cube Storage and Aggregation
• Basic Storage: MOLAP
• Customized Aggregations
• Advanced Storage: MOLAP, HOLAP, or ROLAP
• Implementing Proactive Caching
• Using Partitions: Relational or SSAS
• Cube and Dimensions Processing Options
Beginning MDX
• Understanding MDX
• About Members, Tuples, and Sets
• Common MDX Functions Explained
• New or Updated MDX Functions or Keywords
Advance MDX
• Understanding the Calculations Sub tab
• Adding Calculated Members
• Adding MDX Scripts
• Adding Named Sets
SSAS Administration
• Implementing SSAS Security
• Implementing XMLA Scripts
• Understanding SSAS Backup and Restore
• Understanding Performance Optimization

Who should attend

For SQL Server Developers and SSAS developers and MDX Developers


SQL Server Development

What you need to bring

Laptop or desktop with mike and headset"

Key Takeaways

Weekly materials and

Date and Time

Not decided yet.

Gallery (3)


Microsoft Business Inteligence





About the Trainer

Avg Rating




Veeren Chowdary

BTECH with 8 years experience

I am working in Product based company and I was in core MS BI frame work team for more than 8 years.

If you are looking for MSBI online and class room trainings with expert level course details and MDX,DAX topics with real Data engineering projects and interview tips and certifications please join my courses.


No reviews currently
Post your requirement and let us connect you with best possible matches for MSBI-SQL SERVER Training Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more