SQL SERVER ANALYSIS SERVICES TRAINING COURSES SPLOTT
About Enable Technology Splott SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with SQL Server Analysis Services training materials which they keep 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 specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another way we could deliver the SQL Server Analysis Services course is at a local training site. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services 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
We have operated primarily in the West Midlands for twenty years. Our clients include: Birmingham City University, Shell UK Oil Products Ltd, University of Birmingham, Keele University, Birmingham City Council, Canadian High Commission, Lloyds TSB Bank PLC and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Splott
- 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 ... Enable DirectQuery mode in SSDT
- See Training Course Details...
Import data by using a native query
Process Database, Table, or Partition
Topics include- Overview of SSAS Tabular models
Create and Manage Perspectives Translations Roles
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Enable DirectQuery mode in SSMS
Bi-directional cross filters Calculations
Hide or freeze columns
Import from Power View
Data types supported
Create and Manage KPIs Hierarchies
Connect to a tabular model database
Manage Roles by using SSMS
Import from Analysis Services
Impersonation
Create and Manage Hierarchies Partitions
Data sources supported in tabular 1400 models
Change table, column
Delete Relationships
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Splott
- 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 ... Partition Writeback Calculations
- See Training Course Details...
Define Logical Relationships in a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
Create a Data Source
Dimension permissions
Replace a Table or a Named Query in a Data Source View
Backup and Restore of Analysis Services Databases
Multidimensional models
Set Data Source Properties
Tools and Approaches for Processing
Create a Dimension by Using an Existing Table
Modify or Delete an Analysis Services Database
Define Logical Primary Keys in a Data Source View
Using SQL Server Data Tools (SSDT)
Modify or Delete in Solution Explorer Database Dimensions
Create Local Partitions
Read Definition permissions
Error Configuration Roles and Permissions
KPIs Actions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Data Source Views
Email us about this courses
Other Splott Enable Technology Training Courses
Excel 365 Intermediate - Splott Excel Training Courses
DAX - Splott Excel Training Courses
TSQL - Splott SQL Training Courses
SSIS - Splott SQL Server Integration Services Training Courses
Excel Power Pivot Splott Training Courses
Data Warehouse Splott Training Courses