SQL SERVER ANALYSIS SERVICES TRAINING COURSES TEWKESBURY
About Enable Technology Tewkesbury SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All Enable Technology tutors are Microsoft certified experts. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If you prefer we can offer an offsite training location in Tewkesbury. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: National Power PLC, Norwich Union PLC, Countrywide Homes Limited, Birmingham Heartlands Hospital, Birmingham City Council, Queen's Medical Centre Nottingham, GKN PLC and Homeserve PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Tewkesbury
- 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 Regular Relationship and Regular Relationship Properties
- See Training Course Details...
Define Named Queries in a Data Source View
Define Attribute Relationships
Set Impersonation Options for a Data Source Connection
Define Time Intelligence
Define Logical Primary Keys in a Data Source View
Modify or Delete in Solution Explorer Database Dimensions
Partition Writeback Calculations
View the XML for an Analysis Services Project Data Sources
Set Partition Storage
Error Configuration Roles and Permissions
Ragged Hierarchies
Edit or Delete Partitions Merge Partitions
Create an Analysis Services Project
Create Calculated Members
Processing Options and Settings
Use a Template to Create an Action Deployment
Processing Databases, Dimensions and Partitions
Define Assignments and Other Script Commands
Designing Aggregations
Overview of SSAS Multidimensional Modelling
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Tewkesbury
- 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 and Manage Perspectives Translations Roles
- See Training Course Details...
Tabular model designer
Hide or freeze columns
Connect to a tabular model database
Add columns to a table
Database Process Partitions in the Workspace Database Perspectives
Filter Data in a Table Relationships
Create a Calculated Table
Process Tabular Model Partitions
Import Data
Test a model in DirectQuery mode
Analyze a tabular model in Excel Deploy tabular model solutions
Import from Power Pivot
Enable DirectQuery mode in SSMS
Manage Roles by using SSMS
Data sources supported in tabular 1400 models
Add sample data to DirectQuery models
Data sources supported in SSAS tabular 2016 Create Tabular Models
Specify Mark as Date Table for use with Time Intelligence
Create and Manage KPIs Hierarchies
Email us about this courses
Other Tewkesbury Enable Technology Training Courses
JQuery Tewkesbury Training Courses
JQuery Mobile Tewkesbury Training Courses
TSQL - Tewkesbury SQL Training Courses
SQL Tewkesbury Training Courses
Power BI Tewkesbury Training Courses
Power Query - Tewkesbury Excel Training Courses