SQL SERVER ANALYSIS SERVICES TRAINING COURSES LANCASTER
About Enable Technology Lancaster SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. 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. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Lancaster. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are South Staffordshire Water PLC, Halfords Group PLC, University of Birmingham, National Power PLC, Unipart Group, Keele University, Homeserve PLC and Carillion PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Lancaster
- 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 ... Filter Data in a Table Relationships
- See Training Course Details...
Create and Manage Hierarchies Partitions
Rename a Table or Column
Database Process Partitions in the Workspace Database Perspectives
Hide or freeze columns
Create a New Tabular Model Project
Add sample data to DirectQuery models
Bi-directional cross filters Calculations
Add a table Delete a Table
Test a model in DirectQuery mode
Create and Manage Tabular Model Partitions
Create and Manage Measures KPIs
Data sources supported in SSAS tabular 2017
Data sources supported in SSAS tabular 2016 Create Tabular Models
Delete a Column
Object-level security
Topics include- Overview of SSAS Tabular models
Import from Analysis Services
Import from Power Pivot
DAX formula compatibility in DirectQuery mode Tables and Columns
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Lancaster
- 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 ... Configure Measure Group Properties
- See Training Course Details...
Create a Dimension by Generating a Non-Time Table in the Data Source
Supported Data Sources
Create User-Defined Hierarchies
Deploy Model Solutions Using XMLA
Processing Options and Settings
Overview of SSAS Multidimensional Modelling
Create Calculated Members
Batch Processing Remote Processing
Create Measures and Measure Groups
Change a Partition Source
Edit or Delete Partitions Merge Partitions
Configure Analysis Services Project Properties
Designing Aggregations
Data Source Views
Error Configuration Roles and Permissions
Create a Data Source
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define a Referenced Relationship and Referenced Relationship Properties
Create Named Sets
Add a Standard Action
Email us about this courses
Other Lancaster Enable Technology Training Courses
JQuery Mobile Lancaster Training Courses
Excel Power Pivot Lancaster Training Courses
Power Query Lancaster Training Courses
TSQL Lancaster Training Courses
SSIS - Lancaster SQL Server Integration Services Training Courses
SQL - Lancaster SQL Training Courses