Enable Technology

SQL SERVER ANALYSIS SERVICES BATH TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES BATH




About Enable Technology Bath SQL Server Analysis Services Training Courses

Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. 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.

Enable Technology offers instructor led training taught by technology specialists. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Bath. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services 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 Keele University, Halfords Group PLC, Shell UK Oil Products Ltd, Boots UK Limited, Canadian High Commission, Countrywide Homes Limited, Dollond & Aitchison Limited and Birmingham City Council.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Bath
  • 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 ...
  • Backup Options Restore Options
    Set Impersonation Options for a Data Source Connection
    Define Named Calculations in a Data Source View
    Overview of SSAS Multidimensional Modelling
    Dimension permissions
    Define Semiadditive Behavior
    Attach and Detach Analysis Services Databases
    Define a Referenced Relationship and Referenced Relationship Properties
    Data Source object permissions
    Create Named Sets
    Create a Dimension Using the Dimension Wizard
    Define a Regular Relationship and Regular Relationship Properties
    Define Time Intelligence
    Configure Analysis Services Project Properties
    Create a Dimension by Using an Existing Table
    Create Measures and Measure Groups
    Rename a Multidimensional Database Processing a multidimensional model
    BI Wizard
    Work with Diagrams in Data Source View Designer
    Error Configuration Roles and Permissions
    Add a Standard Action

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Bath
  • 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 and Manage Roles
    Create and Manage Perspectives Translations Roles
    Analyze in Excel
    Row filter mappings
    Import Data
    Create and Manage Measures KPIs
    Specify Mark as Date Table for use with Time Intelligence
    Topics include- Overview of SSAS Tabular models
    Create a Calculated Column
    Create a Calculated Table
    Import from Power Pivot
    Connect to a tabular model database
    Create a New Tabular Model Project
    Add sample data to DirectQuery models
    DirectQuery Mode
    Object-level security
    Enable DirectQuery mode in SSDT
    Define partitions in DirectQuery models
    Create a Relationship Between Two Tables
    Enable DirectQuery mode in SSMS

  • See Training Course Details...



Email us about this courses



Other Bath Enable Technology Training Courses

PL/SQL - Bath SQL Training Courses
Access Bath Training Courses
JavaScript Bath Training Courses
Power Query Bath Training Courses
TSQL - Bath SQL Training Courses
SSRS Bath Training Courses