SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACKPOOL
About Enable Technology Blackpool SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
We provide instructor led training coupled with hands on training. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another option is we can organise a local training site in Blackpool. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
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 group of companies has been operating continuously providing IT training since 1998. Our clients include: Capita Group PLC, Total Telecommunications Limited, Dollond & Aitchison Limited, TalkTalk Direct Limited, Unipart Group, Homeserve PLC, GKN PLC and Canadian High Commission.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Blackpool
- 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 ... Processing Databases, Dimensions and Partitions
- See Training Course Details...
Dimension permissions
Use a Template to Create an Action Deployment
Create a Time Dimension by Generating a Time Table
Delete a Data Source
Define a Referenced Relationship and Referenced Relationship Properties
Calculations using the Business Intelligence Wizard
Configure Measure Group Properties
Define a Data Source View
Define Attribute Relationships
Processing Options and Settings
Using SQL Server Data Tools (SSDT)
Test an Action
Defined Linked Measure Groups Partitions
Multidimensional models
Ragged Hierarchies
Create an Analysis Services Project
BI Wizard
Add a Standard Action
KPIs Actions
Tools and Approaches for Processing
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Blackpool
- 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 ... Row filter mappings
- See Training Course Details...
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Object-level security
Create a Calculated Column
Create and Manage KPIs Hierarchies
DirectQuery Mode
Import from Power View
Create and Manage Measures KPIs
Add columns to a table
Create a New Tabular Model Project
Create and Manage Perspectives Translations Roles
Data sources supported in SSAS tabular 2017
Create and Manage Tabular Model Partitions
Version comparison
Manage Roles by using SSMS
Import Data
Import data by using a native query
Connect to a tabular model database
Process Tabular Model Partitions
DAX formula compatibility in DirectQuery mode Tables and Columns
Email us about this courses
Other Blackpool Enable Technology Training Courses
Power BI Blackpool Training Courses
SSRS Blackpool Training Courses
PL/SQL - Blackpool SQL Training Courses
Data Warehouse - Blackpool SQL Training Courses
JQuery Mobile - Blackpool JavaScript Training Courses
Power Query Blackpool Training Courses