Enable Technology

SQL SERVER ANALYSIS SERVICES BLACK COUNTRY TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACK COUNTRY




About Enable Technology Black Country SQL Server Analysis Services Training Courses

We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). All course participants are issued SQL Server Analysis Services training manuals they can refer to 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. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Black Country. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Vodafone Group Services, Boots UK Limited, Nuclear Engineering Services, National Power PLC, Countrywide Homes Limited, Norfolk Police Constabulary, Keele University and Canadian High Commission.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Black Country
  • 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
    Bi-directional cross filters  Calculations
    Understanding DAX in Tabular Models Measures
    Filter Data in a Table Relationships
    Specify Mark as Date Table for use with Time Intelligence
    Change table, column
    Set the Data Type of a Column
    Rename a Table or Column
    Create and Manage Measures KPIs
    Import from Analysis Services
    Create and Manage Hierarchies Partitions
    Create a Calculated Column
    Delete Relationships
    Test a model in DirectQuery mode
    DirectQuery Mode
    Import from Power Pivot
    Process Database, Table, or Partition
    Analyze a tabular model in Excel Deploy tabular model solutions
    Create a Relationship Between Two Tables

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Black Country
  • 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 ...
  • Overview of SSAS Multidimensional Modelling
    Set Data Source Properties
    Define Attribute Relationships
    Define Named Calculations in a Data Source View
    Modify or Delete in Solution Explorer Database Dimensions
    Configure Analysis Services Project Properties
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Data Source Views
    Add or Remove Tables or Views in a Data Source View
    Set Partition Storage
    Defined Linked Measure Groups Partitions
    Define Logical Primary Keys in a Data Source View
    KPIs Actions
    Use Aggregate Functions
    Define Assignments and Other Script Commands
    Edit or Delete Partitions Merge Partitions
    Work with Diagrams in Data Source View Designer
    Multidimensional models
    Database permissions
    Processing Databases, Dimensions and Partitions
    Backup Options Restore Options

  • See Training Course Details...



Email us about this courses



Other Black Country Enable Technology Training Courses

Report Builder - Black Country SQL Server Reporting Services Training Courses
PL/SQL - Black Country SQL Training Courses
JQuery - Black Country JavaScript Training Courses
Data Warehouse Black Country Training Courses
SSIS Black Country Training Courses
TSQL Black Country Training Courses