SQL SERVER ANALYSIS SERVICES TRAINING COURSES BATLEY
About Enable Technology Batley SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The tutor delivering the course will be a Microsoft certified expert. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Batley. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Unipart Group, Capita Group PLC, Boots UK Limited, Wolverhampton City Council, Keele University, Barclays Bank PLC, Queen's Medical Centre Nottingham and Dollond & Aitchison Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Batley
- 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 ... Modify or Delete in Solution Explorer Database Dimensions
- See Training Course Details...
Explore Data in a Data Source View
Deployment Requirements and Considerations for Analysis Services Deployment
Create an Analysis Services Project
Supported Data Sources
Create Calculated Members
Dimension permissions
Define Logical Primary Keys in a Data Source View
View the XML for an Analysis Services Project Data Sources
Create Local Partitions
Define Time Intelligence
Create Measures and Measure Groups
Set Data Source Properties
Use Aggregate Functions
Replace a Table or a Named Query in a Data Source View
Define Named Calculations in a Data Source View
Add a Standard Action
Calculations using the Business Intelligence Wizard
Create a Time Dimension by Generating a Time Table
Database permissions
Processing Options and Settings
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Batley
- 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 ... Create and Manage KPIs Hierarchies
- See Training Course Details...
Process Database, Table, or Partition
Create and Manage Roles
Bi-directional cross filters Calculations
Create and Manage Perspectives Translations Roles
Data sources supported in tabular 1400 models
Database Process Partitions in the Workspace Database Perspectives
Change table, column
DirectQuery Mode
Create and Manage Tabular Model Partitions
Data sources supported in tabular 1200 models
Sort Data in a Table
Topics include- Overview of SSAS Tabular models
Import from Analysis Services
Import Data
Set the Data Type of a Column
Add columns to a table
Create a New Tabular Model Project
Object-level security
Specify Mark as Date Table for use with Time Intelligence
Email us about this courses
Other Batley Enable Technology Training Courses
Power BI Batley Training Courses
DAX Batley Training Courses
VBA - Batley Excel Training Courses
SQL Batley Training Courses
Access - Batley Access Training Courses
Oracle SQL - Batley SQL Training Courses