SQL SERVER ANALYSIS SERVICES TRAINING COURSES LEAMINGTON SPA
About Enable Technology Leamington Spa SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Courses are instructor led and groups sizes small. 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 socially distanced local training venue in Leamington Spa. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are EDF Energy PLC, Fujistu PLC, Barclays Bank PLC, West Bromwich Building Society, Countrywide Homes Limited, Boots UK Limited, Cadbury PLC and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Leamington Spa
- 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 ... Processing Options and Settings
- See Training Course Details...
Document and Script an Analysis Services Database
Tools and Approaches for Processing
Add a Standard Action
Create a Dimension by Using an Existing Table
Attach and Detach Analysis Services Databases
Backup Options Restore Options
Batch Processing Remote Processing
Create Calculated Members
View the XML for an Analysis Services Project Data Sources
KPIs Actions
Test an Action
Add or Remove Tables or Views in a Data Source View
Dimension permissions
Configure Measure Group Properties
Configure Analysis Services Project Properties
Edit or Delete Partitions Merge Partitions
Delete a Data Source
Deploy Model Solutions with the Deployment Utility
BI Wizard
Define Logical Primary Keys in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Leamington Spa
- 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 ... Hide or freeze columns
- See Training Course Details...
Process Database, Table, or Partition
Delete a Column
Create a Calculated Table
Connect to a tabular model database
Delete Relationships
Data sources supported in SSAS tabular 2016 Create Tabular Models
Sort Data in a Table
Enable DirectQuery mode in SSDT
Impersonation
Create and Manage KPIs Hierarchies
Create and Manage Measures KPIs
Rename a Table or Column
Create a Relationship Between Two Tables
Create and Manage Partitions in the Workspace
Create a New Tabular Model Project
Row filter mappings
Import from Analysis Services
Process Tabular Model Partitions
Analyze in Excel
Create and Manage Roles
Email us about this courses
Other Leamington Spa Enable Technology Training Courses
Excel 365 Advanced - Leamington Spa Excel Training Courses
Access Leamington Spa Training Courses
TSQL Leamington Spa Training Courses
Excel 365 Intermediate Leamington Spa Training Courses
Excel Power Pivot - Leamington Spa Excel Training Courses
SSIS - Leamington Spa SQL Server Integration Services Training Courses