SQL SERVER ANALYSIS SERVICES TRAINING COURSES STAFFORD
About Enable Technology Stafford SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
Courses are instructor led and groups sizes small. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Stafford. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your 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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Aston University, Halfords Group PLC, University of Birmingham, Royal Air Force, Loughborough University, Wolverhampton City Council, Birmingham City University and Yell Group PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stafford
- 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 ... Data sources supported in SSAS tabular 2017
- See Training Course Details...
Define partitions in DirectQuery models
Manage Roles by using SSMS
Add sample data to DirectQuery models
Filter Data in a Table Relationships
Object-level security
Connect to a tabular model database
Create and Manage Partitions in the Workspace
Process Tabular Model Partitions
Topics include- Overview of SSAS Tabular models
Tabular model designer
Enable DirectQuery mode in SSMS
Set the Data Type of a Column
Create and Manage Measures KPIs
Database Process Partitions in the Workspace Database Perspectives
Import Data
Understanding DAX in Tabular Models Measures
Data sources supported in tabular 1400 models
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stafford
- 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 ... Configure Measure Group Properties
- See Training Course Details...
Error Configuration Roles and Permissions
Delete a Data Source
Dimension permissions
Add a Standard Action
Deploy Model Solutions Using the Deployment Wizard
Deployment Requirements and Considerations for Analysis Services Deployment
Create Local Partitions
Supported Data Sources
Create Remote Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Deploy Model Solutions Using XMLA
Move an Analysis Services Database
Using SQL Server Data Tools (SSDT)
Define Attribute Relationships
Authorizing access to objects and operations
KPIs Actions
Define a Regular Relationship and Regular Relationship Properties
Rename a Multidimensional Database Processing a multidimensional model
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create a Dimension by Using an Existing Table
Email us about this courses
Other Stafford Enable Technology Training Courses
Data Warehouse Stafford Training Courses
JQuery Mobile Stafford Training Courses
SQL Stafford Training Courses
Report Builder - Stafford SQL Server Reporting Services Training Courses
Oracle SQL - Stafford SQL Training Courses
Excel Power Pivot Stafford Training Courses