Enable Technology



About Enable Technology Smethwick SQL Server Analysis Services Training Courses

Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.

We provide instructor led training coupled with hands on training. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Another way we could deliver the SQL Server Analysis Services course is at a local socially distanced training site. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.

SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Halfords Group PLC, TalkTalk Direct Limited, Total Telecommunications Limited, Royal & Sun Alliance Group PLC, Dollond & Aitchison Limited, Yell Group PLC, Birmingham Heartlands Hospital and University of Birmingham.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Smethwick
  • 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 ...
  • Restore from Power Pivot
    Import data by using a native query
    Import from Power View
    Database Process Partitions in the Workspace Database Perspectives
    Create and Manage Tabular Model Partitions
    Specify Mark as Date Table for use with Time Intelligence
    Rename a Table or Column
    Create and Manage Measures KPIs
    Import Data
    Enable DirectQuery mode in SSMS
    Create a Calculated Table
    Create a New Tabular Model Project
    Change table, column
    Define partitions in DirectQuery models
    Version comparison
    Create a Calculated Column
    Add columns to a table
    Manage Roles by using SSMS
    Understanding DAX in Tabular Models Measures
    Set the Data Type of a Column
    Delete Relationships

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Smethwick
  • 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 ...
  • Tools and Approaches for Processing
    Set Impersonation Options for a Data Source Connection
    KPIs Actions
    Authorizing access to objects and operations
    Create Named Sets
    Create a Time Dimension by Generating a Time Table
    Dimension permissions
    Use Aggregate Functions
    Deploy Model Solutions with the Deployment Utility
    Deploy Model Solutions Using XMLA
    View the XML for an Analysis Services Project Data Sources
    Create a Dimension by Using an Existing Table
    Multidimensional models
    Database permissions
    Set Data Source Properties
    Define Semiadditive Behavior
    Replace a Table or a Named Query in a Data Source View
    Calculations using the Business Intelligence Wizard
    Edit or Delete Partitions Merge Partitions
    Deployment Requirements and Considerations for Analysis Services Deployment
    Modify or Delete in Solution Explorer Database Dimensions

  • See Training Course Details...

Email us about this courses

Other Smethwick Enable Technology Training Courses

Power Query - Smethwick Excel Training Courses
JavaScript - Smethwick JavaScript Training Courses
Excel 365 Advanced - Smethwick Excel Training Courses
JQuery - Smethwick JavaScript Training Courses
VBA - Smethwick Excel Training Courses
TSQL Smethwick Training Courses