SQL SERVER ANALYSIS SERVICES TRAINING COURSES ROCHDALE
About Enable Technology Rochdale SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local training site in Rochdale. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Loughborough University, Fujistu PLC, Boots UK Limited, Yell Group PLC, Cadbury PLC, Dollond & Aitchison Limited, Carillion PLC and Birmingham Heartlands Hospital.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Rochdale
- Course Outline
-
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.
- Some of the training topics covered include ... Defined Linked Measure Groups Partitions
- See Training Course Details...
Using SQL Server Data Tools (SSDT)
Move an Analysis Services Database
Ragged Hierarchies
Set Partition Storage
Edit or Delete Partitions Merge Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Deploy Model Solutions Using the Deployment Wizard
Define Logical Primary Keys in a Data Source View
Test an Action
Modify or Delete an Analysis Services Database
Replace a Table or a Named Query in a Data Source View
Set Impersonation Options for a Data Source Connection
Configure Measure Group Properties
Deploy Model Solutions with the Deployment Utility
Supported Data Sources
Calculations using the Business Intelligence Wizard
Cube or model permissions Process permissions
Create a Data Source
Processing Options and Settings
Database permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Rochdale
- Course Outline
-
A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) . The course is aimed at Data Analysts and SQL professionals. No prior knowledge of SSAS is assumed.
- Some of the training topics covered include ... Add a table Delete a Table
- See Training Course Details...
Version comparison
Enable DirectQuery mode in SSMS
Tabular model designer
Data sources supported in SSAS tabular 2016 Create Tabular Models
Data types supported
Process Tabular Model Partitions
Create and Manage Perspectives Translations Roles
Impersonation
Create and Manage Partitions in the Workspace
Create and Manage Hierarchies Partitions
Delete Relationships
Deploy from SQL Server Data Tools Manage Tabular Model Databases
DirectQuery Mode
Create a New Tabular Model Project
Import data by using a native query
Import from Analysis Services
Import from Power Pivot
Test a model in DirectQuery mode
Create a Relationship Between Two Tables
Email us about this courses
Other Rochdale Enable Technology Training Courses
Excel 365 Basic Rochdale Training Courses
Data Warehouse Rochdale Training Courses
SSRS - Rochdale SQL Server Reporting Services Training Courses
Excel 365 Intermediate Rochdale Training Courses
TSQL - Rochdale SQL Training Courses
JQuery Mobile Rochdale Training Courses