SQL SERVER ANALYSIS SERVICES TRAINING COURSES WEST BROMWICH
About Enable Technology West Bromwich SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. We can also deliver the SQL Server Analysis Services course at a local training venue in West Bromwich. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training 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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Birmingham Heartlands Hospital, Dollond & Aitchison Limited, Vodafone Group Services, University of Birmingham, Royal Air Force, GKN PLC, Cadbury PLC and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: West Bromwich
- 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 ... BI Wizard
- See Training Course Details...
Defined Linked Measure Groups Partitions
Backup and Restore of Analysis Services Databases
Define Named Calculations in a Data Source View
Deploy Analysis Services Projects
Dimension permissions
Delete a Data Source
Delete a Data Source View Dimensions
Use Aggregate Functions
Create Local Partitions
Create Measures and Measure Groups
Add a Standard Action
Data Source Views
Use a Template to Create an Action Deployment
View the XML for an Analysis Services Project Data Sources
Deploy Model Solutions with the Deployment Utility
Explore Data in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Define a Data Source View
Add or Remove Tables or Views in a Data Source View
Set Data Source Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: West Bromwich
- 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 ... Add sample data to DirectQuery models
- See Training Course Details...
Tabular model designer
Create and Manage KPIs Hierarchies
Import Data
Specify Mark as Date Table for use with Time Intelligence
DirectQuery Mode
Row filter mappings
Enable DirectQuery mode in SSMS
Process Database, Table, or Partition
Import from Analysis Services
Create and Manage Roles
Import from Power Pivot
Impersonation
Data sources supported in SSAS tabular 2016 Create Tabular Models
Import data by using a native query
Data types supported
Set the Data Type of a Column
Data sources supported in SSAS tabular 2017
Add a table Delete a Table
Create and Manage Measures KPIs
Create and Manage Partitions in the Workspace
Email us about this courses
Other West Bromwich Enable Technology Training Courses
Access - West Bromwich Access Training Courses
PL/SQL West Bromwich Training Courses
Excel 365 Basic - West Bromwich Excel Training Courses
JQuery Mobile West Bromwich Training Courses
VBA - West Bromwich Excel Training Courses
JavaScript West Bromwich Training Courses