SQL SERVER ANALYSIS SERVICES TRAINING COURSES OSWESTRY
About Enable Technology Oswestry 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. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Oswestry. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Fujistu PLC, Canadian High Commission, Dollond & Aitchison Limited, Keele University, Nationwide Building Society Limited, Birmingham Heartlands Hospital, DHL Express and Capita Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Oswestry
- 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 ... Supported Data Sources
- See Training Course Details...
Create Calculated Members
Define a Referenced Relationship and Referenced Relationship Properties
Deploy Model Solutions Using the Deployment Wizard
Deployment Requirements and Considerations for Analysis Services Deployment
Replace a Table or a Named Query in a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
Define Logical Primary Keys in a Data Source View
Test an Action
Explore Data in a Data Source View
Define Assignments and Other Script Commands
Define Named Calculations in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Partition Writeback Calculations
Create a Dimension by Generating a Non-Time Table in the Data Source
Configure Measure Group Properties
Create an Analysis Services Project
Move an Analysis Services Database
Cube or model permissions Process permissions
Change a Partition Source
Database permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Oswestry
- 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...
Tabular model designer
Process Database, Table, or Partition
Create and Manage Measures KPIs
Data sources supported in tabular 1400 models
Create and Manage Perspectives Translations Roles
Topics include- Overview of SSAS Tabular models
Impersonation
Specify Mark as Date Table for use with Time Intelligence
Add sample data to DirectQuery models
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create a New Tabular Model Project
Filter Data in a Table Relationships
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Roles
Import from Analysis Services
Delete a Column
Data types supported
Data sources supported in tabular 1200 models
Email us about this courses
Other Oswestry Enable Technology Training Courses
DAX Oswestry Training Courses
JQuery - Oswestry JavaScript Training Courses
Excel 365 Basic Oswestry Training Courses
PL/SQL - Oswestry SQL Training Courses
Power Query Oswestry Training Courses
Excel Power Pivot - Oswestry Excel Training Courses