SQL SERVER ANALYSIS SERVICES TRAINING COURSES POOLE
About Enable Technology Poole SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given SQL Server Analysis Services courseware which they can refer to 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.
Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. We are also more than happy to organise a local course at a training location in Poole. All SQL Server Analysis Services courses can be customised to meet your particular requirements.
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.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Norfolk Police Constabulary, Royal Air Force, Halfords Group PLC, Nuclear Engineering Services, Dollond & Aitchison Limited, Shell UK Oil Products Ltd, Homeserve PLC and Boots UK Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Poole
- 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 ... Object-level security
- See Training Course Details...
Create a Relationship Between Two Tables
Create and Manage Hierarchies Partitions
Hide or freeze columns
Bi-directional cross filters Calculations
Understanding DAX in Tabular Models Measures
Process Tabular Model Partitions
Restore from Power Pivot
Create and Manage Measures KPIs
Define partitions in DirectQuery models
Row filter mappings
Delete Relationships
Filter Data in a Table Relationships
Create a New Tabular Model Project
Create and Manage Partitions in the Workspace
Import from Power View
Impersonation
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Roles
Rename a Table or Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Poole
- 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 ... Data Source Views
- See Training Course Details...
Deploy Analysis Services Projects
Configure Analysis Services Project Properties
Defined Linked Measure Groups Partitions
Define Attribute Relationships
Configure Measure Group Properties
Delete a Data Source
Define Semiadditive Behavior
View the XML for an Analysis Services Project Data Sources
Create Local Partitions
Multidimensional models
Attach and Detach Analysis Services Databases
Create a Data Source
Modify or Delete in Solution Explorer Database Dimensions
Set Impersonation Options for a Data Source Connection
Define Named Calculations in a Data Source View
Define Time Intelligence
Processing Databases, Dimensions and Partitions
Create an Analysis Services Project
Delete a Data Source View Dimensions
Create a Dimension by Generating a Non-Time Table in the Data Source
Email us about this courses
Other Poole Enable Technology Training Courses
JQuery Mobile Poole Training Courses
SQL - Poole SQL Training Courses
Excel 365 Advanced - Poole Excel Training Courses
SSRS - Poole SQL Server Reporting Services Training Courses
JavaScript - Poole JavaScript Training Courses
VBA - Poole Excel Training Courses