SQL SERVER ANALYSIS SERVICES TRAINING COURSES GLOUCESTERSHIRE
About Enable Technology Gloucestershire 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. All Enable Technology tutors are Microsoft certified experts. All course participants are issued SQL Server Analysis Services training manuals they can refer to 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.
Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a socially distanced venue near you in Gloucestershire. 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 also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are DHL Express, Birmingham Heartlands Hospital, Carillion PLC, Birmingham City Council, EDF Energy PLC, Birmingham City University, Nuclear Engineering Services and Countrywide Homes Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Gloucestershire
- 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 ... Manage Roles by using SSMS
- See Training Course Details...
Create and Manage Partitions in the Workspace
Enable DirectQuery mode in SSDT
Create and Manage Roles
Create a Calculated Column
Add sample data to DirectQuery models
Bi-directional cross filters Calculations
Import from Analysis Services
Rename a Table or Column
Specify Mark as Date Table for use with Time Intelligence
Enable DirectQuery mode in SSMS
Object-level security
Data sources supported in tabular 1400 models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Change table, column
Data sources supported in tabular 1200 models
Hide or freeze columns
Data sources supported in SSAS tabular 2016 Create Tabular Models
Import from Power Pivot
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Gloucestershire
- 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 ... Replace a Table or a Named Query in a Data Source View
- See Training Course Details...
KPIs Actions
Create User-Defined Hierarchies
Backup and Restore of Analysis Services Databases
Create Measures and Measure Groups
Create Remote Partitions
Create Named Sets
Use Aggregate Functions
Supported Data Sources
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Set Impersonation Options for a Data Source Connection
Overview of SSAS Multidimensional Modelling
Designing Aggregations
Define a Data Source View
Create a Dimension by Using an Existing Table
Move an Analysis Services Database
Create a Time Dimension by Generating a Time Table
Cube or model permissions Process permissions
Document and Script an Analysis Services Database
Create Local Partitions
Define Attribute Relationships
Email us about this courses
Other Gloucestershire Enable Technology Training Courses
JavaScript - Gloucestershire JavaScript Training Courses
Data Warehouse Gloucestershire Training Courses
Excel 365 Basic - Gloucestershire Excel Training Courses
Report Builder Gloucestershire Training Courses
JQuery Mobile - Gloucestershire JavaScript Training Courses
Power BI Gloucestershire Training Courses