SQL SERVER ANALYSIS SERVICES TRAINING COURSES MERSEYSIDE
About Enable Technology Merseyside 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 Professionals. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite training location in Merseyside. All SQL Server Analysis Services courses can be customised to meet your particular 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
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Royal & Sun Alliance Group PLC, Unipart Group, Countrywide Homes Limited, Nationwide Building Society Limited, Halfords Group PLC, EDF Energy PLC, Birmingham Heartlands Hospital and West Bromwich Building Society.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Merseyside
- 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 ... Multidimensional models
- See Training Course Details...
Explore Data in a Data Source View
Create User-Defined Hierarchies
Data Source object permissions
Set Partition Storage
Create a Dimension by Using an Existing Table
Processing Databases, Dimensions and Partitions
Configure Analysis Services Project Properties
Designing Aggregations
Modify or Delete an Analysis Services Database
Create Measures and Measure Groups
Ragged Hierarchies
Replace a Table or a Named Query in a Data Source View
Create Named Sets
Overview of SSAS Multidimensional Modelling
Configure Measure Group Properties
BI Wizard
Tools and Approaches for Processing
Define Assignments and Other Script Commands
Use a Template to Create an Action Deployment
Database permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Merseyside
- 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 ... Bi-directional cross filters Calculations
- See Training Course Details...
Create and Manage Roles
Specify Mark as Date Table for use with Time Intelligence
Object-level security
Process Database, Table, or Partition
Topics include- Overview of SSAS Tabular models
Data types supported
Create and Manage Measures KPIs
DirectQuery Mode
Create a Relationship Between Two Tables
Create a Calculated Column
Test a model in DirectQuery mode
Create and Manage KPIs Hierarchies
Manage Roles by using SSMS
Hide or freeze columns
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create and Manage Hierarchies Partitions
Import from Power View
Add columns to a table
Delete Relationships
Email us about this courses
Other Merseyside Enable Technology Training Courses
Access - Merseyside Access Training Courses
JavaScript Merseyside Training Courses
Report Builder Merseyside Training Courses
DAX - Merseyside Excel Training Courses
JQuery Mobile - Merseyside JavaScript Training Courses
SSRS Merseyside Training Courses