SQL SERVER ANALYSIS SERVICES TRAINING COURSES BURNLEY
About Enable Technology Burnley SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local venue in Burnley. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Carillion PLC, DHL Express, Birmingham City Council, Aston University, Yell Group PLC, Norwich Union PLC, Halfords Group PLC and Birmingham Heartlands Hospital.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Burnley
- 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 a Calculated Table
- See Training Course Details...
Version comparison
Import Data
Create and Manage Perspectives Translations Roles
Create and Manage Roles
Hide or freeze columns
Process Database, Table, or Partition
Understanding DAX in Tabular Models Measures
Object-level security
Test a model in DirectQuery mode
DirectQuery Mode
Manage Roles by using SSMS
Import from Power Pivot
Filter Data in a Table Relationships
Data sources supported in tabular 1400 models
Topics include- Overview of SSAS Tabular models
Import data by using a native query
Analyze a tabular model in Excel Deploy tabular model solutions
Add sample data to DirectQuery models
Bi-directional cross filters Calculations
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Burnley
- 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 ... Tools and Approaches for Processing
- See Training Course Details...
Create Local Partitions
Work with Diagrams in Data Source View Designer
Database permissions
Modify or Delete in Solution Explorer Database Dimensions
Defined Linked Measure Groups Partitions
Configure Measure Group Properties
Data Source object permissions
Define Named Calculations in a Data Source View
Explore Data in a Data Source View
Designing Aggregations
Error Configuration Roles and Permissions
Configure Analysis Services Project Properties
Set Data Source Properties
Add or Remove Tables or Views in a Data Source View
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Delete a Data Source View Dimensions
Define a Fact Relationship and Fact Relationship Properties
Processing Options and Settings
Create User-Defined Hierarchies
Create Calculated Members
Email us about this courses
Other Burnley Enable Technology Training Courses
Access Burnley Training Courses
TSQL - Burnley SQL Training Courses
SSRS - Burnley SQL Server Reporting Services Training Courses
VBA Burnley Training Courses
Data Warehouse Burnley Training Courses
Report Builder Burnley Training Courses