SQL SERVER ANALYSIS SERVICES TRAINING COURSES BRIDGEND
About Enable Technology Bridgend SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology training courses are delivered as instructor led courses. 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. Another option is we can organise a local training site in Bridgend. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Birmingham Heartlands Hospital, TalkTalk Direct Limited, Carillion PLC, Vodafone Group Services, Homeserve PLC, Cadbury PLC, Birmingham City Council and Norwich Union PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bridgend
- 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 Named Calculations in a Data Source View
- See Training Course Details...
Work with Diagrams in Data Source View Designer
Authorizing access to objects and operations
Tools and Approaches for Processing
Configure Analysis Services Project Properties
Define Assignments and Other Script Commands
Data Source object permissions
Edit or Delete Partitions Merge Partitions
Define a Data Source View
Define Time Intelligence
Database permissions
Create User-Defined Hierarchies
Defined Linked Measure Groups Partitions
Deploy Model Solutions Using the Deployment Wizard
Create Named Sets
Calculations using the Business Intelligence Wizard
KPIs Actions
Multidimensional models
Batch Processing Remote Processing
Cube or model permissions Process permissions
Use Aggregate Functions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bridgend
- 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 ... Change table, column
- See Training Course Details...
Bi-directional cross filters Calculations
Create and Manage Tabular Model Partitions
Create and Manage Perspectives Translations Roles
Import from Power Pivot
Process Database, Table, or Partition
Delete a Column
DirectQuery Mode
Analyze a tabular model in Excel Deploy tabular model solutions
Add columns to a table
Tabular model designer
Create and Manage Partitions in the Workspace
Data sources supported in tabular 1200 models
Process Tabular Model Partitions
Import Data
Manage Roles by using SSMS
Create a Calculated Column
Create a Relationship Between Two Tables
Import from Power View
Email us about this courses
Other Bridgend Enable Technology Training Courses
Power Query - Bridgend Excel Training Courses
Excel 365 Intermediate - Bridgend Excel Training Courses
SSIS - Bridgend SQL Server Integration Services Training Courses
JQuery Mobile Bridgend Training Courses
Excel 365 Advanced Bridgend Training Courses
DAX Bridgend Training Courses