SQL SERVER ANALYSIS SERVICES TRAINING COURSES YORKSHIRE
About Enable Technology Yorkshire SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology offers instructor led training taught by technology specialists. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If delivery onsite is an issue we will organise a socially distanced venue near you in Yorkshire. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Yell Group PLC, Loughborough University, Lloyds TSB Bank PLC, Barclays Bank PLC, Nuclear Engineering Services, Canadian High Commission, Aston University and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Yorkshire
- Telephone on 01952 938014
- 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 ... Define Semiadditive Behavior
- See Training Course Details...
Error Configuration Roles and Permissions
Set Impersonation Options for a Data Source Connection
Deploy Model Solutions Using XMLA
Create a Dimension by Using an Existing Table
Overview of SSAS Multidimensional Modelling
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create a Data Source
Define Attribute Relationships
BI Wizard
Define a Fact Relationship and Fact Relationship Properties
Delete a Data Source View Dimensions
Cube or model permissions Process permissions
Modify or Delete an Analysis Services Database
Create Remote Partitions
Attach and Detach Analysis Services Databases
Configure Measure Group Properties
Authorizing access to objects and operations
Change a Partition Source
Backup Options Restore Options
Deploy Model Solutions Using the Deployment Wizard
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Yorkshire
- Telephone on 01952 938014
- 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 ... Import from Power View
- See Training Course Details...
Create a New Tabular Model Project
Hide or freeze columns
Create a Calculated Column
Import from Power Pivot
Data sources supported in tabular 1200 models
Understanding DAX in Tabular Models Measures
Row filter mappings
Data sources supported in SSAS tabular 2016 Create Tabular Models
Delete Relationships
Process Tabular Model Partitions
Create and Manage Tabular Model Partitions
Specify Mark as Date Table for use with Time Intelligence
Database Process Partitions in the Workspace Database Perspectives
Restore from Power Pivot
Data types supported
DirectQuery Mode
Connect to a tabular model database
Object-level security
Email us about this courses
Other Yorkshire Enable Technology Training Courses
JQuery Mobile Yorkshire Training Courses
SQL Yorkshire Training Courses
PL/SQL - Yorkshire SQL Training Courses
JQuery - Yorkshire JavaScript Training Courses
VBA - Yorkshire Excel Training Courses
Oracle SQL - Yorkshire SQL Training Courses