Signup as a Tutor

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

SSAS

No Reviews Yet

Course type: Online Instructor led Course

Platform: Skype

Course ID: 24869

Course type: Online Instructor led Course

Platform: Skype

Students Interested 0 (Seats Left 0)

₹ 10,000

No Reviews Yet

Date and Time

Not decided yet.

Veeren Chowdary

BTECH with 8 years experience

About Veeren Chowdary

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

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

Pre-requisites

SQL Server Development

What you need to bring

Laptop or desktop with mike and headset"

Key Takeaways

Weekly materials and

Reviews

No reviews currently

Gallery (3)

Video

Microsoft Business Inteligence

Document

SSAS

Document

Certification

Students Interested 0 (Seats Left 0)

₹ 10,000

Post your requirement and let us connect you with best possible matches for MSBI-SQL SERVER Training Post your requirement now
₹ 10,000 Enquire