Visão Geral

Curso SQL Server Analysis Services Multidimensional Mode. Neste curso, você aprenderá a usar o Microsoft SQL Server Analysis Services (SSAS) para projetar e implementar cubos OLAP multidimensionais para dar suporte a soluções de Business Intelligence (BI). Você aprenderá sobre o ambiente de desenvolvimento do Microsoft SQL Server Visual Studio (versões do SQL Server Data Tools 2012 a 2017) para design, criação e implantação de projetos do SQL Server BISM (Business Intelligence Semantic Model) Multidimensional Mode, e o SQL Server Management Studio para o gerenciamento de bancos de dados multidimensionais. O Curso SQL Server Analysis Services Multidimensional Mode levará os delegados através da construção de um cubo multidimensional em sua forma mais simples até a extensão dos recursos dentro do cubo, implementando cálculos MDX, Indicadores-chave de desempenho (KPIs), Ações e Dimension/Cube Intelligence. A ênfase principal do curso é no design e criação de cubos, mas a administração básica e a segurança de cubos também são abordadas. Este curso é adequado para delegados que trabalham com todas as versões do SQL Server, do SQL Server 2012 ao SQL Server 2017. Este Curso SQL Server Analysis Services Multidimensional Mode pode ser oferecido em uma sala de aula presencial e em um ambiente virtual.

Pre-Requisitos

• Este Curso SQL Server Analysis Services Multidimensional Mode não requer nenhuma experiência anterior com o Analysis Services 2008/2012/2014/2016/2017. É assumido que os delegados tenham experiência de trabalho com o SQL Server 2005, 2008, 2012, 2014, 2016 ou 2017 e conceitos básicos de banco de dados relacional, como tabelas, consultas e indexação.

Materiais

Conteúdo Programatico

Introduction To SQL Server Analysis Services (SSAS)

1. Business Intelligence Semantic Model (BISM) Multidimensional Mode
2. BISM Tabular Mode
3. SQL Server Analysis Services 2012/2014/2016/2017

First Look at Multidimensional BISM

1. Development, Administrative & Client Tools
2. Upgrading to SSAS 2012/2014/2016
3. Using SQL Server Data Tools (SSDT - 2012/2014/2016/2017)
4. Multidimensional Applications
5. The Visual Studio Environment
6. Creating a Project
7. Creating an Analysis Services Database
8. Creating a Data Source
9. Creating a Data Source View
10. Creating a Cube
11. Using the Cube Wizard
12. Deploying Browsing a Cube
13. Using SQL Server Management Studio (SSMS)
14. Querying the Cube in the MDX Query Editor

Understanding MDX

1. What is MDX
2. MDX Concepts
3. Measures & Measure Groups
4. Hierarchies & Hierarchy Levels
5. Members
6. Cells
7. Tuples
8. Sets
9. MDX Queries
10. MDX Expressions: Operators & Functions

Data Sources & Data Source Views

1. Supported Data Sources
2. Creating Data Source Views: DSV Wizard & DSV Designer
3. Data Source Views in Depth
4. Multiple Data Sources Within a DSV

Dimension Design

1. Working with the Dimension Wizard
2. Working with the Dimension Designer: Attributes, Attribute Relationships, User Hierarchies
3. Browsing the Dimension
4. Sorting Members of a Level
5. Optimising Attributes
6. Defining Translations in Dimensions
7. Creating Snowflake Dimensions
8. Creating Parent-Child Hierarchies

Cube Design

1. The BISM Multidimensional Mode
2. Creating a Cube Using the Cube Wizard
3. Cube Dimensions
4. Relationship Types: No Relationship, Regular, Fact, Many-to-Many, Referenced
5. Measures & Measure Groups
6. Calculated Members: Calculations
7. Creating Perspectives
8. Creating Translations
9. Browsing Perspectives and Translations

Advanced Dimension Design

1. Custom Rollups
2. Unary Operators
3. Naming Levels In Parent-Child Hierarchies
4. Customising Dimension Properties: Ordering, All Member, Default Member, Unknown Member, Error Configurations, Storage Mode, Grouping Members
5. Dimension Intelligence: Account, Time and Dimension
6. Server Time Dimension
7. Dimension Writeback

8. Advanced Cube Design

9.  
10. Measure Groups & Measures
11. Adding & Enhancing Dimensions
12. Fact Relationships
13. Many-To-Many Relationships
14. Data Mining Dimensions
15. Role-Playing Dimensions
16. Adding Calculations To Cubes
17. Key Performance Indicators (KPIs)
18. Actions: URL redirection, Report redirection, Drill-through
19. Cube Intelligence: Semi-Additive Measures, Currency Conversion
20. Cube Partitions: Storage, Aggregation Design, Usage-based Optimisation
21. Real-Time Cubes
22. Defining Security
23. Cell Writeback
24. AMO Warnings

Administration & Management

1. Management Studio
2. Database Creation
3. Managing SSAS Objects
4. XMLA Scripts
5. Processing SSAS Objects
6. Managing Partitions
7. Backup & Restore
8. Detach and Attach
9. Synchronisation
10. Managing SSAS Security
11. Online Mode
12. Programmatic & Advanced Administration
13. Analysis Management Objects (AMO)

Designing Multidimensional BISM for Performance

1. Fine Tuning Dimensions & Cubes
2. Optimising For Processing
3. Designing Aggregations

Introduction to Data Mining, Multidimensional BISM, and Data Mining Add-Ins For Microsoft Office 2010/2013

1. Data Mining Process
2. Data Mining Algorithms
3. Data Mining Models
4. Using Data Mining with Excel

Analysing Cubes With Microsoft Office Components

1. Analysing Data in Excel: Pivot Tables, Pivot Charts
2. Analysing Data in PowerPivot

Other Features

1. Tabular Mode Overview
2. PowerPivot Overview
3. Power BI Overview