 |
|
|
|
|
|
|
Classifieds: Education / Training | | MSBI Online Training at NipunaOnline.com | | Posted By: nipuna onlinetraining at: 12, Jun 2012 9:46:40 PM IST | MSBI onlinetraining at Nipunaonline.com
MSBI
SQL Server 2008 Analysis Services
What Is Microsoft BI?
• 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
OLAP Modeling
• Modeling source schemas—stars and snowflakes
• Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
• Understanding fact (measures) and cube modeling
• Other types of modeling—data mining etc…
Using SSAS in BIDS
• 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
Intermediate SSAS
• KPIs
• Perspectives
• Translations – cube metadata and currency localization
• 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, write back dimensions
• Modeling changing dimensions – Dimension Intelligence w/ Wizard
• Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence
Visit Us
http://nipunaonline.com/
Email ID : info@nipunaonline.com
Email ID : nipunaonlinetraining@gmail.com
Skype ID : nipunaonline@skype.com
Contact us
India : +91 789 300 5400
USA : + 01 985 400 3134
|
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
