MSBI
Ms-Bi online training Hyderabad India

Core concept – BI is the cube or UDM
Example cube as seen using Excel pivot table
MS BI is comprehensive – more than Analysis Services on SQL Server
Demonstration of SQL Reporting Services with cube as data source
Storage topics – basic aggregations, MOLAP
Advanced Storage Design – MOLAP,ROLAP, HOLAP
Partitions – relational and Analysis Services partitions
Customizing Aggregation Design – Processing Design
Rapidly changing dimensions / ROLAP dimensions
Welcome to the Real Time – Proactive Caching
Cube processing options
Understanding the development environment
Creating Data Sources and Data Source Views
Creating cubes – using the UDM and the Cube Build Wizard
Refining Dimensions and Measures in BIDS
Using multiple fact tables
Modeling intermediate fact tables
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions
Modeling changing dimensions – Dimension Intelligence w/ Wizard
Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence