SQL SERVER ANALYSIS SERVICES TRAINING COURSES ABERGAVENNY
About Enable Technology Abergavenny 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 is given SQL Server Analysis Services courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
We provide instructor led training coupled with hands on training. 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 are also more than happy to organise a local course at a socially distanced training location in Abergavenny. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
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. Our clients include: Capita Group PLC, Nationwide Building Society Limited, Shell UK Oil Products Ltd, Birmingham City Council, Yell Group PLC, Dollond & Aitchison Limited, Birmingham Heartlands Hospital and Total Telecommunications Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Abergavenny
- 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 ... Database Process Partitions in the Workspace Database Perspectives
- See Training Course Details...
Manage Roles by using SSMS
Row filter mappings
Create a Calculated Column
Process Database, Table, or Partition
DAX formula compatibility in DirectQuery mode Tables and Columns
Data sources supported in tabular 1400 models
Create and Manage Partitions in the Workspace
Add sample data to DirectQuery models
Connect to a tabular model database
Add a table Delete a Table
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create and Manage Hierarchies Partitions
Process Tabular Model Partitions
Create a Relationship Between Two Tables
Analyze in Excel
Import from Power View
Tabular model designer
Import Data
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Abergavenny
- 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 Attribute Relationships
- See Training Course Details...
Change a Partition Source
Define a Referenced Relationship and Referenced Relationship Properties
Create Named Sets
Define Logical Primary Keys in a Data Source View
Create Calculated Members
Backup and Restore of Analysis Services Databases
Create a Data Source
Use a Template to Create an Action Deployment
KPIs Actions
BI Wizard
Set Impersonation Options for a Data Source Connection
Define Named Calculations in a Data Source View
Designing Aggregations
Test an Action
Read Definition permissions
Create Local Partitions
Overview of SSAS Multidimensional Modelling
Explore Data in a Data Source View
Add a Standard Action
Deployment Requirements and Considerations for Analysis Services Deployment
Email us about this courses
Other Abergavenny Enable Technology Training Courses
Excel 365 Basic Abergavenny Training Courses
SSIS Abergavenny Training Courses
SSRS - Abergavenny SQL Server Reporting Services Training Courses
SQL Abergavenny Training Courses
Power Query Abergavenny Training Courses
Excel 365 Intermediate Abergavenny Training Courses