SQL SERVER ANALYSIS SERVICES TRAINING COURSES MIDDLETON
About Enable Technology Middleton SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. 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. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local venue in Middleton. 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Aston University, Norfolk Police Constabulary, Nuclear Engineering Services, National Power PLC, GKN PLC, Wolverhampton City Council, South Staffordshire Water PLC and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Middleton
- 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 ... BI Wizard
- See Training Course Details...
Delete a Data Source
Create Measures and Measure Groups
Defined Linked Measure Groups Partitions
Processing Options and Settings
Read Definition permissions
Create Local Partitions
KPIs Actions
Define Named Calculations in a Data Source View
Authorizing access to objects and operations
Supported Data Sources
Define a Data Source View
Set Partition Storage
Error Configuration Roles and Permissions
Designing Aggregations
Configure Measure Group Properties
Document and Script an Analysis Services Database
Define Named Queries in a Data Source View
Set Impersonation Options for a Data Source Connection
Deployment Requirements and Considerations for Analysis Services Deployment
Use Aggregate Functions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Middleton
- 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 View
- See Training Course Details...
Analyze a tabular model in Excel Deploy tabular model solutions
Data types supported
Specify Mark as Date Table for use with Time Intelligence
DAX formula compatibility in DirectQuery mode Tables and Columns
Test a model in DirectQuery mode
Import from Power Pivot
Tabular model designer
Enable DirectQuery mode in SSMS
Manage Roles by using SSMS
DirectQuery Mode
Add columns to a table
Delete Relationships
Create a Relationship Between Two Tables
Rename a Table or Column
Data sources supported in tabular 1400 models
Create and Manage Perspectives Translations Roles
Delete a Column
Database Process Partitions in the Workspace Database Perspectives
Bi-directional cross filters Calculations
Email us about this courses
Other Middleton Enable Technology Training Courses
Excel 365 Advanced - Middleton Excel Training Courses
SQL Middleton Training Courses
Data Warehouse - Middleton SQL Training Courses
Power BI - Middleton Microsoft Power BI Training Courses
TSQL Middleton Training Courses
PL/SQL - Middleton SQL Training Courses