SQL SERVER ANALYSIS SERVICES TRAINING COURSES YORK
About Enable Technology York SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. Alternatively we could schedule a course at a local venue in York. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
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 over twenty years continuous technical training experience. Some of our clients are Capita Group PLC, University of Birmingham, National Power PLC, Royal Air Force, Total Telecommunications Limited, Countrywide Homes Limited, Unipart Group and TalkTalk Direct Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: York
- 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 ... Create a New Tabular Model Project
- See Training Course Details...
Add columns to a table
Bi-directional cross filters Calculations
Process Tabular Model Partitions
Filter Data in a Table Relationships
Tabular model designer
Create a Calculated Table
Restore from Power Pivot
Manage Roles by using SSMS
Data sources supported in tabular 1200 models
Process Database, Table, or Partition
Create and Manage Roles
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create and Manage Measures KPIs
Data sources supported in SSAS tabular 2017
Analyze a tabular model in Excel Deploy tabular model solutions
DAX formula compatibility in DirectQuery mode Tables and Columns
Object-level security
Create and Manage Hierarchies Partitions
Sort Data in a Table
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: York
- 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 ... Supported Data Sources
- See Training Course Details...
Define Semiadditive Behavior
Define Logical Relationships in a Data Source View
Modify or Delete an Analysis Services Database
Attach and Detach Analysis Services Databases
Create User-Defined Hierarchies
Move an Analysis Services Database
Database permissions
Delete a Data Source
Delete a Data Source View Dimensions
Test an Action
Replace a Table or a Named Query in a Data Source View
Explore Data in a Data Source View
Create a Dimension Using the Dimension Wizard
Create a Dimension by Using an Existing Table
Ragged Hierarchies
Define Attribute Relationships
Defined Linked Measure Groups Partitions
Configure Measure Group Properties
Create Calculated Members
Set Impersonation Options for a Data Source Connection
Email us about this courses
Other York Enable Technology Training Courses
Report Builder - York SQL Server Reporting Services Training Courses
SQL - York SQL Training Courses
Excel 365 Advanced - York Excel Training Courses
Oracle SQL - York SQL Training Courses
Access - York Access Training Courses
Power Query York Training Courses