SQL SERVER ANALYSIS SERVICES TRAINING COURSES BURY
About Enable Technology Bury SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
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. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Bury. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are TalkTalk Direct Limited, Wolverhampton City Council, Royal & Sun Alliance Group PLC, University of Birmingham, Fujistu PLC, Total Telecommunications Limited, Vodafone Group Services and Keele University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bury
- 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 ... Define Logical Primary Keys in a Data Source View
- See Training Course Details...
Document and Script an Analysis Services Database
Define Named Calculations in a Data Source View
Deploy Model Solutions Using the Deployment Wizard
Create a Dimension Using the Dimension Wizard
Create User-Defined Hierarchies
Backup Options Restore Options
Data Source Views
Use Aggregate Functions
Use a Template to Create an Action Deployment
Create a Time Dimension by Generating a Time Table
Tools and Approaches for Processing
Deploy Analysis Services Projects
Set Data Source Properties
Designing Aggregations
Rename a Multidimensional Database Processing a multidimensional model
Create Local Partitions
Define a Fact Relationship and Fact Relationship Properties
Create Remote Partitions
Define Semiadditive Behavior
Create Measures and Measure Groups
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bury
- 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 ... Deploy from SQL Server Data Tools Manage Tabular Model Databases
- See Training Course Details...
Change table, column
Data sources supported in SSAS tabular 2017
Enable DirectQuery mode in SSDT
Manage Roles by using SSMS
Impersonation
Delete Relationships
Data sources supported in tabular 1200 models
Create and Manage Hierarchies Partitions
Specify Mark as Date Table for use with Time Intelligence
Connect to a tabular model database
Filter Data in a Table Relationships
Create and Manage Partitions in the Workspace
Create and Manage Roles
Create a Relationship Between Two Tables
Create a Calculated Table
Sort Data in a Table
Create and Manage Measures KPIs
Data sources supported in tabular 1400 models
Email us about this courses
Other Bury Enable Technology Training Courses
Power Query - Bury Excel Training Courses
TSQL - Bury SQL Training Courses
PL/SQL Bury Training Courses
SSRS Bury Training Courses
JQuery Mobile - Bury JavaScript Training Courses
DAX - Bury Excel Training Courses