SQL SERVER ANALYSIS SERVICES TRAINING COURSES HAVERFORDWEST
About Enable Technology Haverfordwest SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Another option is we can organise a local socially distanced training site in Haverfordwest. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have operated primarily in the West Midlands for twenty years. Our clients include: Carillion PLC, Boots UK Limited, TalkTalk Direct Limited, Norfolk Police Constabulary, Birmingham City Council, Loughborough University, West Bromwich Building Society and Norwich Union PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Haverfordwest
- 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 ... Deploy Analysis Services Projects
- See Training Course Details...
Define Named Calculations in a Data Source View
Define Semiadditive Behavior
Database permissions
Test an Action
Set Data Source Properties
Configure Measure Group Properties
Create Named Sets
Create Remote Partitions
Attach and Detach Analysis Services Databases
Configure Analysis Services Project Properties
Processing Databases, Dimensions and Partitions
Define a Regular Relationship and Regular Relationship Properties
Processing Options and Settings
Create a Dimension by Using an Existing Table
Define a Fact Relationship and Fact Relationship Properties
Add or Remove Tables or Views in a Data Source View
Add a Standard Action
Create a Data Source
Deploy Model Solutions with the Deployment Utility
Use Aggregate Functions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Haverfordwest
- 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 ... Specify Mark as Date Table for use with Time Intelligence
- See Training Course Details...
Process Tabular Model Partitions
Data sources supported in tabular 1400 models
Create a Calculated Column
Data sources supported in SSAS tabular 2016 Create Tabular Models
Understanding DAX in Tabular Models Measures
Change table, column
Add columns to a table
Import from Power Pivot
Create and Manage Roles
Row filter mappings
Create and Manage Measures KPIs
Define partitions in DirectQuery models
Create and Manage Partitions in the Workspace
Data sources supported in tabular 1200 models
Data sources supported in SSAS tabular 2017
Topics include- Overview of SSAS Tabular models
Create and Manage Tabular Model Partitions
Impersonation
Process Database, Table, or Partition
Email us about this courses
Other Haverfordwest Enable Technology Training Courses
JQuery Mobile Haverfordwest Training Courses
VBA - Haverfordwest Excel Training Courses
Power Query Haverfordwest Training Courses
Excel 365 Basic Haverfordwest Training Courses
PL/SQL Haverfordwest Training Courses
JavaScript - Haverfordwest JavaScript Training Courses