SQL SERVER ANALYSIS SERVICES TRAINING COURSES DYFED
About Enable Technology Dyfed SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued SQL Server Analysis Services training manuals they can refer to 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.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. 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 Dyfed. We are happy to modify the SQL Server Analysis Services syllabus to match your teams 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Aston University, Lloyds TSB Bank PLC, Homeserve PLC, Total Telecommunications Limited, Royal & Sun Alliance Group PLC, Nuclear Engineering Services, University of Birmingham and Loughborough University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Dyfed
- 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 Semiadditive Behavior
- See Training Course Details...
Partition Writeback Calculations
Create Measures and Measure Groups
Define Logical Primary Keys in a Data Source View
Create User-Defined Hierarchies
Create a Data Source
Create Remote Partitions
Create a Dimension by Generating a Non-Time Table in the Data Source
Create an Analysis Services Project
Defined Linked Measure Groups Partitions
Overview of SSAS Multidimensional Modelling
Define Attribute Relationships
Test an Action
Use Aggregate Functions
Processing Databases, Dimensions and Partitions
Ragged Hierarchies
Move an Analysis Services Database
View the XML for an Analysis Services Project Data Sources
Add a Standard Action
Deploy Model Solutions Using the Deployment Wizard
Change a Partition Source
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Dyfed
- 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 ... Row filter mappings
- See Training Course Details...
Data sources supported in tabular 1200 models
Create and Manage Hierarchies Partitions
Sort Data in a Table
Create and Manage KPIs Hierarchies
Impersonation
Change table, column
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Measures KPIs
Import Data
Process Database, Table, or Partition
Create and Manage Roles
Database Process Partitions in the Workspace Database Perspectives
Import from Power Pivot
Data sources supported in SSAS tabular 2016 Create Tabular Models
Delete a Column
DAX formula compatibility in DirectQuery mode Tables and Columns
Connect to a tabular model database
Data sources supported in tabular 1400 models
Specify Mark as Date Table for use with Time Intelligence
Email us about this courses
Other Dyfed Enable Technology Training Courses
Power BI Dyfed Training Courses
Access VBA - Dyfed Access Training Courses
SSRS Dyfed Training Courses
JQuery Mobile - Dyfed JavaScript Training Courses
SSIS - Dyfed SQL Server Integration Services Training Courses
Excel Power Pivot - Dyfed Excel Training Courses