SQL SERVER ANALYSIS SERVICES TRAINING COURSES HUDDERSFIELD
About Enable Technology Huddersfield SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Huddersfield. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Carillion PLC, TalkTalk Direct Limited, Norfolk Police Constabulary, Birmingham Heartlands Hospital, Boots UK Limited, West Bromwich Building Society, Aston University and Cadbury PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Huddersfield
- 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 Named Sets
- See Training Course Details...
Deployment Requirements and Considerations for Analysis Services Deployment
Overview of SSAS Multidimensional Modelling
Read Definition permissions
Create a Time Dimension by Generating a Time Table
Edit or Delete Partitions Merge Partitions
Partition Writeback Calculations
Cube or model permissions Process permissions
Document and Script an Analysis Services Database
Test an Action
Define Named Queries in a Data Source View
Deploy Analysis Services Projects
Change a Partition Source
Modify or Delete an Analysis Services Database
View the XML for an Analysis Services Project Data Sources
Create Local Partitions
Create a Dimension Using the Dimension Wizard
Deploy Model Solutions Using XMLA
Define Logical Primary Keys in a Data Source View
Move an Analysis Services Database
Data Source Views
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Huddersfield
- 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...
Filter Data in a Table Relationships
Import Data
Create a Calculated Column
Create a New Tabular Model Project
Restore from Power Pivot
Import from Power View
Process Database, Table, or Partition
Enable DirectQuery mode in SSDT
Import from Power Pivot
Delete a Column
Data sources supported in SSAS tabular 2017
Create and Manage Perspectives Translations Roles
Enable DirectQuery mode in SSMS
Test a model in DirectQuery mode
Add sample data to DirectQuery models
Bi-directional cross filters Calculations
Import from Analysis Services
Database Process Partitions in the Workspace Database Perspectives
Delete Relationships
DirectQuery Mode
Email us about this courses
Other Huddersfield Enable Technology Training Courses
Power Query - Huddersfield Excel Training Courses
Excel 365 Basic Huddersfield Training Courses
SSRS - Huddersfield SQL Server Reporting Services Training Courses
Excel Power Pivot - Huddersfield Excel Training Courses
VBA Huddersfield Training Courses
Excel 365 Advanced - Huddersfield Excel Training Courses