SQL SERVER ANALYSIS SERVICES TRAINING COURSES DORSET
About Enable Technology Dorset SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. We are also more than happy to organise a local course at a socially distanced training location in Dorset. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Birmingham City University, Cadbury PLC, GKN PLC, Total Telecommunications Limited, Keele University, Queen's Medical Centre Nottingham, Yell Group PLC and Wolverhampton City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Dorset
- 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 ... Process Database, Table, or Partition
- See Training Course Details...
Data sources supported in SSAS tabular 2016 Create Tabular Models
Data types supported
Connect to a tabular model database
Import Data
Enable DirectQuery mode in SSDT
Import from Analysis Services
Create and Manage Perspectives Translations Roles
Tabular model designer
Data sources supported in SSAS tabular 2017
Add columns to a table
Import from Power Pivot
Delete a Column
Define partitions in DirectQuery models
Restore from Power Pivot
Create a Calculated Column
Change table, column
Rename a Table or Column
Bi-directional cross filters Calculations
Database Process Partitions in the Workspace Database Perspectives
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Dorset
- 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...
Define Assignments and Other Script Commands
Supported Data Sources
BI Wizard
Create a Dimension Using the Dimension Wizard
Define Named Queries in a Data Source View
Define a Referenced Relationship and Referenced Relationship Properties
Processing Options and Settings
Create Local Partitions
Deploy Model Solutions Using the Deployment Wizard
Add or Remove Tables or Views in a Data Source View
Add a Standard Action
Tools and Approaches for Processing
Replace a Table or a Named Query in a Data Source View
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Edit or Delete Partitions Merge Partitions
Backup and Restore of Analysis Services Databases
Create Remote Partitions
Use a Template to Create an Action Deployment
Cube or model permissions Process permissions
Attach and Detach Analysis Services Databases
Email us about this courses
Other Dorset Enable Technology Training Courses
Excel 365 Advanced - Dorset Excel Training Courses
Data Warehouse Dorset Training Courses
PL/SQL - Dorset SQL Training Courses
Access VBA - Dorset Access Training Courses
Excel 365 Intermediate Dorset Training Courses
Oracle SQL - Dorset SQL Training Courses