SQL SERVER ANALYSIS SERVICES TRAINING COURSES ECCLES
About Enable Technology Eccles SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. 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. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local socially distanced venue in Eccles. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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 Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Norfolk Police Constabulary, Total Telecommunications Limited, Unipart Group, Cadbury PLC, Wolverhampton City Council, Lloyds TSB Bank PLC, Birmingham City University and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Eccles
- 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 ... Set Partition Storage
- See Training Course Details...
Batch Processing Remote Processing
Backup Options Restore Options
View the XML for an Analysis Services Project Data Sources
Defined Linked Measure Groups Partitions
Create User-Defined Hierarchies
Data Source object permissions
Document and Script an Analysis Services Database
Create an Analysis Services Project
Define Semiadditive Behavior
Create a Dimension Using the Dimension Wizard
Deploy Model Solutions with the Deployment Utility
Error Configuration Roles and Permissions
Create Remote Partitions
Set Impersonation Options for a Data Source Connection
Define a Fact Relationship and Fact Relationship Properties
Delete a Data Source
Edit or Delete Partitions Merge Partitions
Create a Data Source
Deploy Model Solutions Using the Deployment Wizard
Modify or Delete an Analysis Services Database
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Eccles
- 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 Partitions in the Workspace
- See Training Course Details...
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Tabular Model Partitions
Add columns to a table
Add a table Delete a Table
Create and Manage KPIs Hierarchies
Bi-directional cross filters Calculations
Data sources supported in SSAS tabular 2017
Define partitions in DirectQuery models
Change table, column
Version comparison
Sort Data in a Table
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Enable DirectQuery mode in SSDT
Data sources supported in tabular 1400 models
Process Database, Table, or Partition
Restore from Power Pivot
Import from Power Pivot
Create a Calculated Table
Create and Manage Perspectives Translations Roles
Email us about this courses
Other Eccles Enable Technology Training Courses
PL/SQL Eccles Training Courses
SSRS - Eccles SQL Server Reporting Services Training Courses
VBA - Eccles Excel Training Courses
Power BI Eccles Training Courses
Excel 365 Basic Eccles Training Courses
SSIS Eccles Training Courses