SQL SERVER ANALYSIS SERVICES TRAINING COURSES ELLESMERE PORT
About Enable Technology Ellesmere Port SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the SQL Server Analysis Services course is at a local training site. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Total Telecommunications Limited, Nuclear Engineering Services, Yell Group PLC, Vodafone Group Services, Boots UK Limited, EDF Energy PLC, Capita Group PLC and Queen's Medical Centre Nottingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Ellesmere Port
- 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 ... Error Configuration Roles and Permissions
- See Training Course Details...
Create Named Sets
Change a Partition Source
Delete a Data Source
Define Time Intelligence
Supported Data Sources
Create a Dimension Using the Dimension Wizard
Explore Data in a Data Source View
Set Impersonation Options for a Data Source Connection
Define Attribute Relationships
Use Aggregate Functions
Processing Databases, Dimensions and Partitions
Overview of SSAS Multidimensional Modelling
Create Remote Partitions
Define Logical Primary Keys in a Data Source View
Cube or model permissions Process permissions
Data Source Views
Create Calculated Members
Deployment Requirements and Considerations for Analysis Services Deployment
Create User-Defined Hierarchies
Test an Action
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Ellesmere Port
- 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 ... Tabular model designer
- See Training Course Details...
Connect to a tabular model database
Create and Manage KPIs Hierarchies
Add sample data to DirectQuery models
Import data by using a native query
Create a Relationship Between Two Tables
Manage Roles by using SSMS
Bi-directional cross filters Calculations
Analyze in Excel
Import Data
Data sources supported in tabular 1400 models
Hide or freeze columns
Enable DirectQuery mode in SSDT
Specify Mark as Date Table for use with Time Intelligence
Object-level security
DAX formula compatibility in DirectQuery mode Tables and Columns
Add a table Delete a Table
Version comparison
Rename a Table or Column
Delete a Column
Change table, column
Email us about this courses
Other Ellesmere Port Enable Technology Training Courses
PL/SQL - Ellesmere Port SQL Training Courses
SSIS - Ellesmere Port SQL Server Integration Services Training Courses
Excel 365 Basic Ellesmere Port Training Courses
Access - Ellesmere Port Access Training Courses
JQuery Ellesmere Port Training Courses
Data Warehouse Ellesmere Port Training Courses