SQL SERVER ANALYSIS SERVICES TRAINING COURSES WALLASEY
About Enable Technology Wallasey SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Professionals. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
Enable Technology offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Wallasey. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time 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. Some of our clients are Loughborough University, Royal Air Force, Vodafone Group Services, Birmingham Heartlands Hospital, Cadbury PLC, South Staffordshire Water PLC, Countrywide Homes Limited and Norwich Union PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Wallasey
- 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 ... Specify Mark as Date Table for use with Time Intelligence
- See Training Course Details...
Set the Data Type of a Column
Tabular model designer
Version comparison
Import from Analysis Services
Topics include- Overview of SSAS Tabular models
Object-level security
Understanding DAX in Tabular Models Measures
Create a New Tabular Model Project
Import from Power View
Create and Manage KPIs Hierarchies
Data types supported
Create a Relationship Between Two Tables
Delete a Column
Import from Power Pivot
Create a Calculated Column
Connect to a tabular model database
DAX formula compatibility in DirectQuery mode Tables and Columns
Add columns to a table
Enable DirectQuery mode in SSDT
Create and Manage Measures KPIs
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Wallasey
- 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 ... Create a Dimension Using the Dimension Wizard
- See Training Course Details...
Attach and Detach Analysis Services Databases
Create a Dimension by Generating a Non-Time Table in the Data Source
Define Logical Primary Keys in a Data Source View
Deploy Model Solutions Using XMLA
Test an Action
Tools and Approaches for Processing
Define Time Intelligence
Processing Databases, Dimensions and Partitions
Define Semiadditive Behavior
Explore Data in a Data Source View
Database permissions
Set Partition Storage
Partition Writeback Calculations
Using SQL Server Data Tools (SSDT)
Defined Linked Measure Groups Partitions
Data Source Views
Create Named Sets
Authorizing access to objects and operations
Create a Data Source
Configure Analysis Services Project Properties
Email us about this courses
Other Wallasey Enable Technology Training Courses
VBA - Wallasey Excel Training Courses
DAX Wallasey Training Courses
JQuery Mobile Wallasey Training Courses
SQL Wallasey Training Courses
SSRS Wallasey Training Courses
JavaScript - Wallasey JavaScript Training Courses