SQL SERVER ANALYSIS SERVICES TRAINING COURSES HEXHAM
About Enable Technology Hexham SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. 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. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Hexham. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training 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
Our teaching team have over twenty years continuous technical training experience. Our clients include: Vodafone Group Services, Keele University, South Staffordshire Water PLC, University of Birmingham, Capita Group PLC, Halfords Group PLC, Homeserve PLC and Total Telecommunications Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Hexham
- 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 ... Processing Databases, Dimensions and Partitions
- See Training Course Details...
Move an Analysis Services Database
Data Source Views
Set Impersonation Options for a Data Source Connection
Explore Data in a Data Source View
Deploy Analysis Services Projects
Work with Diagrams in Data Source View Designer
Create a Dimension by Using an Existing Table
Database permissions
Define Semiadditive Behavior
Supported Data Sources
Define Named Calculations in a Data Source View
Ragged Hierarchies
Deploy Model Solutions Using XMLA
Create Remote Partitions
Defined Linked Measure Groups Partitions
Create a Time Dimension by Generating a Time Table
KPIs Actions
Cube or model permissions Process permissions
Create Named Sets
Add a Standard Action
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Hexham
- 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...
Enable DirectQuery mode in SSDT
Create and Manage Tabular Model Partitions
Topics include- Overview of SSAS Tabular models
Create a New Tabular Model Project
Create a Relationship Between Two Tables
Create and Manage Roles
Data sources supported in SSAS tabular 2017
Delete Relationships
Test a model in DirectQuery mode
Add sample data to DirectQuery models
Create a Calculated Table
Object-level security
Filter Data in a Table Relationships
Impersonation
Manage Roles by using SSMS
Set the Data Type of a Column
Import from Power Pivot
Data sources supported in tabular 1200 models
Create a Calculated Column
Email us about this courses
Other Hexham Enable Technology Training Courses
Excel 365 Intermediate Hexham Training Courses
SSIS Hexham Training Courses
Data Warehouse Hexham Training Courses
VBA Hexham Training Courses
TSQL Hexham Training Courses
Power BI Hexham Training Courses