SQL SERVER ANALYSIS SERVICES TRAINING COURSES CHESHIRE
About Enable Technology Cheshire SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Cheshire. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Wolverhampton City Council, Norwich Union PLC, Canadian High Commission, TalkTalk Direct Limited, Unipart Group, Barclays Bank PLC, Birmingham Heartlands Hospital and Carillion PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Cheshire
- 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 ... Data types supported
- See Training Course Details...
DAX formula compatibility in DirectQuery mode Tables and Columns
Enable DirectQuery mode in SSDT
Understanding DAX in Tabular Models Measures
DirectQuery Mode
Connect to a tabular model database
Analyze a tabular model in Excel Deploy tabular model solutions
Hide or freeze columns
Data sources supported in tabular 1400 models
Delete Relationships
Data sources supported in tabular 1200 models
Enable DirectQuery mode in SSMS
Change table, column
Create and Manage Measures KPIs
Manage Roles by using SSMS
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Sort Data in a Table
Rename a Table or Column
Specify Mark as Date Table for use with Time Intelligence
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Cheshire
- 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 Assignments and Other Script Commands
- See Training Course Details...
Define Semiadditive Behavior
KPIs Actions
Define Logical Primary Keys in a Data Source View
Create Measures and Measure Groups
Create Local Partitions
Define a Fact Relationship and Fact Relationship Properties
Batch Processing Remote Processing
Move an Analysis Services Database
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Add a Standard Action
Data Source Views
Deploy Model Solutions Using XMLA
Attach and Detach Analysis Services Databases
Configure Analysis Services Project Properties
Partition Writeback Calculations
Set Partition Storage
Set Impersonation Options for a Data Source Connection
Overview of SSAS Multidimensional Modelling
Define Named Queries in a Data Source View
Calculations using the Business Intelligence Wizard
Email us about this courses
Other Cheshire Enable Technology Training Courses
VBA Cheshire Training Courses
Report Builder - Cheshire SQL Server Reporting Services Training Courses
Excel 365 Advanced Cheshire Training Courses
SSIS - Cheshire SQL Server Integration Services Training Courses
Access Cheshire Training Courses
SQL Cheshire Training Courses