SQL SERVER ANALYSIS SERVICES TRAINING COURSES MERTHYR TYDFIL
About Enable Technology Merthyr Tydfil SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Merthyr Tydfil. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training 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.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Yell Group PLC, Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, Homeserve PLC, Carillion PLC, Loughborough University, Aston University and Cadbury PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Merthyr Tydfil
- 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 Data
- See Training Course Details...
Hide or freeze columns
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Enable DirectQuery mode in SSMS
Import data by using a native query
Import from Analysis Services
Create a Calculated Table
Manage Roles by using SSMS
Enable DirectQuery mode in SSDT
Data sources supported in tabular 1200 models
Create and Manage Measures KPIs
Specify Mark as Date Table for use with Time Intelligence
Set the Data Type of a Column
Object-level security
Define partitions in DirectQuery models
Process Tabular Model Partitions
Test a model in DirectQuery mode
Add a table Delete a Table
DAX formula compatibility in DirectQuery mode Tables and Columns
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Merthyr Tydfil
- 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 ... Designing Aggregations
- See Training Course Details...
Set Impersonation Options for a Data Source Connection
Create Calculated Members
Define Attribute Relationships
Processing Options and Settings
Add or Remove Tables or Views in a Data Source View
Explore Data in a Data Source View
Create Measures and Measure Groups
Replace a Table or a Named Query in a Data Source View
Create User-Defined Hierarchies
Use a Template to Create an Action Deployment
KPIs Actions
Deploy Model Solutions Using XMLA
Define a Data Source View
Test an Action
Define Named Queries in a Data Source View
Using SQL Server Data Tools (SSDT)
Use Aggregate Functions
Deploy Model Solutions with the Deployment Utility
Deploy Model Solutions Using the Deployment Wizard
Partition Writeback Calculations
Email us about this courses
Other Merthyr Tydfil Enable Technology Training Courses
JavaScript - Merthyr Tydfil JavaScript Training Courses
JQuery - Merthyr Tydfil JavaScript Training Courses
SSRS - Merthyr Tydfil SQL Server Reporting Services Training Courses
Excel 365 Basic Merthyr Tydfil Training Courses
SQL Merthyr Tydfil Training Courses
Excel Power Pivot Merthyr Tydfil Training Courses