SQL SERVER ANALYSIS SERVICES TRAINING COURSES YORK
About Enable Technology York SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
We provide instructor led training coupled with hands on training. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a socially distanced venue near you in York. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Vodafone Group Services, Total Telecommunications Limited, Birmingham Heartlands Hospital, Lloyds TSB Bank PLC, Canadian High Commission, Norwich Union PLC, University of Birmingham and Fujistu PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: York
- 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 ... Deploy Model Solutions Using the Deployment Wizard
- See Training Course Details...
Read Definition permissions
Deploy Model Solutions with the Deployment Utility
Use Aggregate Functions
Add a Standard Action
Define a Referenced Relationship and Referenced Relationship Properties
Test an Action
Work with Diagrams in Data Source View Designer
Use a Template to Create an Action Deployment
Define a Fact Relationship and Fact Relationship Properties
Set Partition Storage
Cube or model permissions Process permissions
Define Named Calculations in a Data Source View
View the XML for an Analysis Services Project Data Sources
Delete a Data Source
Modify or Delete in Solution Explorer Database Dimensions
Rename a Multidimensional Database Processing a multidimensional model
Set Impersonation Options for a Data Source Connection
Deploy Analysis Services Projects
Create Calculated Members
Configure Measure Group Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: York
- 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 ... Import from Power View
- See Training Course Details...
Database Process Partitions in the Workspace Database Perspectives
Import from Analysis Services
Delete Relationships
Test a model in DirectQuery mode
Create and Manage Measures KPIs
Create and Manage Hierarchies Partitions
Impersonation
Create a Relationship Between Two Tables
Add a table Delete a Table
Row filter mappings
Create and Manage KPIs Hierarchies
Process Database, Table, or Partition
Create a New Tabular Model Project
Manage Roles by using SSMS
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Filter Data in a Table Relationships
Data sources supported in tabular 1200 models
Import Data
Set the Data Type of a Column
Email us about this courses
Other York Enable Technology Training Courses
Power BI - York Microsoft Power BI Training Courses
JQuery Mobile York Training Courses
PL/SQL York Training Courses
TSQL York Training Courses
SSRS York Training Courses
DAX York Training Courses