SQL SERVER ANALYSIS SERVICES TRAINING COURSES EXETER
About Enable Technology Exeter SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We are also more than happy to organise a local course at a training location in Exeter. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Barclays Bank PLC, Keele University, Birmingham City Council, Capita Group PLC, Nationwide Building Society Limited, Nuclear Engineering Services, Dollond & Aitchison Limited and Vodafone Group Services.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Exeter
- 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 ... Add sample data to DirectQuery models
- See Training Course Details...
Process Tabular Model Partitions
Create a New Tabular Model Project
Create and Manage Roles
Analyze a tabular model in Excel Deploy tabular model solutions
Set the Data Type of a Column
Delete a Column
Manage Roles by using SSMS
Create and Manage Partitions in the Workspace
Process Database, Table, or Partition
Version comparison
Database Process Partitions in the Workspace Database Perspectives
Import Data
Data sources supported in tabular 1400 models
Impersonation
Import from Power Pivot
Add a table Delete a Table
Create and Manage Tabular Model Partitions
Create and Manage Hierarchies Partitions
Filter Data in a Table Relationships
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Exeter
- 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 ... Use a Template to Create an Action Deployment
- See Training Course Details...
Add a Standard Action
Define Named Queries in a Data Source View
Create Local Partitions
Set Impersonation Options for a Data Source Connection
Create an Analysis Services Project
Supported Data Sources
Partition Writeback Calculations
Configure Measure Group Properties
Multidimensional models
Create User-Defined Hierarchies
Ragged Hierarchies
Data Source Views
Set Data Source Properties
Test an Action
Edit or Delete Partitions Merge Partitions
Create a Dimension Using the Dimension Wizard
Create a Dimension by Generating a Non-Time Table in the Data Source
Replace a Table or a Named Query in a Data Source View
Deployment Requirements and Considerations for Analysis Services Deployment
Define Assignments and Other Script Commands
Email us about this courses
Other Exeter Enable Technology Training Courses
PL/SQL - Exeter SQL Training Courses
SSIS Exeter Training Courses
Power Query Exeter Training Courses
SSRS Exeter Training Courses
Excel 365 Basic - Exeter Excel Training Courses
DAX - Exeter Excel Training Courses