SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACKPOOL
About Enable Technology Blackpool 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. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Blackpool. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Shell UK Oil Products Ltd, Dollond & Aitchison Limited, Royal Air Force, Vodafone Group Services, Unipart Group, Countrywide Homes Limited, DHL Express and Nuclear Engineering Services.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Blackpool
- 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 ... Understanding DAX in Tabular Models Measures
- See Training Course Details...
Impersonation
Test a model in DirectQuery mode
Data sources supported in tabular 1400 models
Analyze in Excel
Tabular model designer
Set the Data Type of a Column
Add a table Delete a Table
Enable DirectQuery mode in SSMS
Restore from Power Pivot
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create a Relationship Between Two Tables
Delete a Column
Connect to a tabular model database
Import data by using a native query
Analyze a tabular model in Excel Deploy tabular model solutions
Create a New Tabular Model Project
Data types supported
Create a Calculated Table
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Blackpool
- 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 ... Deploy Analysis Services Projects
- See Training Course Details...
Modify or Delete in Solution Explorer Database Dimensions
Create Local Partitions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Cube or model permissions Process permissions
Database permissions
Set Data Source Properties
Add a Standard Action
BI Wizard
Data Source Views
Define Assignments and Other Script Commands
Create a Dimension Using the Dimension Wizard
Configure Measure Group Properties
Deploy Model Solutions with the Deployment Utility
Defined Linked Measure Groups Partitions
Document and Script an Analysis Services Database
Supported Data Sources
Define Semiadditive Behavior
Define Named Queries in a Data Source View
Define Attribute Relationships
Read Definition permissions
Email us about this courses
Other Blackpool Enable Technology Training Courses
Excel Power Pivot - Blackpool Excel Training Courses
JavaScript - Blackpool JavaScript Training Courses
VBA Blackpool Training Courses
JQuery Blackpool Training Courses
SSIS Blackpool Training Courses
JQuery Mobile - Blackpool JavaScript Training Courses