SQL SERVER ANALYSIS SERVICES TRAINING COURSES PONTYPRIDD
About Enable Technology Pontypridd SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. 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.
We provide instructor led training coupled with hands on training. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Pontypridd. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Cadbury PLC, Unipart Group, Carillion PLC, Aston University, Birmingham City University, Lloyds TSB Bank PLC, Nationwide Building Society Limited and University of Birmingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Pontypridd
- 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 ... Deploy Model Solutions Using XMLA
- See Training Course Details...
Use Aggregate Functions
Create a Dimension by Generating a Non-Time Table in the Data Source
Supported Data Sources
Work with Diagrams in Data Source View Designer
Define Time Intelligence
Overview of SSAS Multidimensional Modelling
Deploy Model Solutions Using the Deployment Wizard
Set Impersonation Options for a Data Source Connection
Use a Template to Create an Action Deployment
BI Wizard
Test an Action
Cube or model permissions Process permissions
Move an Analysis Services Database
Define a Data Source View
Batch Processing Remote Processing
Configure Analysis Services Project Properties
KPIs Actions
Database permissions
Create an Analysis Services Project
Define a Regular Relationship and Regular Relationship Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Pontypridd
- 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 Hierarchies Partitions
- See Training Course Details...
Enable DirectQuery mode in SSMS
Delete Relationships
Create a Relationship Between Two Tables
Import Data
Database Process Partitions in the Workspace Database Perspectives
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Connect to a tabular model database
Import from Power Pivot
DirectQuery Mode
Filter Data in a Table Relationships
Process Tabular Model Partitions
Specify Mark as Date Table for use with Time Intelligence
Object-level security
Topics include- Overview of SSAS Tabular models
Create a Calculated Table
Test a model in DirectQuery mode
Create and Manage Partitions in the Workspace
Process Database, Table, or Partition
Import data by using a native query
Tabular model designer
Email us about this courses
Other Pontypridd Enable Technology Training Courses
Excel Power Pivot - Pontypridd Excel Training Courses
SSIS Pontypridd Training Courses
TSQL Pontypridd Training Courses
DAX Pontypridd Training Courses
Power Query - Pontypridd Excel Training Courses
Data Warehouse - Pontypridd SQL Training Courses