SQL SERVER ANALYSIS SERVICES TRAINING COURSES WORCESTER
About Enable Technology Worcester SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The tutor delivering the course will be a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a venue near you in Worcester. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Norfolk Police Constabulary, DHL Express, Unipart Group, Norwich Union PLC, EDF Energy PLC, Fujistu PLC, Nationwide Building Society Limited and National Power PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Worcester
- 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 and Manage Partitions in the Workspace
- See Training Course Details...
Row filter mappings
Process Tabular Model Partitions
Import data by using a native query
Connect to a tabular model database
Delete Relationships
Delete a Column
DirectQuery Mode
DAX formula compatibility in DirectQuery mode Tables and Columns
Understanding DAX in Tabular Models Measures
Version comparison
Tabular model designer
Filter Data in a Table Relationships
Data sources supported in SSAS tabular 2017
Restore from Power Pivot
Impersonation
Object-level security
Data sources supported in SSAS tabular 2016 Create Tabular Models
Change table, column
Import from Power View
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Worcester
- 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 ... KPIs Actions
- See Training Course Details...
Create Calculated Members
Deployment Requirements and Considerations for Analysis Services Deployment
Attach and Detach Analysis Services Databases
Move an Analysis Services Database
Define a Data Source View
Create Named Sets
Define Time Intelligence
Use a Template to Create an Action Deployment
Delete a Data Source View Dimensions
BI Wizard
Data Source Views
Database permissions
Create a Data Source
Add or Remove Tables or Views in a Data Source View
Create User-Defined Hierarchies
Dimension permissions
Ragged Hierarchies
Using SQL Server Data Tools (SSDT)
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Set Data Source Properties
Email us about this courses
Other Worcester Enable Technology Training Courses
Excel 365 Intermediate - Worcester Excel Training Courses
SQL Worcester Training Courses
Access VBA Worcester Training Courses
PL/SQL Worcester Training Courses
TSQL Worcester Training Courses
Power Query Worcester Training Courses