Enable Technology

SQL SERVER ANALYSIS SERVICES STROUD TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES STROUD




About Enable Technology Stroud SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. 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. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.

Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. 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 Stroud. Every SQL Server Analysis Services course can be modified to meet your bespoke 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.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: DHL Express, TalkTalk Direct Limited, University of Birmingham, Wolverhampton City Council, EDF Energy PLC, Barclays Bank PLC, Cadbury PLC and Yell Group PLC.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Stroud
  • 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 ...
  • Authorizing access to objects and operations
    BI Wizard
    Create Calculated Members
    Delete a Data Source View Dimensions
    Create a Data Source
    Processing Databases, Dimensions and Partitions
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Deployment Requirements and Considerations for Analysis Services Deployment
    Create a Time Dimension by Generating a Time Table
    Define Semiadditive Behavior
    Define Logical Primary Keys in a Data Source View
    Dimension permissions
    Calculations using the Business Intelligence Wizard
    Define a Fact Relationship and Fact Relationship Properties
    Rename a Multidimensional Database Processing a multidimensional model
    Set Impersonation Options for a Data Source Connection
    Tools and Approaches for Processing
    Delete a Data Source
    Define Named Calculations in a Data Source View
    Define Named Queries in a Data Source View
    Define Time Intelligence

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Stroud
  • 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 ...
  • DAX formula compatibility in DirectQuery mode Tables and Columns
    Restore from Power Pivot
    Delete a Column
    Enable DirectQuery mode in SSDT
    Database Process Partitions in the Workspace Database Perspectives
    Create and Manage Tabular Model Partitions
    Import from Power Pivot
    Create a Calculated Column
    Tabular model designer
    Create and Manage Hierarchies Partitions
    Add columns to a table
    DirectQuery Mode
    Manage Roles by using SSMS
    Add a table Delete a Table
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Import data by using a native query
    Filter Data in a Table Relationships
    Process Database, Table, or Partition
    Create and Manage Partitions in the Workspace

  • See Training Course Details...



Email us about this courses



Other Stroud Enable Technology Training Courses

JQuery Mobile - Stroud JavaScript Training Courses
TSQL Stroud Training Courses
Data Warehouse - Stroud SQL Training Courses
Access - Stroud Access Training Courses
JQuery Stroud Training Courses
Excel 365 Advanced Stroud Training Courses