SQL SERVER ANALYSIS SERVICES TRAINING COURSES TONYPANDY
About Enable Technology Tonypandy SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain 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.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. We can also deliver the SQL Server Analysis Services course at a local training venue in Tonypandy. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Barclays Bank PLC, Capita Group PLC, Canadian High Commission, Nuclear Engineering Services, Countrywide Homes Limited, Cadbury PLC, TalkTalk Direct Limited and Birmingham Heartlands Hospital.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Tonypandy
- 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 ... Import from Power View
- See Training Course Details...
Topics include- Overview of SSAS Tabular models
Create and Manage Hierarchies Partitions
Data sources supported in tabular 1400 models
DirectQuery Mode
Data sources supported in tabular 1200 models
Rename a Table or Column
Create and Manage Tabular Model Partitions
DAX formula compatibility in DirectQuery mode Tables and Columns
Change table, column
Data sources supported in SSAS tabular 2016 Create Tabular Models
Add columns to a table
Restore from Power Pivot
Process Tabular Model Partitions
Hide or freeze columns
Tabular model designer
Specify Mark as Date Table for use with Time Intelligence
Add a table Delete a Table
Define partitions in DirectQuery models
Import from Analysis Services
Manage Roles by using SSMS
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Tonypandy
- 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 Logical Relationships in a Data Source View
- See Training Course Details...
Create a Dimension by Generating a Non-Time Table in the Data Source
Designing Aggregations
Document and Script an Analysis Services Database
Error Configuration Roles and Permissions
Ragged Hierarchies
Add or Remove Tables or Views in a Data Source View
Create a Dimension by Using an Existing Table
View the XML for an Analysis Services Project Data Sources
Define a Referenced Relationship and Referenced Relationship Properties
Data Source Views
Dimension permissions
Using SQL Server Data Tools (SSDT)
Set Partition Storage
Defined Linked Measure Groups Partitions
Use a Template to Create an Action Deployment
Edit or Delete Partitions Merge Partitions
Processing Options and Settings
Test an Action
Batch Processing Remote Processing
Deploy Model Solutions Using XMLA
Email us about this courses
Other Tonypandy Enable Technology Training Courses
JQuery Tonypandy Training Courses
Power BI - Tonypandy Microsoft Power BI Training Courses
Power Query Tonypandy Training Courses
Access VBA - Tonypandy Access Training Courses
DAX Tonypandy Training Courses
SSIS - Tonypandy SQL Server Integration Services Training Courses