Signup as a Tutor

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

"MS BI - SSIS, SSAS, SSRS" is no longer available

No Reviews Yet

Poddar Nagar, Kolkata

Course ID: 23431

Poddar Nagar, Kolkata

No Reviews Yet

About the Course

The course covers all aspects of MSBI - SSIS, SSAS, SSRS

Topics Covered

SSAS Introduction to Analysis Services • Introduction • Business Intelligence Queries • Architecture Options • Database Developments • Development, Management and Client Tools • Summary Dimensional Model Development • Introduction • Dimension wizard • Dimension designer • Unknown member • Attribute properties • Date dimension • User Hierarchies • Parent child hierarchy • Attribute relationship • Translation • Summary Cube Development • Data Source and Data Source Views • Computed and Named Queries • Building Entity Relationships • Deciding Data Warehouse Schema • Creating Dimensions and Builds • Attributes and Member Names • Choosing Dimension Templates • Applying Time Based Dimensions • Need for Hierarchies and Limitations • Attribute Relations and Uses • Building Levels and Hierarchies • Need for Composite Attribute Keys KPI Calculations and Partitioned Aggregations • Identifying Cube Entries for FASMI Rules • Measures and Additives (Full and Semi) • Defining Measure Groups and Measures • Cube Customizations and Options • BI Enhancements and Granularity • Building Fact Less Cube Dimensions • Calculations and Conditional Colors • MDX Scripting for Calculations • Defining KPIs and Goals using MDX • Perspectives using MDX Expressions • SSAS Actions with MDX and XMLA • Need for Cube Partitions and Query Binding • Local and Remote Server Partitions • Need for Storage Models – MOLAP and ROLAP • Generation of Aggregations on Partitions • Storage Modes and Proactive Caching • Hierarchies and Relations in Tabular Mode Security • Overview • User Security • Dimension Security • Cell Security • Administrator Security • Service amount configuration

Who should attend

.Net developer MS Developer


Basic knowledge of .Net

What you need to bring

Photo-id Photo

Key Takeaways

Learnings about MSBI Using SSAS

Date and Time

Not decided yet.

About the Trainer

Avg Rating

0 Reviews

3 Students

32 Courses


IT Service Professional

Arindam is an experienced .Net professional with several years of experience under his belt.

He has deep knowledge of the subject and makes it a point to explain concepts in a easy and fluid manner


No reviews currently Be the First to Review


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