SQL SERVER ANALYSIS SERVICES TRAINING COURSES MORECAMBE
About Enable Technology Morecambe SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The training will be delivered by a Microsoft professional with development experience. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local socially distanced venue in Morecambe. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Nuclear Engineering Services, Royal & Sun Alliance Group PLC, Vodafone Group Services, West Bromwich Building Society, Birmingham City University, Shell UK Oil Products Ltd, South Staffordshire Water PLC and Total Telecommunications Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Morecambe
- 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 ... Define Logical Relationships in a Data Source View
- See Training Course Details...
Create Measures and Measure Groups
Batch Processing Remote Processing
Ragged Hierarchies
Cube or model permissions Process permissions
BI Wizard
Delete a Data Source View Dimensions
Create a Dimension Using the Dimension Wizard
Deploy Analysis Services Projects
Create an Analysis Services Project
Set Partition Storage
Edit or Delete Partitions Merge Partitions
Attach and Detach Analysis Services Databases
Test an Action
Error Configuration Roles and Permissions
Document and Script an Analysis Services Database
Defined Linked Measure Groups Partitions
Overview of SSAS Multidimensional Modelling
Processing Options and Settings
Create a Data Source
Configure Analysis Services Project Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Morecambe
- 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 ... Create a Relationship Between Two Tables
- See Training Course Details...
Add sample data to DirectQuery models
Change table, column
Hide or freeze columns
Analyze a tabular model in Excel Deploy tabular model solutions
Import from Power View
Manage Roles by using SSMS
Create a New Tabular Model Project
Import from Analysis Services
Define partitions in DirectQuery models
Enable DirectQuery mode in SSDT
Understanding DAX in Tabular Models Measures
Object-level security
Data sources supported in tabular 1400 models
Create and Manage Hierarchies Partitions
Create a Calculated Column
DirectQuery Mode
Data sources supported in SSAS tabular 2017
Database Process Partitions in the Workspace Database Perspectives
Add a table Delete a Table
Sort Data in a Table
Email us about this courses
Other Morecambe Enable Technology Training Courses
Access VBA Morecambe Training Courses
Power Query Morecambe Training Courses
SQL - Morecambe SQL Training Courses
JavaScript Morecambe Training Courses
Access - Morecambe Access Training Courses
Excel Power Pivot Morecambe Training Courses