SQL SERVER ANALYSIS SERVICES TRAINING COURSES CARLISLE
About Enable Technology Carlisle SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The tutor delivering the course will be a Microsoft certified expert. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We provide instructor led training coupled with hands on training. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. Another way we could deliver the SQL Server Analysis Services course is at a local socially distanced training site. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Loughborough University, Nuclear Engineering Services, Dollond & Aitchison Limited, Fujistu PLC, Boots UK Limited, National Power PLC, University of Birmingham and Norwich Union PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Carlisle
- 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 ... Deploy from SQL Server Data Tools Manage Tabular Model Databases
- See Training Course Details...
Analyze in Excel
Create and Manage Perspectives Translations Roles
Row filter mappings
Impersonation
Hide or freeze columns
Import data by using a native query
Create and Manage Tabular Model Partitions
Data sources supported in tabular 1200 models
Delete Relationships
Delete a Column
Create and Manage Partitions in the Workspace
Create and Manage Roles
Create a Calculated Table
Data sources supported in tabular 1400 models
Import from Power Pivot
Tabular model designer
Version comparison
Bi-directional cross filters Calculations
Filter Data in a Table Relationships
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Carlisle
- 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 an Analysis Services Project
- See Training Course Details...
Add or Remove Tables or Views in a Data Source View
Use Aggregate Functions
Test an Action
Create a Dimension by Using an Existing Table
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
KPIs Actions
Deploy Analysis Services Projects
Define Attribute Relationships
Tools and Approaches for Processing
Delete a Data Source View Dimensions
Define Named Queries in a Data Source View
Multidimensional models
Partition Writeback Calculations
Overview of SSAS Multidimensional Modelling
Modify or Delete an Analysis Services Database
Rename a Multidimensional Database Processing a multidimensional model
Processing Options and Settings
Ragged Hierarchies
Define Logical Relationships in a Data Source View
Data Source Views
Email us about this courses
Other Carlisle Enable Technology Training Courses
SQL - Carlisle SQL Training Courses
Excel Power Pivot - Carlisle Excel Training Courses
PL/SQL Carlisle Training Courses
SSIS Carlisle Training Courses
JQuery Mobile - Carlisle JavaScript Training Courses
Excel 365 Advanced - Carlisle Excel Training Courses