SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACK COUNTRY
About Enable Technology Black Country SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to 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. 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 Black Country. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Dollond & Aitchison Limited, Homeserve PLC, West Bromwich Building Society, Queen's Medical Centre Nottingham, Canadian High Commission, Fujistu PLC, Keele University and Total Telecommunications Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Black Country
- 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 ... Test a model in DirectQuery mode
- See Training Course Details...
Database Process Partitions in the Workspace Database Perspectives
Data sources supported in tabular 1200 models
Hide or freeze columns
DAX formula compatibility in DirectQuery mode Tables and Columns
Add columns to a table
Import from Power Pivot
Delete Relationships
Add a table Delete a Table
Process Database, Table, or Partition
Manage Roles by using SSMS
Sort Data in a Table
Impersonation
Process Tabular Model Partitions
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Connect to a tabular model database
Import data by using a native query
Create a New Tabular Model Project
Tabular model designer
Data sources supported in SSAS tabular 2017
Create and Manage Perspectives Translations Roles
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Black Country
- 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 ... Modify or Delete an Analysis Services Database
- See Training Course Details...
Create a Data Source
Partition Writeback Calculations
Deploy Model Solutions with the Deployment Utility
Define a Fact Relationship and Fact Relationship Properties
Rename a Multidimensional Database Processing a multidimensional model
Define Logical Primary Keys in a Data Source View
Tools and Approaches for Processing
Create a Time Dimension by Generating a Time Table
Database permissions
Work with Diagrams in Data Source View Designer
Use Aggregate Functions
Create a Dimension Using the Dimension Wizard
Attach and Detach Analysis Services Databases
Define a Regular Relationship and Regular Relationship Properties
Create a Dimension by Using an Existing Table
Create Calculated Members
Set Data Source Properties
Create Named Sets
Explore Data in a Data Source View
Add a Standard Action
Email us about this courses
Other Black Country Enable Technology Training Courses
DAX Black Country Training Courses
JQuery - Black Country JavaScript Training Courses
Excel 365 Basic Black Country Training Courses
VBA Black Country Training Courses
Access VBA - Black Country Access Training Courses
Oracle SQL - Black Country SQL Training Courses