SQL SERVER ANALYSIS SERVICES TRAINING COURSES BATH
About Enable Technology Bath SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. If you prefer we can offer an offsite training location in Bath. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Queen's Medical Centre Nottingham, Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, Halfords Group PLC, South Staffordshire Water PLC, GKN PLC, Nationwide Building Society Limited and Capita Group PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bath
- 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 ... Delete Relationships
- See Training Course Details...
Hide or freeze columns
Row filter mappings
Data sources supported in SSAS tabular 2016 Create Tabular Models
Delete a Column
Add a table Delete a Table
Import Data
Filter Data in a Table Relationships
Data sources supported in SSAS tabular 2017
Create and Manage Roles
Tabular model designer
Analyze in Excel
Create and Manage Measures KPIs
Data types supported
Topics include- Overview of SSAS Tabular models
Create a Relationship Between Two Tables
Sort Data in a Table
Data sources supported in tabular 1200 models
Process Database, Table, or Partition
Process Tabular Model Partitions
Rename a Table or Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bath
- 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 ... Create a Data Source
- See Training Course Details...
Define a Fact Relationship and Fact Relationship Properties
Set Partition Storage
Using SQL Server Data Tools (SSDT)
Create a Dimension Using the Dimension Wizard
Add or Remove Tables or Views in a Data Source View
Define Attribute Relationships
Use a Template to Create an Action Deployment
Batch Processing Remote Processing
Define Logical Primary Keys in a Data Source View
Delete a Data Source
Create Local Partitions
Supported Data Sources
Create Remote Partitions
Define Assignments and Other Script Commands
Read Definition permissions
Define Named Queries in a Data Source View
Modify or Delete an Analysis Services Database
Designing Aggregations
Backup and Restore of Analysis Services Databases
Defined Linked Measure Groups Partitions
Email us about this courses
Other Bath Enable Technology Training Courses
TSQL - Bath SQL Training Courses
DAX - Bath Excel Training Courses
Power Query Bath Training Courses
Excel Power Pivot Bath Training Courses
Excel 365 Basic Bath Training Courses
SSIS - Bath SQL Server Integration Services Training Courses