SQL SERVER ANALYSIS SERVICES TRAINING COURSES TORQUAY
About Enable Technology Torquay SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The tutor delivering the course will be a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. If you prefer we can offer an offsite training location in Torquay. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Capita Group PLC, EDF Energy PLC, Norwich Union PLC, Halfords Group PLC, Royal Air Force, West Bromwich Building Society, Yell Group PLC and Shell UK Oil Products Ltd.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Torquay
- 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 ... Filter Data in a Table Relationships
- See Training Course Details...
Enable DirectQuery mode in SSDT
Hide or freeze columns
Data sources supported in tabular 1200 models
Create and Manage Partitions in the Workspace
Delete Relationships
Change table, column
Create and Manage Perspectives Translations Roles
Import from Power Pivot
Version comparison
Add sample data to DirectQuery models
Set the Data Type of a Column
Database Process Partitions in the Workspace Database Perspectives
Add a table Delete a Table
Data types supported
Create a Relationship Between Two Tables
Rename a Table or Column
Create a Calculated Column
Analyze a tabular model in Excel Deploy tabular model solutions
Define partitions in DirectQuery models
DirectQuery Mode
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Torquay
- 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 ... Partition Writeback Calculations
- See Training Course Details...
Define a Data Source View
Using SQL Server Data Tools (SSDT)
Define a Fact Relationship and Fact Relationship Properties
Backup and Restore of Analysis Services Databases
Define a Referenced Relationship and Referenced Relationship Properties
Create a Dimension by Generating a Non-Time Table in the Data Source
Backup Options Restore Options
Defined Linked Measure Groups Partitions
Create a Dimension Using the Dimension Wizard
Set Partition Storage
Configure Measure Group Properties
BI Wizard
Authorizing access to objects and operations
Define Logical Relationships in a Data Source View
Create an Analysis Services Project
Set Impersonation Options for a Data Source Connection
Edit or Delete Partitions Merge Partitions
Create a Data Source
Ragged Hierarchies
Rename a Multidimensional Database Processing a multidimensional model
Email us about this courses
Other Torquay Enable Technology Training Courses
VBA - Torquay Excel Training Courses
DAX Torquay Training Courses
Excel 365 Basic Torquay Training Courses
Oracle SQL Torquay Training Courses
Excel 365 Intermediate - Torquay Excel Training Courses
SSIS Torquay Training Courses