SQL SERVER ANALYSIS SERVICES TRAINING COURSES BATLEY
About Enable Technology Batley SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued SQL Server Analysis Services training manuals they can refer to 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.
We provide instructor led training coupled with hands on training. 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. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Batley. 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 available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We have operated primarily in the West Midlands for twenty years. Our clients include: Nuclear Engineering Services, TalkTalk Direct Limited, EDF Energy PLC, Norwich Union PLC, Capita Group PLC, Barclays Bank PLC, Keele University and GKN PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Batley
- 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 ... Restore from Power Pivot
- See Training Course Details...
Create and Manage KPIs Hierarchies
Create and Manage Perspectives Translations Roles
Object-level security
Bi-directional cross filters Calculations
Define partitions in DirectQuery models
Connect to a tabular model database
Set the Data Type of a Column
Add a table Delete a Table
Filter Data in a Table Relationships
Import from Power Pivot
Specify Mark as Date Table for use with Time Intelligence
Create and Manage Tabular Model Partitions
Analyze in Excel
Data types supported
DirectQuery Mode
Manage Roles by using SSMS
Enable DirectQuery mode in SSMS
Import from Analysis Services
Add sample data to DirectQuery models
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Batley
- 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 ... Dimension permissions
- See Training Course Details...
Set Data Source Properties
Create User-Defined Hierarchies
Define Semiadditive Behavior
Add or Remove Tables or Views in a Data Source View
Database permissions
Create Named Sets
Backup Options Restore Options
Data Source object permissions
Defined Linked Measure Groups Partitions
KPIs Actions
Create Measures and Measure Groups
BI Wizard
Define Named Queries in a Data Source View
Designing Aggregations
Modify or Delete in Solution Explorer Database Dimensions
Supported Data Sources
Overview of SSAS Multidimensional Modelling
Delete a Data Source
Define Logical Primary Keys in a Data Source View
Replace a Table or a Named Query in a Data Source View
Email us about this courses
Other Batley Enable Technology Training Courses
Oracle SQL Batley Training Courses
PL/SQL - Batley SQL Training Courses
Power Query Batley Training Courses
DAX Batley Training Courses
Excel 365 Basic Batley Training Courses
TSQL - Batley SQL Training Courses