SQL SERVER ANALYSIS SERVICES TRAINING COURSES MILFORD HAVEN
About Enable Technology Milford Haven SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Milford Haven. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Cadbury PLC, Total Telecommunications Limited, Loughborough University, Homeserve PLC, Aston University, Norwich Union PLC, Nuclear Engineering Services and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Milford Haven
- 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...
Data sources supported in SSAS tabular 2016 Create Tabular Models
Understanding DAX in Tabular Models Measures
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Filter Data in a Table Relationships
Version comparison
Delete a Column
Set the Data Type of a Column
Delete Relationships
Bi-directional cross filters Calculations
Change table, column
Database Process Partitions in the Workspace Database Perspectives
Tabular model designer
Rename a Table or Column
Manage Roles by using SSMS
DAX formula compatibility in DirectQuery mode Tables and Columns
Import from Power View
Enable DirectQuery mode in SSMS
Import data by using a native query
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Milford Haven
- 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 ... Partition Writeback Calculations
- See Training Course Details...
Create Remote Partitions
Multidimensional models
Define Attribute Relationships
Deploy Model Solutions Using the Deployment Wizard
Delete a Data Source View Dimensions
Create a Time Dimension by Generating a Time Table
Explore Data in a Data Source View
Move an Analysis Services Database
Create an Analysis Services Project
Define a Fact Relationship and Fact Relationship Properties
Data Source Views
Processing Options and Settings
Database permissions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Deploy Analysis Services Projects
Use Aggregate Functions
Test an Action
Delete a Data Source
Modify or Delete in Solution Explorer Database Dimensions
Define Named Queries in a Data Source View
Email us about this courses
Other Milford Haven Enable Technology Training Courses
SSIS - Milford Haven SQL Server Integration Services Training Courses
Excel 365 Intermediate - Milford Haven Excel Training Courses
Access - Milford Haven Access Training Courses
Access VBA - Milford Haven Access Training Courses
Oracle SQL Milford Haven Training Courses
Report Builder Milford Haven Training Courses