SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACKWOOD
About Enable Technology Blackwood SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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.
We provide instructor led training coupled with hands on training. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local training site in Blackwood. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Fujistu PLC, Royal Air Force, Carillion PLC, Birmingham City University, Aston University, Unipart Group, GKN PLC and Norwich Union PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Blackwood
- 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 ... Test an Action
- See Training Course Details...
Deploy Analysis Services Projects
Modify or Delete an Analysis Services Database
Database permissions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Delete a Data Source
Tools and Approaches for Processing
Set Data Source Properties
Create Measures and Measure Groups
KPIs Actions
Change a Partition Source
Deploy Model Solutions Using XMLA
Use a Template to Create an Action Deployment
Defined Linked Measure Groups Partitions
BI Wizard
Define Logical Relationships in a Data Source View
Deploy Model Solutions with the Deployment Utility
Define Named Queries in a Data Source View
Create Calculated Members
Use Aggregate Functions
Document and Script an Analysis Services Database
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Blackwood
- 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 ... Restore from Power Pivot
- See Training Course Details...
Create and Manage Perspectives Translations Roles
Add sample data to DirectQuery models
Test a model in DirectQuery mode
Add columns to a table
Bi-directional cross filters Calculations
Version comparison
Create a New Tabular Model Project
Data types supported
Change table, column
Rename a Table or Column
Connect to a tabular model database
Data sources supported in SSAS tabular 2017
Impersonation
Object-level security
Create and Manage Tabular Model Partitions
Set the Data Type of a Column
Data sources supported in tabular 1400 models
Delete a Column
Import Data
Email us about this courses
Other Blackwood Enable Technology Training Courses
PL/SQL Blackwood Training Courses
DAX Blackwood Training Courses
Power Query Blackwood Training Courses
Report Builder Blackwood Training Courses
Data Warehouse Blackwood Training Courses
JQuery Blackwood Training Courses