SQL SERVER ANALYSIS SERVICES TRAINING COURSES STRETFORD
About Enable Technology Stretford SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Stretford. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Royal Air Force, Wolverhampton City Council, University of Birmingham, GKN PLC, Capita Group PLC, Shell UK Oil Products Ltd, Cadbury PLC and Norfolk Police Constabulary.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stretford
- 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 ... Set the Data Type of a Column
- See Training Course Details...
Topics include- Overview of SSAS Tabular models
Create a Relationship Between Two Tables
Version comparison
Enable DirectQuery mode in SSMS
Add columns to a table
Analyze a tabular model in Excel Deploy tabular model solutions
Test a model in DirectQuery mode
Tabular model designer
Import from Analysis Services
Data sources supported in tabular 1200 models
Import data by using a native query
Define partitions in DirectQuery models
Analyze in Excel
Object-level security
Add sample data to DirectQuery models
DAX formula compatibility in DirectQuery mode Tables and Columns
Create and Manage Measures KPIs
Sort Data in a Table
Filter Data in a Table Relationships
Rename a Table or Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stretford
- 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 ... Create Local Partitions
- See Training Course Details...
Rename a Multidimensional Database Processing a multidimensional model
Deploy Model Solutions with the Deployment Utility
Deployment Requirements and Considerations for Analysis Services Deployment
Modify or Delete in Solution Explorer Database Dimensions
Create a Data Source
Add or Remove Tables or Views in a Data Source View
Set Data Source Properties
Create a Dimension Using the Dimension Wizard
Create Measures and Measure Groups
Create a Time Dimension by Generating a Time Table
Set Partition Storage
Tools and Approaches for Processing
Define a Data Source View
Designing Aggregations
Test an Action
Dimension permissions
Create Remote Partitions
Data Source object permissions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Cube or model permissions Process permissions
Email us about this courses
Other Stretford Enable Technology Training Courses
Oracle SQL Stretford Training Courses
Power Query - Stretford Excel Training Courses
SSIS Stretford Training Courses
JQuery Mobile Stretford Training Courses
Access Stretford Training Courses
SQL - Stretford SQL Training Courses