SQL SERVER ANALYSIS SERVICES TRAINING COURSES KIDDERMINSTER
About Enable Technology Kidderminster SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a course at a local venue in Kidderminster. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training 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 Cadbury PLC, Birmingham City Council, Shell UK Oil Products Ltd, Dollond & Aitchison Limited, Keele University, Nationwide Building Society Limited, Capita Group PLC and National Power PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Kidderminster
- 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 ... Database Process Partitions in the Workspace Database Perspectives
- See Training Course Details...
Process Database, Table, or Partition
Manage Roles by using SSMS
Create a New Tabular Model Project
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Sort Data in a Table
DirectQuery Mode
Hide or freeze columns
Test a model in DirectQuery mode
Create a Relationship Between Two Tables
Create a Calculated Table
Object-level security
Delete a Column
Create and Manage Partitions in the Workspace
Connect to a tabular model database
Delete Relationships
Enable DirectQuery mode in SSDT
Data sources supported in SSAS tabular 2017
Import Data
DAX formula compatibility in DirectQuery mode Tables and Columns
Import from Power Pivot
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Kidderminster
- 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...
Change a Partition Source
Work with Diagrams in Data Source View Designer
Backup Options Restore Options
Define a Data Source View
Deploy Model Solutions Using XMLA
Defined Linked Measure Groups Partitions
Rename a Multidimensional Database Processing a multidimensional model
Edit or Delete Partitions Merge Partitions
Deploy Model Solutions Using the Deployment Wizard
Define Time Intelligence
Define Attribute Relationships
Define Named Calculations in a Data Source View
Define a Fact Relationship and Fact Relationship Properties
Create a Dimension Using the Dimension Wizard
Ragged Hierarchies
Set Impersonation Options for a Data Source Connection
Overview of SSAS Multidimensional Modelling
Explore Data in a Data Source View
Set Partition Storage
Test an Action
Email us about this courses
Other Kidderminster Enable Technology Training Courses
JQuery Mobile - Kidderminster JavaScript Training Courses
VBA Kidderminster Training Courses
SSRS - Kidderminster SQL Server Reporting Services Training Courses
Access - Kidderminster Access Training Courses
Excel 365 Advanced - Kidderminster Excel Training Courses
Power Query Kidderminster Training Courses