SSAS Online training|SSAS online training institutes

1
MICROSOFT SSAS ONLINE TRAINING
Powerpoint Templates
2

• SSAS SQL Server Analysis Services Course
  Content
• SUDEEP Technologies is one of the leading
  Training Company involved in providing Micro soft
  SSAS ONLINE TRAINING. Our Trainers are expert in
  providing Online Training with real time
  experience

3

• Topics
• What Is Microsoft BI?
• Using SSAS in BIDS
• Intermediate SSAS
• Advanced SSAS
• Cube Storage and Aggregation
• SSAS Administration
• Introduction to Reporting Clients

4
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

5
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 BID

6
Intermediate SSAS

• KPIs
• Perspectives
• Translations cube metadata and currency
  localization
• Actions regular, drill-through and reporting

7
Advanced SSAS

• Using multiple fact tables
• Modeling intermediate fact tables
• Modeling MM 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

8
Cube Storage and Aggregation

• 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

9
SSAS Administration

• Best practices health monitoring
• XMLA scripting (SQL Mgmt Studio)
• Security roles and permissions
• Disaster Recovery backup / restore

10
Introduction to Reporting Clients

• Excel 2007/  Power pivot
• SQL RS Report Builder
• SharePoint Performance Point Services 2010
• Contact us
• Ph 9700042555, 040-65240555
• Address 74-15-4, Swarna plaza, Auto Nagar,
  Terminal, Krishna Nagar, Vijayawada-520007
• Website URL
• http//www.sudeeptechnologies.com/courses/microsof
  t/microsoft-ssas-online-training/73

11
THANK YOU