SQL SERVER ANALYSIS SERVICES TRAINING COURSES SCARBOROUGH
About Enable Technology Scarborough SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Professionals. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Scarborough. 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: Wolverhampton City Council, Homeserve PLC, Lloyds TSB Bank PLC, EDF Energy PLC, GKN PLC, Norfolk Police Constabulary, Nuclear Engineering Services and Boots UK Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Scarborough
- 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 Measures KPIs
- See Training Course Details...
DAX formula compatibility in DirectQuery mode Tables and Columns
Data sources supported in SSAS tabular 2017
Import data by using a native query
Create and Manage Tabular Model Partitions
Object-level security
Row filter mappings
Change table, column
Create and Manage KPIs Hierarchies
Import from Power Pivot
Topics include- Overview of SSAS Tabular models
Hide or freeze columns
Create a Relationship Between Two Tables
Add a table Delete a Table
Create and Manage Partitions in the Workspace
Create and Manage Roles
Import from Power View
Import Data
Restore from Power Pivot
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Delete a Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Scarborough
- 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 ... Configure Analysis Services Project Properties
- See Training Course Details...
Modify or Delete an Analysis Services Database
Move an Analysis Services Database
Create User-Defined Hierarchies
Define Logical Primary Keys in a Data Source View
Deploy Analysis Services Projects
Attach and Detach Analysis Services Databases
Create a Time Dimension by Generating a Time Table
Create an Analysis Services Project
Delete a Data Source View Dimensions
Tools and Approaches for Processing
Read Definition permissions
Supported Data Sources
Add or Remove Tables or Views in a Data Source View
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define Named Calculations in a Data Source View
Define Semiadditive Behavior
Use a Template to Create an Action Deployment
Edit or Delete Partitions Merge Partitions
View the XML for an Analysis Services Project Data Sources
Data Source Views
Email us about this courses
Other Scarborough Enable Technology Training Courses
VBA Scarborough Training Courses
JQuery Scarborough Training Courses
Access - Scarborough Access Training Courses
Power BI Scarborough Training Courses
Excel Power Pivot Scarborough Training Courses
Oracle SQL - Scarborough SQL Training Courses