SQL SERVER ANALYSIS SERVICES TRAINING COURSES DROITWICH
About Enable Technology Droitwich SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials 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.
Enable Technology training courses are delivered as instructor led courses. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. We can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Droitwich. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Norwich Union PLC, TalkTalk Direct Limited, Carillion PLC, Shell UK Oil Products Ltd, Canadian High Commission, EDF Energy PLC, DHL Express and Total Telecommunications Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Droitwich
- 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 ... Use a Template to Create an Action Deployment
- See Training Course Details...
Data Source Views
Data Source object permissions
Create a Dimension by Generating a Non-Time Table in the Data Source
Authorizing access to objects and operations
Create a Dimension by Using an Existing Table
Define Named Queries in a Data Source View
Add or Remove Tables or Views in a Data Source View
Move an Analysis Services Database
Partition Writeback Calculations
Create Measures and Measure Groups
Backup Options Restore Options
Deployment Requirements and Considerations for Analysis Services Deployment
KPIs Actions
BI Wizard
Use Aggregate Functions
Configure Analysis Services Project Properties
Rename a Multidimensional Database Processing a multidimensional model
Overview of SSAS Multidimensional Modelling
Supported Data Sources
Modify or Delete an Analysis Services Database
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Droitwich
- 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 ... Delete a Column
- See Training Course Details...
Understanding DAX in Tabular Models Measures
Create a Relationship Between Two Tables
Set the Data Type of a Column
Specify Mark as Date Table for use with Time Intelligence
Add a table Delete a Table
Create a Calculated Table
Filter Data in a Table Relationships
Bi-directional cross filters Calculations
Topics include- Overview of SSAS Tabular models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Import from Analysis Services
Process Tabular Model Partitions
Data sources supported in SSAS tabular 2016 Create Tabular Models
Import from Power View
Hide or freeze columns
Data sources supported in tabular 1400 models
Test a model in DirectQuery mode
Version comparison
Import Data
Email us about this courses
Other Droitwich Enable Technology Training Courses
Excel 365 Advanced - Droitwich Excel Training Courses
Excel 365 Basic - Droitwich Excel Training Courses
DAX - Droitwich Excel Training Courses
JQuery Mobile - Droitwich JavaScript Training Courses
PL/SQL Droitwich Training Courses
SSIS Droitwich Training Courses