Enable Technology

Database 

Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling




Course Overview


This intensive two day course is intended for SQL professionals and business intelligence professionals. The course covers the use of Analysis Services development tools to create and deploy multidimensional SSAS projects.

Duration: 2 day course



Course Content


Multidimensional models
Overview of SSAS Multidimensional Modelling
Using SQL Server Data Tools (SSDT)
Create an Analysis Services Project
Configure Analysis Services Project Properties
Deploy Analysis Services Projects
View the XML for an Analysis Services Project

Data Sources
Supported Data Sources
Create a Data Source
Delete a Data Source
Set Data Source Properties
Set Impersonation Options for a Data Source Connection
Data Source Views
Define a Data Source View
Add or Remove Tables or Views in a Data Source View
Explore Data in a Data Source View
Work with Diagrams in Data Source View Designer
Replace a Table or a Named Query in a Data Source View
Define Logical Relationships in a Data Source View
Define Logical Primary Keys in a Data Source View
Define Named Calculations in a Data Source View
Define Named Queries in a Data Source View
Delete a Data Source View

Dimensions
Create a Dimension Using the Dimension Wizard
Create a Dimension by Using an Existing Table
Create a Time Dimension by Generating a Time Table
Create a Dimension by Generating a Non-Time Table in the Data Source
Modify or Delete in Solution Explorer Database Dimensions
Create User-Defined Hierarchies
Ragged Hierarchies
Define Attribute Relationships
BI Wizard
Define a Regular Relationship and Regular Relationship Properties
Define a Referenced Relationship and Referenced Relationship Properties
Define a Fact Relationship and Fact Relationship Properties
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties

Measures and Measure Groups
Create Measures and Measure Groups
Configure Measure Group Properties
Use Aggregate Functions
Define Semiadditive Behavior
Defined Linked Measure Groups

Partitions
Create Local Partitions
Create Remote Partitions
Change a Partition Source
Designing Aggregations
Edit or Delete Partitions Merge Partitions
Set Partition Storage
Partition Writeback

Calculations
Create Calculated Members
Create Named Sets
Define Assignments and Other Script Commands
Define Time Intelligence
Calculations using the Business Intelligence Wizard
KPIs

Actions
Add a Standard Action
Test an Action
Use a Template to Create an Action

Deployment
Deployment Requirements and Considerations for Analysis Services Deployment
Deploy Model Solutions Using XMLA
Deploy Model Solutions Using the Deployment Wizard
Deploy Model Solutions with the Deployment Utility
Attach and Detach Analysis Services Databases
Backup and Restore of Analysis Services Databases
Backup Options Restore Options
Document and Script an Analysis Services Database
Modify or Delete an Analysis Services Database
Move an Analysis Services Database
Rename a Multidimensional Database

Processing a multidimensional model
Processing Options and Settings
Processing Databases, Dimensions and Partitions
Tools and Approaches for Processing
Batch Processing Remote Processing
Error Configuration

Roles and Permissions
Authorizing access to objects and operations
Database permissions
Cube or model permissions Process permissions
Read Definition permissions
Dimension permissions
Data Source object permissions






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;