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.

.

SSAS TRAINING OBJECTIVES

  • 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

SSAS TRAINING PREREQUISITES

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

SSAS TRAINING MATERIALS

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

SOFTWARE NEEDED FOR EACH PC:

  • 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.

SSAS TRAINING OUTLINE

  • 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.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

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

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