Introduction to SQL Server 2012 / 2014 Analysis Services (SSAS)

Introduction to SQL Server 2012 / 2014 Analysis Services (SSAS)


Bascom Bridge’s  SSAS training provides attendees with knowledge and experience working with SQL Server 2012 / 2014 multi-dimensional Analysis Services development, administration, and queries.

This course includes an introduction to MDX, but does not provide the same level of depth as our three-day MDX course. If you’re interested in detailed coverage of both SSAS and MDX, please contact usand let us know – we could deliver a customized five-day course covering both SSAS and MDX.



  • Perform OLAP modeling
  • Store and aggregate data cubes
  • Write multi-dimensional expressions (MDX)
  • Administer SSAS
  • Use SSAS in conjunction with reporting clients and Microsoft Office


All SSAS training attendees should have prior experience with SQL Server 2012 or 2014.


All SSAS training students receive a copy of Wrox Press’ Professional Microsoft SQL Server Analysis Services with MDX and DAX.


  • SQL Server 2012 or 2014, including Analysis Services.
  • If you have purchased this course, please contact us for a detailed setup sheet.
  • For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.


  • Introduction
  • What Is Microsoft Business Intelligence?
    • Define Business Intelligence
    • Understand the Cube Structure
    • Deploy and View a Sample Cube
    • View a Cube by using Excel
    • View a Cube by using SQL Reporting Services
  • OLAP Modeling
    • Understand Basic OLAP Modeling (star schema)
    • Understand Dimensional Modeling (stars and snowflakes)
    • Understand Measure (fact) and Cube Modeling
  • Introduction to SQL Server Data Tools (SSDT)
    • Create Data Sources
    • Create Data Source Views
    • Create Cubes by using the Cube Wizard
    • Understand the Development Environment
  • Intermediate SSAS
    • Learn how to Create Key Performance Indicators (KPIs)
    • Discover how to Create Perspectives
    • See how to Create Translations for Cubes and Dimensions
    • Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting
  • Advanced SSAS
    • Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS
    • Explore Advanced Dimension Types
    • Learn how to use the Business Intelligence Wizard
    • Understand Writeback in Dimensions
    • Review Semi-Additive Measures in OLAP Cubes
  • Cube Storage and Aggregation
    • View Aggregation Designs
    • Customize Aggregation Designs
    • Implement Proactive Caching
    • Use Relational and SSAS Partitions
    • Customize Cube and Dimension Processing
  • Introduction to MDX Queries
    • Understand Basic MDX Syntax
    • Use the MDX Query Editor in SSMS
    • Understand Common MDX Functions and Tasks
    • Review MDX Functions New to SSAS 2012
  • MDX Expressions
    • Understand the Calculation Subtab
    • Learn how to add Calculated Members
    • Explore how to add MDX Script Commands
    • Discover how to add .NET Assemblies
  • Introduction to Data Mining
    • Understand Data Mining Concepts
    • Review the Algorithms that SSAS Includes
    • Consider Data Mining Clients
    • Understand Mining Structure Processing
  • SSAS Administration
    • Implement SSAS Security
    • Implement XMLA Scripts in SSMS
    • Deploy and Synchronize Databases
    • Understand SSAS Database Backup and Restore
  • Advanced Administration and Optimization
    • Implement SSIS to Manage SSAS Databases
    • Explore Clustering
    • Explore Scalability Options
    • Understand Performance Tuning and Optimization
  • Introduction to SSAS Clients
    • Design Reports using Reporting Services
    • Design Reports by using Report Builder
    • Implement Excel Pivot Tables and Charts
    • Use Excel as a Data Mining Client
    • Review Microsoft Office SharePoint Server
  • Conclusion

Send a Comment

Your email address will not be published.


+91 9376007676  



Introduction to SQL Server 2012 / 2014 Analysis Services (SSAS)

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
  • Course No : SQL-322
  •  Theory : 50%
  •  Lab : 50%
  • Duration : 18 hours
Scroll Up
Skip to toolbar