Loading Events

« All Events

  • This event has passed.

MDXE MDX Essentials

December 4, 2017 @ 9:00 am - 5:00 pm UTC+11

$675
MDX Essentials

This course is not currently scheduled. Please get in touch to book.
This one-day hands-on, instructor-led course will guide you step-by-step through how to utilise the Multidimensional Expression (MDX) query language for SQL Server Analysis Services. You will learn a practical approach to solve real-world problems using MDX expressions, calculations and queries, which will provide you the ability to extract valuable information.

This course is not currently scheduled. Please get in touch to book.

Overview

This one-day hands-on, instructor-led course will guide you step-by-step through how to utilise the Multidimensional Expression (MDX) query language for SQL Server Analysis Services. You will learn a practical approach to solve real-world problems using MDX expressions, calculations and queries, which will provide you the ability to extract valuable information.

Benefits

At the end of the course you will have skills and experience in developing MDX expressions, formulas, KPIs, calculations and queries and will take home many useful, real-world examples to adapt to your own environments.

Download Course Outline   Contact Us

Who Should Attend

This course is designed for anyone who uses Microsoft Analysis Services and wants to gain a greater understanding of MDX. This includes report writers, business analysts and anyone that designs and builds OLAP solutions.

Course Objectives

After completing this course, participants will be able to:

  • Construct and execute MDX queries
  • Work with tuples, sets, and expressions
  • Develop sets to retrieve the data users need
  • Perform aggregation functions and navigate data hierarchies
  • Customize an Analysis Services cubes using MDX
  • Develop MDX-driven reports in SQL Server Reporting Services

Course Prerequisites

Before attending this course, participants should have:

  • An understanding of basic database design, administration, and implementation concepts

Participants should also have an understanding of basic OLAP database concepts in SQL Server Analysis Services, including:

  • Creating databases, dimensions, and cubes
  • Creating simple calculated members
  • Working with shared and private dimensions
  • Processing a cube

Details

Date:
December 4, 2017
Time:
9:00 am - 5:00 pm
Cost:
$675
Event Categories:
, ,

Organizer

WARDY IT Solutions Training
Phone:
1300 WARDY IT (927 394)
Email:
training@wardyit.com
Website:
https://www.wardyit.com/training/

Tickets

Tickets are not available as this event has passed.