SQL SERVER ANALYSIS SERVICES TRAINING COURSES EVESHAM
About Enable Technology Evesham SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. We guarantee the training will be delivered by a Microsoft certified expert. We provide every candidate with SQL Server Analysis Services training materials which they keep 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.
Courses are instructor led and groups sizes small. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. If delivery onsite is an issue we will organise a socially distanced venue near you in Evesham. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Royal Air Force, Carillion PLC, Dollond & Aitchison Limited, Nationwide Building Society Limited, Total Telecommunications Limited, Halfords Group PLC, DHL Express and EDF Energy PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Evesham
- 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 ... Delete Relationships
- See Training Course Details...
Enable DirectQuery mode in SSDT
Connect to a tabular model database
Create and Manage Measures KPIs
Create and Manage Tabular Model Partitions
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Process Tabular Model Partitions
Data sources supported in tabular 1400 models
Restore from Power Pivot
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create a Calculated Column
Add columns to a table
Understanding DAX in Tabular Models Measures
Define partitions in DirectQuery models
Import data by using a native query
Import from Analysis Services
Create and Manage Perspectives Translations Roles
Hide or freeze columns
Create a Relationship Between Two Tables
Import from Power Pivot
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Evesham
- 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 ... Database permissions
- See Training Course Details...
Create Calculated Members
Rename a Multidimensional Database Processing a multidimensional model
Set Partition Storage
Define Logical Primary Keys in a Data Source View
Configure Analysis Services Project Properties
Designing Aggregations
Define Logical Relationships in a Data Source View
Create a Time Dimension by Generating a Time Table
Explore Data in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Add or Remove Tables or Views in a Data Source View
Define Named Queries in a Data Source View
Batch Processing Remote Processing
Partition Writeback Calculations
Data Source Views
Set Impersonation Options for a Data Source Connection
Create User-Defined Hierarchies
View the XML for an Analysis Services Project Data Sources
KPIs Actions
Configure Measure Group Properties
Email us about this courses
Other Evesham Enable Technology Training Courses
Power BI Evesham Training Courses
Access VBA Evesham Training Courses
Power Query - Evesham Excel Training Courses
Excel 365 Intermediate - Evesham Excel Training Courses
Excel 365 Advanced Evesham Training Courses
SQL Evesham Training Courses