SQL SERVER ANALYSIS SERVICES TRAINING COURSES SWINDON
About Enable Technology Swindon SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. We can also deliver the SQL Server Analysis Services course at a local training venue in Swindon. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Vodafone Group Services, Canadian High Commission, Boots UK Limited, Carillion PLC, Norfolk Police Constabulary, TalkTalk Direct Limited, Birmingham City University and Countrywide Homes Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Swindon
- 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 ... Attach and Detach Analysis Services Databases
- See Training Course Details...
Define Time Intelligence
View the XML for an Analysis Services Project Data Sources
Tools and Approaches for Processing
Modify or Delete in Solution Explorer Database Dimensions
Deploy Model Solutions Using XMLA
Supported Data Sources
Error Configuration Roles and Permissions
Replace a Table or a Named Query in a Data Source View
Create Measures and Measure Groups
Processing Databases, Dimensions and Partitions
Deploy Analysis Services Projects
Cube or model permissions Process permissions
Create a Dimension by Using an Existing Table
Deployment Requirements and Considerations for Analysis Services Deployment
Configure Analysis Services Project Properties
Define Named Queries in a Data Source View
Create User-Defined Hierarchies
Using SQL Server Data Tools (SSDT)
Configure Measure Group Properties
Create an Analysis Services Project
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Swindon
- 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 ... Analyze in Excel
- See Training Course Details...
Data sources supported in SSAS tabular 2016 Create Tabular Models
Object-level security
Process Tabular Model Partitions
Import data by using a native query
DirectQuery Mode
Sort Data in a Table
Understanding DAX in Tabular Models Measures
Enable DirectQuery mode in SSDT
Row filter mappings
Create and Manage KPIs Hierarchies
Create and Manage Perspectives Translations Roles
Version comparison
Delete Relationships
Delete a Column
Process Database, Table, or Partition
Manage Roles by using SSMS
Create and Manage Measures KPIs
Add sample data to DirectQuery models
Email us about this courses
Other Swindon Enable Technology Training Courses
SSIS - Swindon SQL Server Integration Services Training Courses
JQuery - Swindon JavaScript Training Courses
Report Builder Swindon Training Courses
TSQL - Swindon SQL Training Courses
Excel 365 Advanced Swindon Training Courses
VBA Swindon Training Courses