SQL SERVER ANALYSIS SERVICES TRAINING COURSES STROUD
About Enable Technology Stroud SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The training will be delivered by a Microsoft professional with development experience. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Stroud. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Nationwide Building Society Limited, Norwich Union PLC, Carillion PLC, Nuclear Engineering Services, Countrywide Homes Limited, Vodafone Group Services, Cadbury PLC and Royal Air Force.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stroud
- 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 ... Create a Relationship Between Two Tables
- See Training Course Details...
Import from Power View
Import from Analysis Services
Create a Calculated Table
Data sources supported in tabular 1400 models
Database Process Partitions in the Workspace Database Perspectives
Sort Data in a Table
Impersonation
Change table, column
Create and Manage Roles
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Process Database, Table, or Partition
Import data by using a native query
Analyze in Excel
Enable DirectQuery mode in SSDT
Add sample data to DirectQuery models
Specify Mark as Date Table for use with Time Intelligence
Connect to a tabular model database
Delete Relationships
Data sources supported in tabular 1200 models
Data sources supported in SSAS tabular 2017
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stroud
- 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 ... View the XML for an Analysis Services Project Data Sources
- See Training Course Details...
Create Named Sets
Document and Script an Analysis Services Database
Define Time Intelligence
Multidimensional models
Rename a Multidimensional Database Processing a multidimensional model
Database permissions
Create a Dimension by Using an Existing Table
Supported Data Sources
Use Aggregate Functions
Tools and Approaches for Processing
Define Named Calculations in a Data Source View
Add or Remove Tables or Views in a Data Source View
Defined Linked Measure Groups Partitions
Read Definition permissions
Processing Options and Settings
Create an Analysis Services Project
Authorizing access to objects and operations
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create User-Defined Hierarchies
Delete a Data Source View Dimensions
Email us about this courses
Other Stroud Enable Technology Training Courses
Report Builder - Stroud SQL Server Reporting Services Training Courses
JQuery Mobile Stroud Training Courses
Power Query Stroud Training Courses
TSQL - Stroud SQL Training Courses
PL/SQL - Stroud SQL Training Courses
Data Warehouse - Stroud SQL Training Courses