Enable Technology

SQL SERVER ANALYSIS SERVICES LICHFIELD TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES LICHFIELD




About Enable Technology Lichfield SQL Server Analysis Services Training Courses

Enable Technology provides practical SQL Server Analysis Services skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Lichfield. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Total Telecommunications Limited, Norfolk Police Constabulary, Dollond & Aitchison Limited, Carillion PLC, Cadbury PLC, Aston University, Birmingham City University and Nationwide Building Society Limited.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Lichfield
  • 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
    Define a Regular Relationship and Regular Relationship Properties
    Overview of SSAS Multidimensional Modelling
    Define Attribute Relationships
    Database permissions
    Attach and Detach Analysis Services Databases
    Define Logical Relationships in a Data Source View
    BI Wizard
    Data Source Views
    Modify or Delete an Analysis Services Database
    Defined Linked Measure Groups Partitions
    Configure Measure Group Properties
    Processing Options and Settings
    Set Impersonation Options for a Data Source Connection
    Work with Diagrams in Data Source View Designer
    Set Partition Storage
    Define a Referenced Relationship and Referenced Relationship Properties
    Move an Analysis Services Database
    Delete a Data Source View Dimensions
    Data Source object permissions
    Dimension permissions

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Lichfield
  • 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 ...
  • Import from Power View
    Create and Manage Measures KPIs
    Create and Manage Partitions in the Workspace
    Add a table Delete a Table
    Data types supported
    Create and Manage Tabular Model Partitions
    Data sources supported in tabular 1200 models
    Create a Relationship Between Two Tables
    Enable DirectQuery mode in SSMS
    Rename a Table or Column
    Analyze in Excel
    Create and Manage Hierarchies Partitions
    Restore from Power Pivot
    Hide or freeze columns
    Import Data
    Database Process Partitions in the Workspace Database Perspectives
    Change table, column
    Create a Calculated Table
    Version comparison

  • See Training Course Details...



Email us about this courses



Other Lichfield Enable Technology Training Courses

Oracle SQL Lichfield Training Courses
JQuery Mobile Lichfield Training Courses
TSQL Lichfield Training Courses
Access - Lichfield Access Training Courses
Excel 365 Intermediate Lichfield Training Courses
Excel 365 Advanced Lichfield Training Courses