SQL SERVER 2014 ANALYSIS SERVICES (SSAS)

1 Course ID : MS-SQL-14-AS - 1/5 - SQL SERVER 2014 ANALYSIS SERVICES (SSAS) ( 2008-2012) : Database : 3 Days (18 Hours) Learning Level : Beginner Microsoft SQL SERVER ANALYSIS Service Microsoft SQL SERVER Development CPU: QUAD CORE (I3,I5,I7 prefer) Intel Virtualization Technology (Intel VT) or AMD Virtualization (AMDV) RAM: 8 GB (Recomended 12 GB) Hard Disk: Dual 500 GB hard disks 7200 RPM SATA Network Adapter with Internet Connection OS: Windows SERVER 2012 with Hyper-V Course Objectives Write SELECT queries Query multiple tables Use built-in functions Use subqueries Execute stored procedures Use set operators Implement error handling Course ID.

2 MS-SQL-14-AS - 2/5 - Implement transactions Use table expressions Sort and filter data Use window ranking, offset and aggregate functions Query SQL SERVER metadata Program with T-SQL Improve query performance Course Outline 1 Introduction to SSAS 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 2 OLAP Modeling Understand Basic OLAP Modeling (star schema) Understand Dimensional Modeling (stars and snowflakes) Understand Measure (fact) and Cube Modeling 3 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 Course ID : MS-SQL-14-AS - 3/5 - 4 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.

3 Regular, Drill-through, and Reporting 5 Advanced SSAS Work with Multiple Fact Tables and the Dimension Usage Tab in SSDT (Role-playing Dimensions) Explore Advanced Dimension Types Learn how to use the Business Intelligence Wizard Understand Write-Enabled Dimensions Review Semi-Additive Measures in OLAP Cubes 6 Cube Storage and Aggregation View Aggregation Designs Customize Aggregation Designs Implement Proactive Caching Use Relational and SSAS Partitions Customize Cube and Dimension Processing 7 Introduction to MDX Queries Understand Basic MDX Syntax Use the MDX Query Editor in SSMS Understand Common MDX Functions and Tasks Course ID.

4 MS-SQL-14-AS - 4/5 - 8 MDX Expressions Understand the Calculation TAB Learn how to add Calculated Members Explore how to add MDX Script Commands Discover how to add .NET Assemblies 9 Introduction to Data Mining Understand Data Mining Concepts Review the Algorithms that SSAS Includes Consider Data Mining Clients Understand Mining Structure Processing 10 SSAS Administration Implement SSAS Security Implement XMLA Scripts in SSMS Deploy and Synchronize Databases Understand SSAS Database Backup and Restore 11 Advanced Administration and Optimization Implement SSIS to Manage SSAS Databases Explore Clustering Explore Scalability Options Understand Performance Tuning and Optimization 12 Introduction to SSAS Clients Design Reports using Reporting SERVICES Course ID.

5 MS-SQL-14-AS - 5/5 - Design Reports by using Report Builder Implement Excel 2013 Pivot Tables and Charts Use Excel 2013 as a Data Mining Client