SQL SERVER ANALYSIS SERVICES TRAINING COURSES HEXHAM
About Enable Technology Hexham SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Hexham. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Unipart Group, Countrywide Homes Limited, Queen's Medical Centre Nottingham, Loughborough University, EDF Energy PLC, Halfords Group PLC, Norwich Union PLC and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Hexham
- 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 ... Edit or Delete Partitions Merge Partitions
- See Training Course Details...
Define Named Queries in a Data Source View
Backup Options Restore Options
Create a Dimension Using the Dimension Wizard
Set Impersonation Options for a Data Source Connection
Deploy Model Solutions Using XMLA
View the XML for an Analysis Services Project Data Sources
Configure Measure Group Properties
Error Configuration Roles and Permissions
Processing Options and Settings
Change a Partition Source
Define Logical Primary Keys in a Data Source View
Modify or Delete in Solution Explorer Database Dimensions
Create a Dimension by Generating a Non-Time Table in the Data Source
Define a Fact Relationship and Fact Relationship Properties
Create Remote Partitions
Define Attribute Relationships
Deployment Requirements and Considerations for Analysis Services Deployment
Dimension permissions
Ragged Hierarchies
Test an Action
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Hexham
- 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 ... Enable DirectQuery mode in SSDT
- See Training Course Details...
Create a Calculated Table
Understanding DAX in Tabular Models Measures
Add a table Delete a Table
Set the Data Type of a Column
Define partitions in DirectQuery models
Analyze a tabular model in Excel Deploy tabular model solutions
Database Process Partitions in the Workspace Database Perspectives
Delete a Column
Filter Data in a Table Relationships
Version comparison
Create and Manage Partitions in the Workspace
DirectQuery Mode
Data sources supported in tabular 1200 models
Create and Manage Roles
Change table, column
Create a Calculated Column
Enable DirectQuery mode in SSMS
Object-level security
Tabular model designer
Impersonation
Email us about this courses
Other Hexham Enable Technology Training Courses
PL/SQL Hexham Training Courses
Excel 365 Advanced - Hexham Excel Training Courses
Oracle SQL Hexham Training Courses
Report Builder Hexham Training Courses
JavaScript - Hexham JavaScript Training Courses
SSIS Hexham Training Courses