SQL SERVER ANALYSIS SERVICES TRAINING COURSES SOUTHPORT
About Enable Technology Southport SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Professionals. We provide every candidate with SQL Server Analysis Services training materials which they keep 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.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Southport. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Norwich Union PLC, Fujistu PLC, TalkTalk Direct Limited, Royal & Sun Alliance Group PLC, GKN PLC, Dollond & Aitchison Limited, Birmingham Heartlands Hospital and Aston University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Southport
- 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 a Dimension by Using an Existing Table
- See Training Course Details...
Create Named Sets
Deploy Analysis Services Projects
Tools and Approaches for Processing
Deploy Model Solutions Using the Deployment Wizard
Delete a Data Source View Dimensions
Define Logical Relationships in a Data Source View
Processing Options and Settings
Create Calculated Members
Authorizing access to objects and operations
Designing Aggregations
Cube or model permissions Process permissions
Error Configuration Roles and Permissions
Rename a Multidimensional Database Processing a multidimensional model
Calculations using the Business Intelligence Wizard
Modify or Delete in Solution Explorer Database Dimensions
Create User-Defined Hierarchies
Data Source Views
Configure Measure Group Properties
View the XML for an Analysis Services Project Data Sources
Set Data Source Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Southport
- 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 ... Manage Roles by using SSMS
- See Training Course Details...
Specify Mark as Date Table for use with Time Intelligence
Data sources supported in tabular 1400 models
Analyze a tabular model in Excel Deploy tabular model solutions
Connect to a tabular model database
Bi-directional cross filters Calculations
Database Process Partitions in the Workspace Database Perspectives
Understanding DAX in Tabular Models Measures
Tabular model designer
Enable DirectQuery mode in SSDT
Filter Data in a Table Relationships
Hide or freeze columns
Import Data
Version comparison
Import from Analysis Services
Create a Relationship Between Two Tables
Create and Manage Partitions in the Workspace
Analyze in Excel
Create and Manage Hierarchies Partitions
Email us about this courses
Other Southport Enable Technology Training Courses
DAX Southport Training Courses
Data Warehouse - Southport SQL Training Courses
TSQL - Southport SQL Training Courses
Report Builder Southport Training Courses
PL/SQL - Southport SQL Training Courses
Power BI - Southport Microsoft Power BI Training Courses