Analysis Services Fundamentals Год выпуска: 08/2011 Производитель: Pluralsight Сайт производителя: pluralsight.com/courses/jscript-fundamentals Автор: Stacia Misner Varga Степень сложности: для начинающих Продолжительность: 6:31 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: This course explains how to develop Analysis Services databases, beginning with the dimensional modeling process and continuing with the development of dimensions and cubes. It also covers the integration of business logic into the cube by adding calculations, named sets, and key performance indicators. This course explains how to deploy and process Analysis Services databases and how to implement security for both users and administrators. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although most topics also apply to earlier versions of Analysis Services. Этот курс объясняет, как разработать базу данных служб аналитики, начиная с мерного моделирования и процесс продолжается с развитием измерений и кубов.
Содержание
Introduction to Analysis Services 16m 18s Introduction to Analysis Services 0m 56s Business Intelligence Queries 3m 42s Architecture Options 4m 0s Database Development 1m 37s Development, Management, and Client Tools 4m 18s Summary 1m 45s Dimensional Model Development 54m 52s Dimensional Model Development Overview 1m 20s Data Sources 3m 2s Demo: Creating a Data Source 4m 54s Top Down versus Bottom Up Design 1m 39s Top Down Design: Cube Wizard 3m 26s Top Down Design: Dimensions 2m 24s Demo: Using the Cube Wizard with Top Down Design 8m 0s Demo: Desigining Dimensions with Top Down 4m 3s Schema Generation Wizard 1m 47s Demo: Using the Schema Generation Wizard 3m 48s Data Source View 2m 24s Demo: Reviewing and Modifying a Top Down Data Source View 1m 39s Demo: Creating a New Data Source View from the Bottom Up 5m 29s Named Calculations 1m 4s Demo: Creating Named Calculations 2m 33s Named Queries 0m 55s Demo: Creating a Named Query 2m 34s Summary 3m 51s Dimension Development I 45m 40s Dimension Development Overview 1m 19s Dimension Wizard 1m 26s Demo: Using the Dimension Wizard to Create a Standard Dimension 6m 20s Dimension Designer 2m 2s Attributes 1m 25s Demo: Browsing a Dimension 1m 43s Demo: Combining Tables for Snowflake Dimension (Top Down Design) 2m 3s Demo: Using the Dimension Wizard to Create a Snowflake Dimension 2m 56s Demo: Using the Dimension Wizard to Create a Date Dimension (Bottom Up Design) 2m 28s Demo: Using the Dimension Wizard to Create a Date Dimension (Top Down Design) 2m 49s Demo: Comparing Top Down to Bottom Up Date Dimensions 2m 28s Unknown Member 1m 54s Demo: Working with the Unknown Member 3m 56s Basic Attribute Properties 2m 53s Demo: Configuring Attribute Properties 6m 15s Summary 3m 43s Dimension Development 2 45m 37s Dimension Development 2 Overview 0m 52s Date Dimension Properties 1m 55s Demo: Setting Properties for the Date Dimension 6m 16s Best Practice Warnings 1m 16s User Hierarchies 3m 3s Demo: Creating User-Defined Hierarchies 1m 57s Demo: Working with Best Practice Warnings 5m 13s Parent-child Hierarchy 1m 43s Demo: Creating a Parent-child Hierarchy 5m 40s Attribute Relationships 3m 2s Demo: Working with Attribute Relationships 5m 12s Translations 0m 59s Demo: Adding Translations to a Dimension 3m 53s Dimension Development Tasks 1m 19s Summary 3m 17s Cube Development I 44m 34s Cube Development Overview 0m 57s Cube Wizard 2m 11s Demo: Using the Cube Wizard to Create a Cube 4m 10s Cube Designer 1m 55s Measure Properties 1m 16s Aggregate Functions 3m 46s Demo: Configuring Measure Properties 2m 53s Role-Playing Dimension 1m 42s Demo: Reviewing the Cube Dimensions 1m 49s Demo: Deploying and Browsing the Cube 6m 59s Additional Measures 0m 51s Demo: Adding Measures and Dimensions to an Existing Cube 5m 50s Dimension Usage 3m 30s Demo: Changing Dimension Usage 5m 25s Summary 1m 20s Cube Development 2 24m 53s Cube Development 2 Overview 0m 59s Aggregations 4m 4s Demo: Using the Aggregation Wizard 6m 18s Demo: Viewing Aggregation Designs 3m 39s Perspectives 1m 35s Demo: Adding a Perspective 2m 21s Translations 0m 47s Demo: Adding Translations to a Cube 2m 15s Cube Development Tasks 1m 37s Summary 1m 18s Calculations 1 43m 28s Overview 1m 35s Calculation Designer 2m 12s Calculation Tools: Metadata 2m 2s Demo: Understanding Formulas 1m 58s Demo: Creating a Calculation to Sum Measures 4m 39s Demo: Testing a Calculation 2m 24s Calculation Tools: Functions 2m 45s Demo: Creating a Growth Calculation 5m 58s Demo: Testing the Growth Calculation 2m 9s Calculation Tools: Templates 1m 26s Demo: Creating a Ratio Calculation 6m 17s Color and Font Expressions 2m 18s Demo: Using Color and Font Expressions with Calculations 5m 16s Summary 2m 29s Calculations 2 26m 55s Overview 1m 0s Calculated Members of a Dimension 2m 28s Demo: Creating a Non-Measure Calculation 7m 14s Named Sets 1m 34s Demo: Creating a Named Set 4m 51s Key Performance Indicators 2m 59s Demo: Creating a Key Performance Indicators 4m 29s Summary 2m 20s Database Processing 48m 17s Overview 0m 49s BIDS Deployment 1m 42s Project Properties 3m 10s Demo: Understanding the Deployment Process 6m 57s Deployment Wizard 4m 53s Demo: Using the Analysis Services Deployment Wizard 6m 39s Storage Modes 4m 29s Effect of Updates 2m 1s Demo: Configuring the Storage Mode 2m 20s Processing 2m 25s Process Options 5m 50s Demo: Processing a Cube 4m 48s Summary 2m 14s Security 40m 59s Overview 1m 9s User Security 1m 26s Dimension Security 3m 23s Demo: Applying Dimension Security 7m 43s Demo: Testing Dimension Security 2m 10s Demo: Applying Dimension Security 1m 19s Demo: Working with Multiple Roles 5m 47s Demo: Working with a Default Member 2m 14s Cell Security 2m 16s Demo: Defining Cell Security 5m 12s Administrator Security 1m 31s Demo: Configuring Administrator Security 2m 14s Service Account Configuration 2m 22s Summary 2m 13s
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}