SQL SERVER ANALYSIS SERVICES TRAINING COURSES TROWBRIDGE
About Enable Technology Trowbridge SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
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. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Trowbridge. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Royal & Sun Alliance Group PLC, Vodafone Group Services, Carillion PLC, Shell UK Oil Products Ltd, West Bromwich Building Society, National Power PLC, Nationwide Building Society Limited and Queen's Medical Centre Nottingham.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Trowbridge
- 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 ... Import from Analysis Services
- See Training Course Details...
Add columns to a table
Import data by using a native query
Delete Relationships
Create a New Tabular Model Project
Version comparison
Import from Power Pivot
Create a Calculated Table
Test a model in DirectQuery mode
Create a Relationship Between Two Tables
Data sources supported in SSAS tabular 2017
Add sample data to DirectQuery models
Define partitions in DirectQuery models
Restore from Power Pivot
Create and Manage KPIs Hierarchies
Create and Manage Tabular Model Partitions
Process Database, Table, or Partition
Connect to a tabular model database
Topics include- Overview of SSAS Tabular models
Manage Roles by using SSMS
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Trowbridge
- 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 ... Deploy Model Solutions with the Deployment Utility
- See Training Course Details...
BI Wizard
Explore Data in a Data Source View
Define Logical Primary Keys in a Data Source View
Change a Partition Source
Ragged Hierarchies
Deploy Model Solutions Using the Deployment Wizard
Attach and Detach Analysis Services Databases
Add or Remove Tables or Views in a Data Source View
Create Named Sets
Tools and Approaches for Processing
Backup and Restore of Analysis Services Databases
Define a Data Source View
Replace a Table or a Named Query in a Data Source View
Define Named Calculations in a Data Source View
Modify or Delete in Solution Explorer Database Dimensions
Define Assignments and Other Script Commands
Define Attribute Relationships
Cube or model permissions Process permissions
Create a Time Dimension by Generating a Time Table
Read Definition permissions
Email us about this courses
Other Trowbridge Enable Technology Training Courses
SSRS - Trowbridge SQL Server Reporting Services Training Courses
Power BI - Trowbridge Microsoft Power BI Training Courses
Excel 365 Advanced - Trowbridge Excel Training Courses
Excel Power Pivot Trowbridge Training Courses
SSIS Trowbridge Training Courses
VBA Trowbridge Training Courses