SQL SERVER ANALYSIS SERVICES TRAINING COURSES BARROW-IN-FURNESS
About Enable Technology Barrow-in-furness SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain 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.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Barrow-in-furness. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Aston University, Capita Group PLC, Norwich Union PLC, Boots UK Limited, Loughborough University, Nuclear Engineering Services, Royal Air Force and Halfords Group PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Barrow-in-furness
- 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 ... Database Process Partitions in the Workspace Database Perspectives
- See Training Course Details...
Impersonation
Delete a Column
Create and Manage Measures KPIs
Tabular model designer
Data sources supported in tabular 1200 models
Set the Data Type of a Column
Connect to a tabular model database
Add a table Delete a Table
Create and Manage Hierarchies Partitions
Import data by using a native query
Import Data
Change table, column
Topics include- Overview of SSAS Tabular models
Import from Power View
Sort Data in a Table
Create and Manage KPIs Hierarchies
Import from Analysis Services
Test a model in DirectQuery mode
Restore from Power Pivot
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Barrow-in-furness
- 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 ... Data Source object permissions
- See Training Course Details...
Test an Action
Define Semiadditive Behavior
Define Named Queries in a Data Source View
Create Measures and Measure Groups
Add or Remove Tables or Views in a Data Source View
Configure Measure Group Properties
Tools and Approaches for Processing
Create Calculated Members
Create Remote Partitions
Use Aggregate Functions
Define Time Intelligence
View the XML for an Analysis Services Project Data Sources
Rename a Multidimensional Database Processing a multidimensional model
Read Definition permissions
Create a Dimension by Using an Existing Table
Processing Options and Settings
Document and Script an Analysis Services Database
KPIs Actions
Partition Writeback Calculations
Cube or model permissions Process permissions
Email us about this courses
Other Barrow-in-furness Enable Technology Training Courses
Excel Power Pivot - Barrow-in-furness Excel Training Courses
Excel 365 Intermediate - Barrow-in-furness Excel Training Courses
Access - Barrow-in-furness Access Training Courses
PL/SQL - Barrow-in-furness SQL Training Courses
SSRS Barrow-in-furness Training Courses
JQuery Barrow-in-furness Training Courses