SQL SERVER ANALYSIS SERVICES TRAINING COURSES BRISTOL
About Enable Technology Bristol SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All of our tutors are Microsoft Certified Professionals. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
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. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Bristol. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Lloyds TSB Bank PLC, Yell Group PLC, Norfolk Police Constabulary, Total Telecommunications Limited, Nationwide Building Society Limited, Barclays Bank PLC, Boots UK Limited and Carillion PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bristol
- 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 ... Backup and Restore of Analysis Services Databases
- See Training Course Details...
Delete a Data Source View Dimensions
Define Attribute Relationships
Create an Analysis Services Project
Deploy Model Solutions with the Deployment Utility
Define a Regular Relationship and Regular Relationship Properties
Cube or model permissions Process permissions
Configure Measure Group Properties
Create Measures and Measure Groups
KPIs Actions
Set Data Source Properties
Ragged Hierarchies
BI Wizard
Overview of SSAS Multidimensional Modelling
Create User-Defined Hierarchies
Dimension permissions
Modify or Delete in Solution Explorer Database Dimensions
Create a Dimension by Using an Existing Table
Work with Diagrams in Data Source View Designer
Delete a Data Source
Change a Partition Source
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bristol
- 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 ... Tabular model designer
- See Training Course Details...
Import Data
Connect to a tabular model database
DAX formula compatibility in DirectQuery mode Tables and Columns
Object-level security
Enable DirectQuery mode in SSDT
Set the Data Type of a Column
Topics include- Overview of SSAS Tabular models
Create a Relationship Between Two Tables
Bi-directional cross filters Calculations
Understanding DAX in Tabular Models Measures
Restore from Power Pivot
DirectQuery Mode
Sort Data in a Table
Add sample data to DirectQuery models
Import from Power View
Add columns to a table
Database Process Partitions in the Workspace Database Perspectives
Data sources supported in tabular 1400 models
Email us about this courses
Other Bristol Enable Technology Training Courses
Excel 365 Basic Bristol Training Courses
Access - Bristol Access Training Courses
Data Warehouse - Bristol SQL Training Courses
Access VBA Bristol Training Courses
SQL Bristol Training Courses
JQuery - Bristol JavaScript Training Courses