SQL SERVER ANALYSIS SERVICES TRAINING COURSES MANCHESTER
About Enable Technology Manchester SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology training courses are delivered as instructor led courses. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local venue in Manchester. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Canadian High Commission, Birmingham City Council, Unipart Group, Royal Air Force, GKN PLC, EDF Energy PLC, DHL Express and Cadbury PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Manchester
- 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 Calculated Members
- See Training Course Details...
KPIs Actions
Define a Regular Relationship and Regular Relationship Properties
Create a Time Dimension by Generating a Time Table
Explore Data in a Data Source View
Define Named Queries in a Data Source View
Set Data Source Properties
Edit or Delete Partitions Merge Partitions
Define Attribute Relationships
Set Partition Storage
Designing Aggregations
Dimension permissions
Define Named Calculations in a Data Source View
Create Named Sets
Deploy Model Solutions with the Deployment Utility
Rename a Multidimensional Database Processing a multidimensional model
Create User-Defined Hierarchies
Cube or model permissions Process permissions
Authorizing access to objects and operations
Data Source object permissions
Tools and Approaches for Processing
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Manchester
- 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...
Import from Analysis Services
Specify Mark as Date Table for use with Time Intelligence
Hide or freeze columns
Bi-directional cross filters Calculations
Define partitions in DirectQuery models
DirectQuery Mode
Change table, column
Topics include- Overview of SSAS Tabular models
Create a New Tabular Model Project
Import Data
Create a Relationship Between Two Tables
Process Tabular Model Partitions
DAX formula compatibility in DirectQuery mode Tables and Columns
Enable DirectQuery mode in SSMS
Data sources supported in SSAS tabular 2017
Delete a Column
Enable DirectQuery mode in SSDT
Import from Power Pivot
Create a Calculated Table
Email us about this courses
Other Manchester Enable Technology Training Courses
VBA Manchester Training Courses
SSIS Manchester Training Courses
DAX - Manchester Excel Training Courses
TSQL Manchester Training Courses
Access - Manchester Access Training Courses
Power Query - Manchester Excel Training Courses