SQL SERVER ANALYSIS SERVICES TRAINING COURSES SOUTH WEST
About Enable Technology South West SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We can also deliver the SQL Server Analysis Services course at a local training venue in the South West. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Birmingham City Council, Royal Air Force, South Staffordshire Water PLC, Loughborough University, Unipart Group, Birmingham Heartlands Hospital, West Bromwich Building Society and DHL Express.
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...
Add a Standard Action
Create Local Partitions
Attach and Detach Analysis Services Databases
Set Data Source Properties
Dimension permissions
Backup Options Restore Options
Designing Aggregations
Move an Analysis Services Database
Defined Linked Measure Groups Partitions
Create Named Sets
Define Assignments and Other Script Commands
Deploy Model Solutions with the Deployment Utility
Use a Template to Create an Action Deployment
Multidimensional models
Create Measures and Measure Groups
Define Time Intelligence
Define a Fact Relationship and Fact Relationship Properties
BI Wizard
Create Remote Partitions
Define Logical Primary Keys in a Data Source View
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 ... Set the Data Type of a Column
- See Training Course Details...
Row filter mappings
Test a model in DirectQuery mode
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create a Calculated Table
Create a Relationship Between Two Tables
Specify Mark as Date Table for use with Time Intelligence
Create and Manage Measures KPIs
Manage Roles by using SSMS
Analyze a tabular model in Excel Deploy tabular model solutions
Sort Data in a Table
Create a New Tabular Model Project
Data types supported
Data sources supported in tabular 1200 models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Connect to a tabular model database
Hide or freeze columns
Create and Manage Partitions in the Workspace
Add a table Delete a Table
DAX formula compatibility in DirectQuery mode Tables and Columns
Email us about this courses
Other South West Enable Technology Training Courses
PL/SQL - South West SQL Training Courses
Access South West Training Courses
VBA South West Training Courses
Report Builder - South West SQL Server Reporting Services Training Courses
Oracle SQL South West Training Courses
Data Warehouse - South West SQL Training Courses