SQL SERVER ANALYSIS SERVICES TRAINING COURSES SALE
About Enable Technology Sale SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If delivery onsite is an issue we will organise a venue near you in Sale. All SQL Server Analysis Services courses can be customised to meet your particular 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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Shell UK Oil Products Ltd, Lloyds TSB Bank PLC, Royal Air Force, Fujistu PLC, South Staffordshire Water PLC, Wolverhampton City Council, Nuclear Engineering Services and Vodafone Group Services.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Sale
- 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 ... Explore Data in a Data Source View
- See Training Course Details...
Use Aggregate Functions
Deploy Model Solutions Using XMLA
Create User-Defined Hierarchies
View the XML for an Analysis Services Project Data Sources
Modify or Delete in Solution Explorer Database Dimensions
Create a Time Dimension by Generating a Time Table
Tools and Approaches for Processing
Create an Analysis Services Project
Configure Measure Group Properties
Work with Diagrams in Data Source View Designer
BI Wizard
KPIs Actions
Error Configuration Roles and Permissions
Set Data Source Properties
Create Named Sets
Define a Regular Relationship and Regular Relationship Properties
Test an Action
Create Measures and Measure Groups
Create Remote Partitions
Processing Options and Settings
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Sale
- 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 ... Hide or freeze columns
- See Training Course Details...
Enable DirectQuery mode in SSMS
Create and Manage Partitions in the Workspace
Import from Analysis Services
Create a Calculated Column
Add sample data to DirectQuery models
Create and Manage Roles
Create a Relationship Between Two Tables
Set the Data Type of a Column
Manage Roles by using SSMS
Topics include- Overview of SSAS Tabular models
Process Database, Table, or Partition
Import from Power View
Connect to a tabular model database
Version comparison
Create and Manage KPIs Hierarchies
Object-level security
Enable DirectQuery mode in SSDT
Import data by using a native query
Email us about this courses
Other Sale Enable Technology Training Courses
Excel 365 Intermediate Sale Training Courses
VBA Sale Training Courses
PL/SQL - Sale SQL Training Courses
JQuery Mobile - Sale JavaScript Training Courses
Excel 365 Advanced Sale Training Courses
Power BI - Sale Microsoft Power BI Training Courses