SQL SERVER ANALYSIS SERVICES TRAINING COURSES LLANTRISANT
About Enable Technology Llantrisant SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Professionals. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Llantrisant. We are happy to modify the SQL Server Analysis Services syllabus to match your teams 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Vodafone Group Services, Nuclear Engineering Services, Norfolk Police Constabulary, Dollond & Aitchison Limited, Loughborough University, West Bromwich Building Society, GKN PLC and University of Birmingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Llantrisant
- 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 ... Database permissions
- See Training Course Details...
Deploy Model Solutions Using the Deployment Wizard
Define a Data Source View
Data Source object permissions
Modify or Delete an Analysis Services Database
Define Logical Relationships in a Data Source View
Create Measures and Measure Groups
Use a Template to Create an Action Deployment
Deploy Analysis Services Projects
Overview of SSAS Multidimensional Modelling
Backup Options Restore Options
Backup and Restore of Analysis Services Databases
Authorizing access to objects and operations
Use Aggregate Functions
Add or Remove Tables or Views in a Data Source View
Define Logical Primary Keys in a Data Source View
Create a Data Source
Create Remote Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Partition Writeback Calculations
Create a Dimension Using the Dimension Wizard
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Llantrisant
- 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 Data
- See Training Course Details...
Import from Power View
Rename a Table or Column
Set the Data Type of a Column
Data sources supported in SSAS tabular 2016 Create Tabular Models
Understanding DAX in Tabular Models Measures
Add columns to a table
Add sample data to DirectQuery models
Connect to a tabular model database
Tabular model designer
Import from Analysis Services
Sort Data in a Table
Filter Data in a Table Relationships
Specify Mark as Date Table for use with Time Intelligence
Version comparison
Data sources supported in tabular 1400 models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Import data by using a native query
Email us about this courses
Other Llantrisant Enable Technology Training Courses
SQL - Llantrisant SQL Training Courses
SSRS Llantrisant Training Courses
VBA Llantrisant Training Courses
Excel 365 Basic - Llantrisant Excel Training Courses
DAX Llantrisant Training Courses
TSQL - Llantrisant SQL Training Courses