SQL SERVER ANALYSIS SERVICES TRAINING COURSES DORSET
About Enable Technology Dorset SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Enable Technology training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Dorset. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Royal & Sun Alliance Group PLC, Capita Group PLC, Birmingham Heartlands Hospital, DHL Express, Cadbury PLC, Loughborough University, Yell Group PLC and Lloyds TSB Bank PLC.
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 ... Create and Manage Hierarchies Partitions
- See Training Course Details...
Create and Manage Perspectives Translations Roles
Import from Power Pivot
Process Tabular Model Partitions
Import from Analysis Services
Create and Manage Partitions in the Workspace
Understanding DAX in Tabular Models Measures
Analyze a tabular model in Excel Deploy tabular model solutions
Version comparison
Data types supported
Hide or freeze columns
Import Data
Tabular model designer
Delete a Column
Create and Manage Roles
Define partitions in DirectQuery models
Rename a Table or Column
Test a model in DirectQuery mode
Create a New Tabular Model Project
DAX formula compatibility in DirectQuery mode Tables and Columns
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 a Regular Relationship and Regular Relationship Properties
- See Training Course Details...
Tools and Approaches for Processing
Create Local Partitions
BI Wizard
View the XML for an Analysis Services Project Data Sources
Using SQL Server Data Tools (SSDT)
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Remote Partitions
Define Semiadditive Behavior
Create a Time Dimension by Generating a Time Table
Error Configuration Roles and Permissions
Create a Data Source
Define Logical Relationships in a Data Source View
Ragged Hierarchies
Create Measures and Measure Groups
Dimension permissions
Create a Dimension by Using an Existing Table
Delete a Data Source
Multidimensional models
Deployment Requirements and Considerations for Analysis Services Deployment
Calculations using the Business Intelligence Wizard
Email us about this courses
Other Dorset Enable Technology Training Courses
SSIS Dorset Training Courses
Access Dorset Training Courses
VBA Dorset Training Courses
Excel 365 Intermediate Dorset Training Courses
Power BI - Dorset Microsoft Power BI Training Courses
JavaScript - Dorset JavaScript Training Courses