SQL SERVER ANALYSIS SERVICES TRAINING COURSES HAVERFORDWEST
About Enable Technology Haverfordwest SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The training will be delivered by a Microsoft professional with development experience. 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 training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local venue in Haverfordwest. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Capita Group PLC, South Staffordshire Water PLC, Homeserve PLC, Lloyds TSB Bank PLC, Birmingham City Council, Norfolk Police Constabulary, Shell UK Oil Products Ltd and Royal Air Force.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Haverfordwest
- 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 ... Document and Script an Analysis Services Database
- See Training Course Details...
Multidimensional models
Change a Partition Source
Error Configuration Roles and Permissions
Define Logical Relationships in a Data Source View
Attach and Detach Analysis Services Databases
Explore Data in a Data Source View
Set Data Source Properties
Batch Processing Remote Processing
Move an Analysis Services Database
Define Logical Primary Keys in a Data Source View
Create a Data Source
Deployment Requirements and Considerations for Analysis Services Deployment
Define Time Intelligence
Use Aggregate Functions
Backup Options Restore Options
Work with Diagrams in Data Source View Designer
Define Semiadditive Behavior
Create a Time Dimension by Generating a Time Table
Define Attribute Relationships
Define a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Haverfordwest
- 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 ... Process Tabular Model Partitions
- See Training Course Details...
Bi-directional cross filters Calculations
Import Data
Specify Mark as Date Table for use with Time Intelligence
Add columns to a table
Impersonation
Create a Relationship Between Two Tables
Restore from Power Pivot
Data types supported
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Partitions in the Workspace
Create and Manage Hierarchies Partitions
Data sources supported in SSAS tabular 2017
Import from Power View
Create and Manage Tabular Model Partitions
Add a table Delete a Table
Change table, column
Data sources supported in tabular 1400 models
Connect to a tabular model database
Row filter mappings
Email us about this courses
Other Haverfordwest Enable Technology Training Courses
VBA Haverfordwest Training Courses
Report Builder - Haverfordwest SQL Server Reporting Services Training Courses
Power Query - Haverfordwest Excel Training Courses
Data Warehouse - Haverfordwest SQL Training Courses
JQuery - Haverfordwest JavaScript Training Courses
DAX - Haverfordwest Excel Training Courses