SQL SERVER ANALYSIS SERVICES TRAINING COURSES DENTON
About Enable Technology Denton SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
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 are also more than happy to organise a local course at a training location in Denton. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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 been delivering technical training in the Midlands for twenty years. Our clients include: Yell Group PLC, West Bromwich Building Society, Total Telecommunications Limited, Carillion PLC, Boots UK Limited, TalkTalk Direct Limited, Canadian High Commission and GKN PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Denton
- 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 ... Batch Processing Remote Processing
- See Training Course Details...
Create Named Sets
Set Impersonation Options for a Data Source Connection
Define a Fact Relationship and Fact Relationship Properties
Define Semiadditive Behavior
Create a Dimension Using the Dimension Wizard
Read Definition permissions
Create Remote Partitions
Change a Partition Source
Define Logical Relationships in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Configure Measure Group Properties
Dimension permissions
Modify or Delete an Analysis Services Database
Deploy Model Solutions Using the Deployment Wizard
Configure Analysis Services Project Properties
View the XML for an Analysis Services Project Data Sources
Data Source Views
Backup Options Restore Options
Set Data Source Properties
KPIs Actions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Denton
- 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 ... Deploy from SQL Server Data Tools Manage Tabular Model Databases
- See Training Course Details...
Data sources supported in tabular 1400 models
DirectQuery Mode
Topics include- Overview of SSAS Tabular models
Set the Data Type of a Column
Row filter mappings
Enable DirectQuery mode in SSMS
Database Process Partitions in the Workspace Database Perspectives
Bi-directional cross filters Calculations
Import Data
Tabular model designer
Import from Power Pivot
Process Tabular Model Partitions
Add columns to a table
Create a Calculated Table
Test a model in DirectQuery mode
Data types supported
Data sources supported in SSAS tabular 2017
Delete Relationships
Email us about this courses
Other Denton Enable Technology Training Courses
TSQL - Denton SQL Training Courses
Excel 365 Intermediate Denton Training Courses
Excel Power Pivot Denton Training Courses
SSIS - Denton SQL Server Integration Services Training Courses
SQL - Denton SQL Training Courses
VBA - Denton Excel Training Courses