SQL SERVER ANALYSIS SERVICES TRAINING COURSES NATIONAL
About Enable Technology National SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a venue near you in National. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Loughborough University, Capita Group PLC, Wolverhampton City Council, Birmingham Heartlands Hospital, Birmingham City Council, Shell UK Oil Products Ltd, Homeserve PLC and TalkTalk Direct Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: National
- 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 ... Import Data
- See Training Course Details...
Create and Manage Measures KPIs
Create and Manage KPIs Hierarchies
Create a Relationship Between Two Tables
Create a New Tabular Model Project
Set the Data Type of a Column
Add sample data to DirectQuery models
Data sources supported in SSAS tabular 2016 Create Tabular Models
Delete Relationships
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Hierarchies Partitions
Define partitions in DirectQuery models
Analyze a tabular model in Excel Deploy tabular model solutions
Data types supported
Version comparison
Sort Data in a Table
Process Tabular Model Partitions
Hide or freeze columns
Import from Power Pivot
Bi-directional cross filters Calculations
Create a Calculated Table
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: National
- 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 ... Create Named Sets
- See Training Course Details...
Set Partition Storage
Configure Measure Group Properties
Define Assignments and Other Script Commands
Define Named Calculations in a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
Define Semiadditive Behavior
Define Attribute Relationships
Deployment Requirements and Considerations for Analysis Services Deployment
Delete a Data Source
Delete a Data Source View Dimensions
Data Source Views
Data Source object permissions
Define Logical Relationships in a Data Source View
Create Measures and Measure Groups
Dimension permissions
Define Logical Primary Keys in a Data Source View
Processing Options and Settings
Deploy Model Solutions with the Deployment Utility
Explore Data in a Data Source View
Create a Dimension Using the Dimension Wizard
Email us about this courses
Other National Enable Technology Training Courses
SQL - National SQL Training Courses
VBA - National Excel Training Courses
Excel 365 Intermediate - National Excel Training Courses
Access VBA National Training Courses
JQuery Mobile National Training Courses
PL/SQL - National SQL Training Courses