SQL SERVER ANALYSIS SERVICES TRAINING COURSES MILFORD HAVEN
About Enable Technology Milford Haven SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If you prefer we can offer an offsite training location in Milford Haven. 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Royal & Sun Alliance Group PLC, West Bromwich Building Society, Nuclear Engineering Services, GKN PLC, National Power PLC, Queen's Medical Centre Nottingham, Birmingham City University and Lloyds TSB Bank PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Milford Haven
- 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 ... Data sources supported in tabular 1200 models
- See Training Course Details...
Filter Data in a Table Relationships
Object-level security
Manage Roles by using SSMS
Enable DirectQuery mode in SSMS
Restore from Power Pivot
Import Data
Sort Data in a Table
Delete a Column
Data types supported
Process Tabular Model Partitions
Understanding DAX in Tabular Models Measures
Bi-directional cross filters Calculations
Specify Mark as Date Table for use with Time Intelligence
DAX formula compatibility in DirectQuery mode Tables and Columns
Enable DirectQuery mode in SSDT
Create a Calculated Table
Set the Data Type of a Column
Create a Relationship Between Two Tables
Row filter mappings
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Milford Haven
- 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 ... Partition Writeback Calculations
- See Training Course Details...
View the XML for an Analysis Services Project Data Sources
Create a Dimension Using the Dimension Wizard
Attach and Detach Analysis Services Databases
Database permissions
Create Named Sets
Create a Dimension by Using an Existing Table
Define Time Intelligence
Replace a Table or a Named Query in a Data Source View
Create User-Defined Hierarchies
Data Source Views
Tools and Approaches for Processing
Supported Data Sources
Rename a Multidimensional Database Processing a multidimensional model
Change a Partition Source
Define a Regular Relationship and Regular Relationship Properties
Define Logical Relationships in a Data Source View
Define Attribute Relationships
Cube or model permissions Process permissions
Deploy Analysis Services Projects
Create Calculated Members
Email us about this courses
Other Milford Haven Enable Technology Training Courses
Access - Milford Haven Access Training Courses
JQuery - Milford Haven JavaScript Training Courses
SSRS - Milford Haven SQL Server Reporting Services Training Courses
Power BI - Milford Haven Microsoft Power BI Training Courses
PL/SQL - Milford Haven SQL Training Courses
JQuery Mobile Milford Haven Training Courses