SQL SERVER ANALYSIS SERVICES TRAINING COURSES CHESHIRE
About Enable Technology Cheshire SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. We guarantee the training will be delivered by a Microsoft certified expert. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Another option is we can organise a local training site in Cheshire. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham City University, Homeserve PLC, Vodafone Group Services, EDF Energy PLC, Canadian High Commission, DHL Express, West Bromwich Building Society and Carillion PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Cheshire
- 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 Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
- See Training Course Details...
Deploy Analysis Services Projects
Overview of SSAS Multidimensional Modelling
Backup Options Restore Options
Processing Databases, Dimensions and Partitions
Create Local Partitions
Batch Processing Remote Processing
Using SQL Server Data Tools (SSDT)
Define Time Intelligence
Define a Referenced Relationship and Referenced Relationship Properties
Designing Aggregations
Configure Measure Group Properties
Create a Data Source
Tools and Approaches for Processing
Multidimensional models
Deploy Model Solutions Using XMLA
Cube or model permissions Process permissions
Processing Options and Settings
Replace a Table or a Named Query in a Data Source View
Ragged Hierarchies
Change a Partition Source
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Cheshire
- 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...
Change table, column
Bi-directional cross filters Calculations
DAX formula compatibility in DirectQuery mode Tables and Columns
Tabular model designer
Hide or freeze columns
Create a Calculated Column
Create and Manage Roles
Object-level security
Impersonation
Import data by using a native query
Sort Data in a Table
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create a Relationship Between Two Tables
Add a table Delete a Table
Create and Manage Hierarchies Partitions
Connect to a tabular model database
Import Data
Email us about this courses
Other Cheshire Enable Technology Training Courses
VBA Cheshire Training Courses
SSIS - Cheshire SQL Server Integration Services Training Courses
JavaScript - Cheshire JavaScript Training Courses
Excel 365 Basic Cheshire Training Courses
Oracle SQL Cheshire Training Courses
Access - Cheshire Access Training Courses