SQL SERVER ANALYSIS SERVICES TRAINING COURSES SOUTH WEST
About Enable Technology South West SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the SQL Server Analysis Services course is at a local training site. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Queen's Medical Centre Nottingham, Carillion PLC, Birmingham City University, Norwich Union PLC, EDF Energy PLC, Royal & Sun Alliance Group PLC, Keele University and Capita Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: South West
- 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 ... KPIs Actions
- See Training Course Details...
Read Definition permissions
Create Measures and Measure Groups
Replace a Table or a Named Query in a Data Source View
Deploy Model Solutions Using XMLA
Define Named Calculations in a Data Source View
Test an Action
Create User-Defined Hierarchies
Modify or Delete an Analysis Services Database
Defined Linked Measure Groups Partitions
Data Source Views
Define Assignments and Other Script Commands
Modify or Delete in Solution Explorer Database Dimensions
Edit or Delete Partitions Merge Partitions
Document and Script an Analysis Services Database
Designing Aggregations
Batch Processing Remote Processing
Set Impersonation Options for a Data Source Connection
Use Aggregate Functions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Calculated Members
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: South West
- 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 ... Topics include- Overview of SSAS Tabular models
- See Training Course Details...
Define partitions in DirectQuery models
Analyze in Excel
Create a Calculated Table
Import Data
Data types supported
Add columns to a table
Hide or freeze columns
Data sources supported in SSAS tabular 2017
Import from Power Pivot
Set the Data Type of a Column
Enable DirectQuery mode in SSMS
Filter Data in a Table Relationships
Create and Manage Measures KPIs
DAX formula compatibility in DirectQuery mode Tables and Columns
DirectQuery Mode
Create a Relationship Between Two Tables
Import data by using a native query
Create and Manage Hierarchies Partitions
Data sources supported in SSAS tabular 2016 Create Tabular Models
Email us about this courses
Other South West Enable Technology Training Courses
PL/SQL South West Training Courses
JavaScript - South West JavaScript Training Courses
SSRS - South West SQL Server Reporting Services Training Courses
Data Warehouse - South West SQL Training Courses
SSIS - South West SQL Server Integration Services Training Courses
TSQL South West Training Courses