SQL SERVER ANALYSIS SERVICES TRAINING COURSES WELLS
About Enable Technology Wells 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 Solutions Experts with development backgrounds. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post 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. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Wells. 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 SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Birmingham City Council, DHL Express, GKN PLC, Dollond & Aitchison Limited, TalkTalk Direct Limited, Keele University, Barclays Bank PLC and University of Birmingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Wells
- 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 ... Data Source Views
- See Training Course Details...
Dimension permissions
Delete a Data Source
Create Local Partitions
Set Partition Storage
Define Time Intelligence
Define a Regular Relationship and Regular Relationship Properties
Move an Analysis Services Database
Configure Analysis Services Project Properties
Deploy Model Solutions with the Deployment Utility
Defined Linked Measure Groups Partitions
Define Named Calculations in a Data Source View
Multidimensional models
Modify or Delete in Solution Explorer Database Dimensions
Work with Diagrams in Data Source View Designer
Replace a Table or a Named Query in a Data Source View
View the XML for an Analysis Services Project Data Sources
Define Logical Primary Keys in a Data Source View
KPIs Actions
Ragged Hierarchies
Supported Data Sources
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Wells
- 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 ... Create a Calculated Column
- See Training Course Details...
Filter Data in a Table Relationships
Import Data
Enable DirectQuery mode in SSMS
Create a Relationship Between Two Tables
Delete a Column
Create a Calculated Table
Import from Power Pivot
Rename a Table or Column
Import from Analysis Services
Create and Manage Perspectives Translations Roles
Process Database, Table, or Partition
Analyze in Excel
Sort Data in a Table
Topics include- Overview of SSAS Tabular models
Restore from Power Pivot
Analyze a tabular model in Excel Deploy tabular model solutions
Connect to a tabular model database
Understanding DAX in Tabular Models Measures
Data sources supported in tabular 1400 models
Data sources supported in SSAS tabular 2017
Email us about this courses
Other Wells Enable Technology Training Courses
Excel 365 Advanced Wells Training Courses
Excel 365 Basic - Wells Excel Training Courses
SQL - Wells SQL Training Courses
Excel 365 Intermediate - Wells Excel Training Courses
JQuery Mobile Wells Training Courses
Power Query Wells Training Courses