SQL SERVER ANALYSIS SERVICES TRAINING COURSES ACCRINGTON
About Enable Technology Accrington SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued SQL Server Analysis Services training manuals they can 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.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Another option is we can organise a local training site in Accrington. 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.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Royal & Sun Alliance Group PLC, Unipart Group, Nuclear Engineering Services, Loughborough University, Birmingham City Council, Nationwide Building Society Limited, Queen's Medical Centre Nottingham and Boots UK Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Accrington
- 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 ... Object-level security
- See Training Course Details...
Create a Calculated Column
Hide or freeze columns
Import from Power Pivot
Process Database, Table, or Partition
Analyze in Excel
Topics include- Overview of SSAS Tabular models
Data sources supported in SSAS tabular 2017
Bi-directional cross filters Calculations
Version comparison
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create and Manage Tabular Model Partitions
Enable DirectQuery mode in SSMS
Data sources supported in tabular 1200 models
Create a New Tabular Model Project
Impersonation
Create and Manage Measures KPIs
Create and Manage KPIs Hierarchies
Add a table Delete a Table
Understanding DAX in Tabular Models Measures
Row filter mappings
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Accrington
- 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 ... Defined Linked Measure Groups Partitions
- See Training Course Details...
Set Data Source Properties
Cube or model permissions Process permissions
Create Remote Partitions
Modify or Delete in Solution Explorer Database Dimensions
Tools and Approaches for Processing
Document and Script an Analysis Services Database
Delete a Data Source
Create a Dimension by Generating a Non-Time Table in the Data Source
Use a Template to Create an Action Deployment
Processing Options and Settings
Create a Dimension by Using an Existing Table
Set Partition Storage
Define Assignments and Other Script Commands
Create Calculated Members
Error Configuration Roles and Permissions
Create a Dimension Using the Dimension Wizard
Dimension permissions
Supported Data Sources
Define Logical Relationships in a Data Source View
Set Impersonation Options for a Data Source Connection
Email us about this courses
Other Accrington Enable Technology Training Courses
JavaScript Accrington Training Courses
Excel 365 Advanced Accrington Training Courses
TSQL - Accrington SQL Training Courses
SSRS - Accrington SQL Server Reporting Services Training Courses
VBA - Accrington Excel Training Courses
SQL - Accrington SQL Training Courses