SQL SERVER ANALYSIS SERVICES TRAINING COURSES BARRY
About Enable Technology Barry SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
Enable Technology training courses are delivered as instructor led courses. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite training location in Barry. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Vodafone Group Services, Unipart Group, EDF Energy PLC, Capita Group PLC, Norwich Union PLC, Royal Air Force, DHL Express and Queen's Medical Centre Nottingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Barry
- 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 ... Calculations using the Business Intelligence Wizard
- See Training Course Details...
Set Data Source Properties
Define a Regular Relationship and Regular Relationship Properties
Multidimensional models
Create Measures and Measure Groups
Configure Analysis Services Project Properties
Deploy Analysis Services Projects
Supported Data Sources
Attach and Detach Analysis Services Databases
Define Logical Primary Keys in a Data Source View
Edit or Delete Partitions Merge Partitions
Define Attribute Relationships
Explore Data in a Data Source View
Deployment Requirements and Considerations for Analysis Services Deployment
Define Time Intelligence
Data Source Views
Define a Fact Relationship and Fact Relationship Properties
Define Assignments and Other Script Commands
Authorizing access to objects and operations
KPIs Actions
Replace a Table or a Named Query in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Barry
- 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 ... Analyze in Excel
- See Training Course Details...
Create and Manage Tabular Model Partitions
Connect to a tabular model database
Topics include- Overview of SSAS Tabular models
Import data by using a native query
DirectQuery Mode
Data sources supported in tabular 1200 models
Understanding DAX in Tabular Models Measures
Create and Manage KPIs Hierarchies
Rename a Table or Column
Add a table Delete a Table
Version comparison
Create a Calculated Column
Enable DirectQuery mode in SSMS
Delete a Column
Create and Manage Perspectives Translations Roles
Enable DirectQuery mode in SSDT
Create a Calculated Table
Create and Manage Measures KPIs
Data sources supported in tabular 1400 models
Email us about this courses
Other Barry Enable Technology Training Courses
Report Builder - Barry SQL Server Reporting Services Training Courses
Access - Barry Access Training Courses
Data Warehouse - Barry SQL Training Courses
SQL - Barry SQL Training Courses
JavaScript - Barry JavaScript Training Courses
Excel 365 Basic Barry Training Courses