SQL SERVER ANALYSIS SERVICES TRAINING COURSES CIRENCESTER
About Enable Technology Cirencester 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. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. 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.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Cirencester. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Unipart Group, Yell Group PLC, Birmingham City University, Royal Air Force, TalkTalk Direct Limited, South Staffordshire Water PLC, Lloyds TSB Bank PLC and Keele University.
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 ... Define Time Intelligence
- See Training Course Details...
Define a Referenced Relationship and Referenced Relationship Properties
Processing Databases, Dimensions and Partitions
Ragged Hierarchies
Change a Partition Source
Authorizing access to objects and operations
Replace a Table or a Named Query in a Data Source View
Deploy Model Solutions Using the Deployment Wizard
Define a Data Source View
Create a Dimension by Using an Existing Table
Create a Dimension Using the Dimension Wizard
Add or Remove Tables or Views in a Data Source View
Modify or Delete in Solution Explorer Database Dimensions
Define Assignments and Other Script Commands
Document and Script an Analysis Services Database
Multidimensional models
Create a Time Dimension by Generating a Time Table
Create Remote Partitions
Backup Options Restore Options
Work with Diagrams in Data Source View Designer
Modify or Delete an Analysis Services Database
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 ... Create a Calculated Column
- See Training Course Details...
Process Database, Table, or Partition
Create and Manage Roles
Enable DirectQuery mode in SSMS
Change table, column
Create a Calculated Table
Enable DirectQuery mode in SSDT
Create and Manage Partitions in the Workspace
Object-level security
Import Data
Create and Manage Measures KPIs
Connect to a tabular model database
Import from Analysis Services
Version comparison
Specify Mark as Date Table for use with Time Intelligence
Set the Data Type of a Column
DirectQuery Mode
Import data by using a native query
Analyze a tabular model in Excel Deploy tabular model solutions
Email us about this courses
Other Cirencester Enable Technology Training Courses
SSIS Cirencester Training Courses
Oracle SQL Cirencester Training Courses
JavaScript Cirencester Training Courses
JQuery Mobile Cirencester Training Courses
JQuery - Cirencester JavaScript Training Courses
Excel 365 Intermediate Cirencester Training Courses