SQL SERVER ANALYSIS SERVICES TRAINING COURSES SHEFFIELD
About Enable Technology Sheffield SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The course will always be taught by a Microsoft Certified Professional (MCP). We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Sheffield. Every SQL Server Analysis Services course can be modified to meet your bespoke 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Yell Group PLC, Lloyds TSB Bank PLC, Birmingham City Council, Birmingham City University, DHL Express, Canadian High Commission, Royal Air Force and Vodafone Group Services.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Sheffield
- 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 ... Topics include- Overview of SSAS Tabular models
- See Training Course Details...
Create a New Tabular Model Project
Add a table Delete a Table
Change table, column
Define partitions in DirectQuery models
Create and Manage Tabular Model Partitions
Data sources supported in SSAS tabular 2016 Create Tabular Models
Object-level security
Rename a Table or Column
Import from Power View
Data types supported
Enable DirectQuery mode in SSMS
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Filter Data in a Table Relationships
Manage Roles by using SSMS
Create a Calculated Column
Understanding DAX in Tabular Models Measures
Test a model in DirectQuery mode
Delete a Column
Tabular model designer
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Sheffield
- 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 ... Edit or Delete Partitions Merge Partitions
- See Training Course Details...
Multidimensional models
Define Assignments and Other Script Commands
Create an Analysis Services Project
Work with Diagrams in Data Source View Designer
Data Source object permissions
Create a Dimension by Using an Existing Table
Explore Data in a Data Source View
Error Configuration Roles and Permissions
Using SQL Server Data Tools (SSDT)
Cube or model permissions Process permissions
Define a Data Source View
Batch Processing Remote Processing
Modify or Delete in Solution Explorer Database Dimensions
Test an Action
Document and Script an Analysis Services Database
Create a Data Source
Ragged Hierarchies
Create Remote Partitions
Backup Options Restore Options
Define Named Calculations in a Data Source View
Email us about this courses
Other Sheffield Enable Technology Training Courses
JQuery Mobile - Sheffield JavaScript Training Courses
Power BI - Sheffield Microsoft Power BI Training Courses
Report Builder Sheffield Training Courses
DAX - Sheffield Excel Training Courses
Excel 365 Basic Sheffield Training Courses
TSQL - Sheffield SQL Training Courses