SQL SERVER ANALYSIS SERVICES TRAINING COURSES KIRKBY
About Enable Technology Kirkby 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. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. 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 Kirkby. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: National Power PLC, Capita Group PLC, DHL Express, Yell Group PLC, Royal & Sun Alliance Group PLC, Nuclear Engineering Services, Royal Air Force and Dollond & Aitchison Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Kirkby
- 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 ... Move an Analysis Services Database
- See Training Course Details...
Create a Dimension Using the Dimension Wizard
Processing Databases, Dimensions and Partitions
Create Local Partitions
Create Remote Partitions
Configure Measure Group Properties
Add or Remove Tables or Views in a Data Source View
Modify or Delete in Solution Explorer Database Dimensions
Set Data Source Properties
Set Partition Storage
Tools and Approaches for Processing
BI Wizard
Ragged Hierarchies
Data Source object permissions
Cube or model permissions Process permissions
Create Calculated Members
Deployment Requirements and Considerations for Analysis Services Deployment
Delete a Data Source
Create a Dimension by Using an Existing Table
Error Configuration Roles and Permissions
Work with Diagrams in Data Source View Designer
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Kirkby
- 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 ... Import from Power Pivot
- See Training Course Details...
Analyze a tabular model in Excel Deploy tabular model solutions
Rename a Table or Column
Bi-directional cross filters Calculations
Create and Manage Tabular Model Partitions
Data sources supported in tabular 1400 models
Process Tabular Model Partitions
Delete Relationships
Hide or freeze columns
Test a model in DirectQuery mode
Understanding DAX in Tabular Models Measures
Change table, column
Impersonation
Create a Calculated Table
Manage Roles by using SSMS
Version comparison
Create a Relationship Between Two Tables
Define partitions in DirectQuery models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create and Manage KPIs Hierarchies
Enable DirectQuery mode in SSMS
Email us about this courses
Other Kirkby Enable Technology Training Courses
Data Warehouse - Kirkby SQL Training Courses
DAX Kirkby Training Courses
JQuery - Kirkby JavaScript Training Courses
Excel 365 Basic Kirkby Training Courses
SSRS Kirkby Training Courses
Excel 365 Intermediate - Kirkby Excel Training Courses