Course Duration in Hours
60
60
Introduction to Dataware Housing
Core Concept BI is the cube
Example cube as seen using Excel Pivot Table
Demonstrating of SSRS with cube as a Data Source
OLAP Modeling
Modeling source schemas Star and Snowflake Schema
Understanding dimensional modelingDimensions (Type 1, 2, or 3) or rapidly changing
Understanding fact (measures) and cube modeling
Using SSAS in Data Tools
Understanding the development environment
Creating Data Sources and Data Source Views
Creating cubes using the UDM and the cube Build Wizard
Refining Measures and Dimensions
Intermediate SSAS
KPIs
Perspectives
Translations cube metadata and Currency Localizations
Actions regular, drill-through and reporting
Advanced SSAS
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
Cube Storage and Aggregation
Storage topics Basic aggregations
Advanced Storage Design MOLAP,ROLAP,HOLAP
Partitions relational and Analysis Services Partitions
Customizing Aggregation Design - Processing Design
Any Graduates
STAR IT TECHNOLOGIES, Thane,IN