SQL SERVER ANALYSIS SERVICES TRAINING COURSES NEWPORT
About Enable Technology Newport SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. 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.
Courses are instructor led and groups sizes small. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local socially distanced venue in Newport. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Keele University, Fujistu PLC, Birmingham City University, Countrywide Homes Limited, National Power PLC, Yell Group PLC, Aston University and GKN PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Newport
- 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 a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
- See Training Course Details...
Define Time Intelligence
Define Logical Primary Keys in a Data Source View
Deployment Requirements and Considerations for Analysis Services Deployment
Data Source Views
Delete a Data Source
Create Calculated Members
Change a Partition Source
Delete a Data Source View Dimensions
Add or Remove Tables or Views in a Data Source View
Data Source object permissions
BI Wizard
Processing Options and Settings
Edit or Delete Partitions Merge Partitions
Create a Dimension by Generating a Non-Time Table in the Data Source
Define a Regular Relationship and Regular Relationship Properties
Add a Standard Action
Backup and Restore of Analysis Services Databases
Ragged Hierarchies
Deploy Model Solutions Using XMLA
Deploy Analysis Services Projects
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Newport
- 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 ... Data sources supported in SSAS tabular 2017
- See Training Course Details...
Data sources supported in tabular 1200 models
Understanding DAX in Tabular Models Measures
Sort Data in a Table
Process Tabular Model Partitions
Import data by using a native query
Create and Manage Measures KPIs
Filter Data in a Table Relationships
Topics include- Overview of SSAS Tabular models
Define partitions in DirectQuery models
Change table, column
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Partitions in the Workspace
Enable DirectQuery mode in SSDT
Delete a Column
Create a Calculated Column
Data types supported
Create and Manage Tabular Model Partitions
Create a Relationship Between Two Tables
Enable DirectQuery mode in SSMS
Tabular model designer
Email us about this courses
Other Newport Enable Technology Training Courses
SSIS Newport Training Courses
JQuery Mobile - Newport JavaScript Training Courses
SSRS - Newport SQL Server Reporting Services Training Courses
Excel Power Pivot Newport Training Courses
Excel 365 Intermediate Newport Training Courses
DAX Newport Training Courses