SQL SERVER ANALYSIS SERVICES TRAINING COURSES MERSEYSIDE
About Enable Technology Merseyside SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. 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. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If delivery onsite is an issue we will organise a socially distanced venue near you in Merseyside. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Yell Group PLC, Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, Halfords Group PLC, Norwich Union PLC, Aston University, EDF Energy PLC and Fujistu PLC.
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 ... Hide or freeze columns
- See Training Course Details...
Import from Analysis Services
Create and Manage Roles
Topics include- Overview of SSAS Tabular models
Add a table Delete a Table
Create and Manage Partitions in the Workspace
Bi-directional cross filters Calculations
Create and Manage Tabular Model Partitions
Manage Roles by using SSMS
Define partitions in DirectQuery models
Import Data
Database Process Partitions in the Workspace Database Perspectives
Add sample data to DirectQuery models
Process Database, Table, or Partition
Version comparison
Import data by using a native query
Create and Manage Hierarchies Partitions
Delete a Column
DAX formula compatibility in DirectQuery mode Tables and Columns
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 ... Create a Dimension Using the Dimension Wizard
- See Training Course Details...
Backup Options Restore Options
Delete a Data Source
Create a Time Dimension by Generating a Time Table
Configure Analysis Services Project Properties
Data Source Views
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define Logical Relationships in a Data Source View
Defined Linked Measure Groups Partitions
Create Calculated Members
Error Configuration Roles and Permissions
Create a Data Source
Define a Referenced Relationship and Referenced Relationship Properties
Authorizing access to objects and operations
Define a Data Source View
Processing Options and Settings
Partition Writeback Calculations
Define a Fact Relationship and Fact Relationship Properties
Delete a Data Source View Dimensions
Define Named Calculations in a Data Source View
Overview of SSAS Multidimensional Modelling
Email us about this courses
Other Merseyside Enable Technology Training Courses
JQuery Mobile - Merseyside JavaScript Training Courses
Excel Power Pivot Merseyside Training Courses
TSQL Merseyside Training Courses
Power BI Merseyside Training Courses
Excel 365 Basic Merseyside Training Courses
Access VBA Merseyside Training Courses