SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACKPOOL
About Enable Technology Blackpool SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology 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 also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
We provide instructor led training coupled with hands on training. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in Blackpool. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Royal & Sun Alliance Group PLC, National Power PLC, Norfolk Police Constabulary, Norwich Union PLC, EDF Energy PLC, Nationwide Building Society Limited, Total Telecommunications Limited and Lloyds TSB Bank PLC.
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 ... Set the Data Type of a Column
- See Training Course Details...
Create and Manage Tabular Model Partitions
Version comparison
Add sample data to DirectQuery models
Create a Calculated Column
Enable DirectQuery mode in SSMS
Topics include- Overview of SSAS Tabular models
Add columns to a table
Delete Relationships
Change table, column
Impersonation
Filter Data in a Table Relationships
DirectQuery Mode
Define partitions in DirectQuery models
Import from Power View
Data sources supported in tabular 1400 models
Create a New Tabular Model Project
Import Data
Enable DirectQuery mode in SSDT
Data types supported
Create and Manage Measures KPIs
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 ... Read Definition permissions
- See Training Course Details...
Configure Analysis Services Project Properties
Test an Action
Set Data Source Properties
Modify or Delete in Solution Explorer Database Dimensions
Using SQL Server Data Tools (SSDT)
Replace a Table or a Named Query in a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
Database permissions
Explore Data in a Data Source View
Calculations using the Business Intelligence Wizard
Deploy Analysis Services Projects
Error Configuration Roles and Permissions
Modify or Delete an Analysis Services Database
Create Local Partitions
Add or Remove Tables or Views in a Data Source View
View the XML for an Analysis Services Project Data Sources
Create a Dimension by Using an Existing Table
Document and Script an Analysis Services Database
Define Logical Primary Keys in a Data Source View
Edit or Delete Partitions Merge Partitions
Email us about this courses
Other Blackpool Enable Technology Training Courses
Power Query - Blackpool Excel Training Courses
PL/SQL Blackpool Training Courses
SQL Blackpool Training Courses
Excel Power Pivot Blackpool Training Courses
Power BI - Blackpool Microsoft Power BI Training Courses
Excel 365 Basic - Blackpool Excel Training Courses