SQL SERVER ANALYSIS SERVICES TRAINING COURSES BARROW-IN-FURNESS
About Enable Technology Barrow-in-furness SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. 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. 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.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Barrow-in-furness. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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 two decades of delivering technical training predominantly in the West Midlands. Our clients include: Royal & Sun Alliance Group PLC, Cadbury PLC, Norfolk Police Constabulary, Countrywide Homes Limited, Queen's Medical Centre Nottingham, Homeserve PLC, Lloyds TSB Bank PLC and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Barrow-in-furness
- 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 ... Sort Data in a Table
- See Training Course Details...
Rename a Table or Column
Create and Manage Perspectives Translations Roles
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Data sources supported in tabular 1400 models
DirectQuery Mode
Import from Power Pivot
Enable DirectQuery mode in SSMS
Import Data
Data sources supported in tabular 1200 models
Create a Calculated Table
Analyze a tabular model in Excel Deploy tabular model solutions
Restore from Power Pivot
Import from Analysis Services
Analyze in Excel
Create and Manage Tabular Model Partitions
Add a table Delete a Table
Bi-directional cross filters Calculations
Enable DirectQuery mode in SSDT
Object-level security
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Barrow-in-furness
- 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 ... Define a Data Source View
- See Training Course Details...
Set Partition Storage
KPIs Actions
Define Logical Primary Keys in a Data Source View
Define Named Queries in a Data Source View
Authorizing access to objects and operations
Add or Remove Tables or Views in a Data Source View
Delete a Data Source
Define a Regular Relationship and Regular Relationship Properties
Define a Referenced Relationship and Referenced Relationship Properties
Delete a Data Source View Dimensions
Create an Analysis Services Project
Move an Analysis Services Database
Data Source object permissions
Overview of SSAS Multidimensional Modelling
Create User-Defined Hierarchies
Deploy Model Solutions Using XMLA
Modify or Delete in Solution Explorer Database Dimensions
Define a Fact Relationship and Fact Relationship Properties
Create a Time Dimension by Generating a Time Table
Work with Diagrams in Data Source View Designer
Email us about this courses
Other Barrow-in-furness Enable Technology Training Courses
Power BI Barrow-in-furness Training Courses
Oracle SQL - Barrow-in-furness SQL Training Courses
Excel Power Pivot - Barrow-in-furness Excel Training Courses
DAX - Barrow-in-furness Excel Training Courses
JavaScript - Barrow-in-furness JavaScript Training Courses
JQuery Barrow-in-furness Training Courses