SQL SERVER ANALYSIS SERVICES TRAINING COURSES GORSEINON
About Enable Technology Gorseinon SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Gorseinon. 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.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are EDF Energy PLC, Queen's Medical Centre Nottingham, Yell Group PLC, Lloyds TSB Bank PLC, Countrywide Homes Limited, Cadbury PLC, GKN PLC and Total Telecommunications Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Gorseinon
- 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 ... Data types supported
- See Training Course Details...
Analyze in Excel
Bi-directional cross filters Calculations
Create a Relationship Between Two Tables
Add sample data to DirectQuery models
Connect to a tabular model database
Test a model in DirectQuery mode
Create and Manage Roles
Add columns to a table
Create a New Tabular Model Project
Process Tabular Model Partitions
Manage Roles by using SSMS
Enable DirectQuery mode in SSDT
Define partitions in DirectQuery models
Specify Mark as Date Table for use with Time Intelligence
Set the Data Type of a Column
Create a Calculated Column
Hide or freeze columns
DirectQuery Mode
Data sources supported in tabular 1200 models
Restore from Power Pivot
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Gorseinon
- 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 ... Document and Script an Analysis Services Database
- See Training Course Details...
Read Definition permissions
Cube or model permissions Process permissions
Define a Fact Relationship and Fact Relationship Properties
Define Semiadditive Behavior
Create Named Sets
Configure Measure Group Properties
Database permissions
Tools and Approaches for Processing
Create an Analysis Services Project
Use Aggregate Functions
Backup Options Restore Options
Change a Partition Source
Defined Linked Measure Groups Partitions
Attach and Detach Analysis Services Databases
Modify or Delete an Analysis Services Database
Deploy Analysis Services Projects
Rename a Multidimensional Database Processing a multidimensional model
Use a Template to Create an Action Deployment
Error Configuration Roles and Permissions
Deploy Model Solutions Using XMLA
Email us about this courses
Other Gorseinon Enable Technology Training Courses
DAX Gorseinon Training Courses
SSIS Gorseinon Training Courses
Excel Power Pivot - Gorseinon Excel Training Courses
SQL - Gorseinon SQL Training Courses
SSRS - Gorseinon SQL Server Reporting Services Training Courses
VBA - Gorseinon Excel Training Courses