SQL SERVER ANALYSIS SERVICES TRAINING COURSES ASHTON-UNDER-LYNE
About Enable Technology Ashton-under-lyne SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. 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 offers instructor led training taught by technology specialists. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local training site in Ashton-under-lyne. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have over twenty years continuous technical training experience. Our clients include: Boots UK Limited, Capita Group PLC, Lloyds TSB Bank PLC, Loughborough University, University of Birmingham, Unipart Group, Dollond & Aitchison Limited and Barclays Bank PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Ashton-under-lyne
- 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 ... Specify Mark as Date Table for use with Time Intelligence
- See Training Course Details...
Bi-directional cross filters Calculations
Define partitions in DirectQuery models
Add a table Delete a Table
Create and Manage Partitions in the Workspace
Add sample data to DirectQuery models
Process Tabular Model Partitions
Database Process Partitions in the Workspace Database Perspectives
Manage Roles by using SSMS
Create and Manage KPIs Hierarchies
Connect to a tabular model database
Enable DirectQuery mode in SSMS
Rename a Table or Column
Object-level security
Analyze in Excel
Create and Manage Roles
Row filter mappings
Import data by using a native query
Data types supported
Change table, column
Create a Calculated Table
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Ashton-under-lyne
- 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 a Referenced Relationship and Referenced Relationship Properties
- See Training Course Details...
Tools and Approaches for Processing
Set Impersonation Options for a Data Source Connection
Edit or Delete Partitions Merge Partitions
Move an Analysis Services Database
Defined Linked Measure Groups Partitions
Create a Dimension Using the Dimension Wizard
Delete a Data Source View Dimensions
Define Time Intelligence
Create a Dimension by Generating a Non-Time Table in the Data Source
Define Logical Relationships in a Data Source View
Read Definition permissions
Define a Regular Relationship and Regular Relationship Properties
Explore Data in a Data Source View
Configure Analysis Services Project Properties
Data Source Views
Define Attribute Relationships
Create a Dimension by Using an Existing Table
Multidimensional models
Backup Options Restore Options
Deploy Model Solutions Using the Deployment Wizard
Email us about this courses
Other Ashton-under-lyne Enable Technology Training Courses
JQuery - Ashton-under-lyne JavaScript Training Courses
JQuery Mobile Ashton-under-lyne Training Courses
Access VBA - Ashton-under-lyne Access Training Courses
Excel Power Pivot - Ashton-under-lyne Excel Training Courses
Power Query - Ashton-under-lyne Excel Training Courses
Excel 365 Basic Ashton-under-lyne Training Courses