SQL SERVER ANALYSIS SERVICES TRAINING COURSES FARNWORTH
About Enable Technology Farnworth SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. 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. Our clients include: Unipart Group, Norwich Union PLC, Capita Group PLC, Carillion PLC, Barclays Bank PLC, Halfords Group PLC, Wolverhampton City Council and Shell UK Oil Products Ltd.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Farnworth
- 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 ... Create an Analysis Services Project
- See Training Course Details...
Define Assignments and Other Script Commands
View the XML for an Analysis Services Project Data Sources
Deploy Model Solutions Using the Deployment Wizard
Dimension permissions
Define Named Calculations in a Data Source View
Define a Referenced Relationship and Referenced Relationship Properties
Create Local Partitions
Define Time Intelligence
KPIs Actions
Cube or model permissions Process permissions
Add or Remove Tables or Views in a Data Source View
Error Configuration Roles and Permissions
Processing Databases, Dimensions and Partitions
Data Source Views
Define a Regular Relationship and Regular Relationship Properties
Create User-Defined Hierarchies
Attach and Detach Analysis Services Databases
Database permissions
Modify or Delete in Solution Explorer Database Dimensions
Overview of SSAS Multidimensional Modelling
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Farnworth
- 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 ... Import data by using a native query
- See Training Course Details...
Process Database, Table, or Partition
DirectQuery Mode
Understanding DAX in Tabular Models Measures
Bi-directional cross filters Calculations
Specify Mark as Date Table for use with Time Intelligence
Analyze a tabular model in Excel Deploy tabular model solutions
Object-level security
Filter Data in a Table Relationships
Import from Power Pivot
Change table, column
Sort Data in a Table
Create a New Tabular Model Project
Version comparison
Database Process Partitions in the Workspace Database Perspectives
Create a Calculated Table
Manage Roles by using SSMS
Create and Manage Partitions in the Workspace
Set the Data Type of a Column
Import from Analysis Services
Email us about this courses
Other Farnworth Enable Technology Training Courses
Oracle SQL - Farnworth SQL Training Courses
Data Warehouse Farnworth Training Courses
JQuery - Farnworth JavaScript Training Courses
SSIS Farnworth Training Courses
JavaScript Farnworth Training Courses
Power BI Farnworth Training Courses