SQL SERVER ANALYSIS SERVICES TRAINING COURSES HALIFAX
About Enable Technology Halifax SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Another way we could deliver the SQL Server Analysis Services course is at a local socially distanced training site. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your 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
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Yell Group PLC, Vodafone Group Services, DHL Express, Lloyds TSB Bank PLC, Canadian High Commission, Countrywide Homes Limited, Royal Air Force and Wolverhampton City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Halifax
- 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 ... Set the Data Type of a Column
- See Training Course Details...
Impersonation
Data types supported
Add columns to a table
DAX formula compatibility in DirectQuery mode Tables and Columns
Object-level security
Data sources supported in SSAS tabular 2016 Create Tabular Models
Understanding DAX in Tabular Models Measures
Rename a Table or Column
Hide or freeze columns
Topics include- Overview of SSAS Tabular models
Create and Manage Tabular Model Partitions
Import from Power View
Create a Relationship Between Two Tables
Analyze a tabular model in Excel Deploy tabular model solutions
Connect to a tabular model database
Delete Relationships
Row filter mappings
Create and Manage Perspectives Translations Roles
Process Tabular Model Partitions
Import from Analysis Services
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Halifax
- 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 ... Deploy Model Solutions Using the Deployment Wizard
- See Training Course Details...
Processing Databases, Dimensions and Partitions
Calculations using the Business Intelligence Wizard
Modify or Delete an Analysis Services Database
KPIs Actions
Deployment Requirements and Considerations for Analysis Services Deployment
Set Data Source Properties
Processing Options and Settings
BI Wizard
Using SQL Server Data Tools (SSDT)
Deploy Model Solutions with the Deployment Utility
Partition Writeback Calculations
Defined Linked Measure Groups Partitions
Create a Dimension Using the Dimension Wizard
Configure Measure Group Properties
Create a Dimension by Generating a Non-Time Table in the Data Source
Set Impersonation Options for a Data Source Connection
Ragged Hierarchies
View the XML for an Analysis Services Project Data Sources
Multidimensional models
Define a Data Source View
Email us about this courses
Other Halifax Enable Technology Training Courses
Excel 365 Intermediate Halifax Training Courses
PL/SQL - Halifax SQL Training Courses
DAX - Halifax Excel Training Courses
JavaScript - Halifax JavaScript Training Courses
Power BI - Halifax Microsoft Power BI Training Courses
Access Halifax Training Courses