SQL SERVER ANALYSIS SERVICES TRAINING COURSES STOKE ON TRENT
About Enable Technology Stoke On Trent SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If you prefer we can offer an offsite training location in Stoke On Trent. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Unipart Group, Lloyds TSB Bank PLC, Countrywide Homes Limited, DHL Express, Wolverhampton City Council, Nuclear Engineering Services, GKN PLC and Boots UK Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stoke On Trent
- 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 ... Create a New Tabular Model Project
- See Training Course Details...
Import from Analysis Services
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create and Manage Tabular Model Partitions
Data types supported
Create a Relationship Between Two Tables
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Restore from Power Pivot
Sort Data in a Table
Import data by using a native query
DirectQuery Mode
Impersonation
Create and Manage Measures KPIs
Define partitions in DirectQuery models
Process Database, Table, or Partition
Tabular model designer
Set the Data Type of a Column
Data sources supported in SSAS tabular 2017
Row filter mappings
Process Tabular Model Partitions
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stoke On Trent
- 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 ... Move an Analysis Services Database
- See Training Course Details...
Add a Standard Action
Create a Dimension by Generating a Non-Time Table in the Data Source
Read Definition permissions
Configure Measure Group Properties
Define a Data Source View
Supported Data Sources
Modify or Delete in Solution Explorer Database Dimensions
Data Source object permissions
BI Wizard
View the XML for an Analysis Services Project Data Sources
Cube or model permissions Process permissions
Define a Referenced Relationship and Referenced Relationship Properties
Document and Script an Analysis Services Database
Set Partition Storage
Deploy Model Solutions Using the Deployment Wizard
Define a Regular Relationship and Regular Relationship Properties
Attach and Detach Analysis Services Databases
Work with Diagrams in Data Source View Designer
Use a Template to Create an Action Deployment
Define Logical Primary Keys in a Data Source View
Email us about this courses
Other Stoke On Trent Enable Technology Training Courses
Excel Power Pivot - Stoke On Trent Excel Training Courses
JQuery - Stoke On Trent JavaScript Training Courses
Access - Stoke On Trent Access Training Courses
Power BI - Stoke On Trent Microsoft Power BI Training Courses
TSQL Stoke On Trent Training Courses
JavaScript Stoke On Trent Training Courses