SQL SERVER ANALYSIS SERVICES TRAINING COURSES CIRENCESTER
About Enable Technology Cirencester SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. We can also deliver the SQL Server Analysis Services course at a local training venue in Cirencester. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are South Staffordshire Water PLC, Nationwide Building Society Limited, University of Birmingham, Cadbury PLC, Homeserve PLC, Canadian High Commission, Shell UK Oil Products Ltd and Loughborough University.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Cirencester
- 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 ... Row filter mappings
- See Training Course Details...
Analyze a tabular model in Excel Deploy tabular model solutions
Topics include- Overview of SSAS Tabular models
Add a table Delete a Table
Manage Roles by using SSMS
DirectQuery Mode
Create and Manage Partitions in the Workspace
Import from Power View
Delete Relationships
Process Database, Table, or Partition
Define partitions in DirectQuery models
Add sample data to DirectQuery models
Rename a Table or Column
Data sources supported in tabular 1200 models
Enable DirectQuery mode in SSMS
Data sources supported in tabular 1400 models
Data types supported
Delete a Column
Change table, column
Create and Manage Tabular Model Partitions
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Cirencester
- 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 ... Create a Dimension Using the Dimension Wizard
- See Training Course Details...
Create a Dimension by Generating a Non-Time Table in the Data Source
Create Calculated Members
Set Partition Storage
Batch Processing Remote Processing
Cube or model permissions Process permissions
Multidimensional models
Create a Dimension by Using an Existing Table
Partition Writeback Calculations
Ragged Hierarchies
Create Measures and Measure Groups
Define Named Calculations in a Data Source View
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define Semiadditive Behavior
Dimension permissions
Using SQL Server Data Tools (SSDT)
Define Logical Primary Keys in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Add or Remove Tables or Views in a Data Source View
Define a Fact Relationship and Fact Relationship Properties
Document and Script an Analysis Services Database
Email us about this courses
Other Cirencester Enable Technology Training Courses
SSRS - Cirencester SQL Server Reporting Services Training Courses
Excel 365 Intermediate Cirencester Training Courses
Report Builder Cirencester Training Courses
Oracle SQL - Cirencester SQL Training Courses
JQuery Mobile Cirencester Training Courses
Power BI Cirencester Training Courses