SQL SERVER ANALYSIS SERVICES TRAINING COURSES YSTRAD MYNACH
About Enable Technology Ystrad Mynach SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All of our tutors are Microsoft Certified Professionals. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local socially distanced training site in Ystrad Mynach. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are National Power PLC, EDF Energy PLC, Nationwide Building Society Limited, Canadian High Commission, Halfords Group PLC, Yell Group PLC, Boots UK Limited and Royal & Sun Alliance Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Ystrad Mynach
- 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 ... Modify or Delete an Analysis Services Database
- See Training Course Details...
Use a Template to Create an Action Deployment
Defined Linked Measure Groups Partitions
Create Measures and Measure Groups
Deployment Requirements and Considerations for Analysis Services Deployment
Using SQL Server Data Tools (SSDT)
Define Assignments and Other Script Commands
Define Logical Relationships in a Data Source View
Create a Dimension by Generating a Non-Time Table in the Data Source
Define Logical Primary Keys in a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
Test an Action
Attach and Detach Analysis Services Databases
Dimension permissions
Backup Options Restore Options
Processing Databases, Dimensions and Partitions
Create Remote Partitions
Set Data Source Properties
Move an Analysis Services Database
Define Attribute Relationships
Supported Data Sources
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Ystrad Mynach
- 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 ... Change table, column
- See Training Course Details...
DirectQuery Mode
Analyze in Excel
Add sample data to DirectQuery models
Import from Power View
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create a New Tabular Model Project
Bi-directional cross filters Calculations
Create a Relationship Between Two Tables
Create and Manage Tabular Model Partitions
Add columns to a table
Define partitions in DirectQuery models
Set the Data Type of a Column
Create and Manage Hierarchies Partitions
Data sources supported in SSAS tabular 2017
Import from Analysis Services
Enable DirectQuery mode in SSMS
Delete Relationships
Import data by using a native query
Email us about this courses
Other Ystrad Mynach Enable Technology Training Courses
Oracle SQL Ystrad Mynach Training Courses
Access VBA - Ystrad Mynach Access Training Courses
Power Query Ystrad Mynach Training Courses
TSQL - Ystrad Mynach SQL Training Courses
Excel 365 Basic Ystrad Mynach Training Courses
Data Warehouse - Ystrad Mynach SQL Training Courses