SQL SERVER ANALYSIS SERVICES TRAINING COURSES STAFFORD
About Enable Technology Stafford SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the SQL Server Analysis Services course at a local training venue in Stafford. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services 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: Halfords Group PLC, Homeserve PLC, Dollond & Aitchison Limited, University of Birmingham, Barclays Bank PLC, GKN PLC, Birmingham Heartlands Hospital and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stafford
- 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 Named Queries in a Data Source View
- See Training Course Details...
Deploy Model Solutions Using XMLA
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Edit or Delete Partitions Merge Partitions
Define Logical Relationships in a Data Source View
Define a Data Source View
Create a Dimension by Using an Existing Table
Attach and Detach Analysis Services Databases
Backup and Restore of Analysis Services Databases
Define Attribute Relationships
Use a Template to Create an Action Deployment
Define Semiadditive Behavior
Designing Aggregations
Move an Analysis Services Database
Create an Analysis Services Project
Data Source object permissions
Database permissions
Backup Options Restore Options
Create Measures and Measure Groups
Supported Data Sources
Data Source Views
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stafford
- 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 ... Topics include- Overview of SSAS Tabular models
- See Training Course Details...
Bi-directional cross filters Calculations
Import Data
Process Tabular Model Partitions
Test a model in DirectQuery mode
DirectQuery Mode
Enable DirectQuery mode in SSDT
Import data by using a native query
Restore from Power Pivot
Create and Manage Tabular Model Partitions
Add columns to a table
Create and Manage Perspectives Translations Roles
Create a Calculated Column
Specify Mark as Date Table for use with Time Intelligence
Delete a Column
Data sources supported in SSAS tabular 2017
Data sources supported in tabular 1200 models
Database Process Partitions in the Workspace Database Perspectives
Connect to a tabular model database
Email us about this courses
Other Stafford Enable Technology Training Courses
Excel 365 Advanced - Stafford Excel Training Courses
JavaScript Stafford Training Courses
Excel Power Pivot Stafford Training Courses
Power BI - Stafford Microsoft Power BI Training Courses
JQuery Stafford Training Courses
Data Warehouse - Stafford SQL Training Courses