SQL SERVER ANALYSIS SERVICES TRAINING COURSES SKELMERSDALE
About Enable Technology Skelmersdale SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Another way we could deliver the SQL Server Analysis Services course is at a local training site. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Homeserve PLC, Nuclear Engineering Services, Wolverhampton City Council, Aston University, Capita Group PLC, National Power PLC, University of Birmingham and Royal Air Force.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Skelmersdale
- 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 and Manage Hierarchies Partitions
- See Training Course Details...
Manage Roles by using SSMS
Hide or freeze columns
Create and Manage KPIs Hierarchies
Create a Relationship Between Two Tables
Bi-directional cross filters Calculations
Import from Analysis Services
Import from Power Pivot
Data sources supported in tabular 1400 models
Row filter mappings
Data types supported
Filter Data in a Table Relationships
Analyze in Excel
Test a model in DirectQuery mode
Rename a Table or Column
Create and Manage Partitions in the Workspace
Analyze a tabular model in Excel Deploy tabular model solutions
Process Database, Table, or Partition
Create a New Tabular Model Project
Connect to a tabular model database
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Skelmersdale
- 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 Attribute Relationships
- See Training Course Details...
Deploy Model Solutions Using XMLA
Modify or Delete in Solution Explorer Database Dimensions
Processing Options and Settings
Modify or Delete an Analysis Services Database
Deploy Model Solutions with the Deployment Utility
Backup Options Restore Options
Create Local Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Define a Data Source View
Data Source object permissions
Supported Data Sources
Designing Aggregations
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Cube or model permissions Process permissions
Edit or Delete Partitions Merge Partitions
Defined Linked Measure Groups Partitions
Use Aggregate Functions
Calculations using the Business Intelligence Wizard
Configure Measure Group Properties
Create Calculated Members
Email us about this courses
Other Skelmersdale Enable Technology Training Courses
PL/SQL Skelmersdale Training Courses
DAX - Skelmersdale Excel Training Courses
Data Warehouse - Skelmersdale SQL Training Courses
JQuery Mobile Skelmersdale Training Courses
SQL - Skelmersdale SQL Training Courses
Power Query - Skelmersdale Excel Training Courses