Warnung Icon Sie haben in Ihrem Browser Javascript deaktiviert! Bitte aktivieren Sie Javascript um eine korrekte Darstellung und Funktionsweise von IT-Schulungen zu gewährleisten. Warnung Icon
Header Background
Header Image
 
 
 
 

MOC 50578 MDX with Microsoft Analysis Services: How to ask questions and get accurate answers from your Data

Seminardauer: 3 Tage
zur unverbindlichen Anfrage

Ziele

This instructor led course is designed to take a person from the very beginning, think “Hello World” in programing to journeyman. The first chapters (1-4) get you well-grounded then from there we expand out. You won’t know how to do every MDX query. You won’t look at every function. But you will understand the patterns and from them you can examine examples and build on them to code your own sophisticated queries.

Zielgruppe

  • SQL Professionals
  • Microsoft Analysis Service
  • Cube and Report Developers
  • Business Intelligence Professionals

Voraussetzungen

If the past is any indicator of the future then this course will be attended manly by SQL Professionals, Microsoft Analysis Service cube and report developers and Business Intelligence Professionals coming from competing platforms.

Agenda

The Microsoft Business Intelligence Stack

  • What Business Intelligence can do for your organization
  • What to watch out for in implementation
  • The Scope and what types of tools address each?

Getting Started with MDX

  • MultiDimensional VS Tabular Space
  • Data Warehouse Data Mart
  • MDX Introduction
  • The Editors

The all-important Dimensions

  • Dimensions
  • Dimension Attributes
  • Hierarchies
  • Referencing Members
  • Tuples
  • Cells
  • Sets
  • Set Functions

Navigation and the secrets of relatives!

  • Navigation in reporting
  • Relatives
  • Navigational Functions
  • Controlling Sorting
  • Filtering the results
  • How to combine a set

MDX Calculations

  • Expressions
  • Calculated members
  • Formatting output through the With clause
  • Dynamic Expressions
  • IIF function
  • Statistical Functions
  • Determineing which tuples satisfy a parameter in a report

Working with Time. Multiple calendars, divergent horizons, time is of the essence.

  • Time Dimension
  • Multiple calendars
  • Time based Functions
  • ParallelPeriod
  • OpeningPeriod
  • ClosingPeriod
  • LastPeriod
  • Year-To-Date
  • Calculated Measures and a time Dimension
  • Comparing Periods
  • Sum Function
  • Aggregate Function
  • Max and Min Function in Time

Business Insights

  • Or logic
  • And Logic
  • Combining Or and And logic from different hierarchies
  • Logical And with members from the Same
  • Using the NonEmpty function
  • Moving Averages
  • Last date with data
  • ParallelPeriod for Multiple Dates
  • Testing current context
  • Options of the Descendants function
  • Ranking Values

Using MDX in SQL Server Reporting Services Reports

  • Create a SSRS report
  • Create a connection into the cube
  • Create a MDX query with the query designer
  • Create a custom query
  • Pass a parameter
  • PerformancePoint Services Dashboard Designer

KPIs and MDX in the Business Intelligence Development Studio Editor

  • Use Business Intelligence Development Studio to create a named calculation in the cube
  • Use Business Intelligence Development Studio to create KPIs

Schulungsunterlagen

nach Absprache
 
Anmeldungen vorhanden

1.) Wählen Sie den Seminartyp:




2.) Wählen Sie Ort und Datum:

1.395,00€ pro Person

spacing line1.660,05€ inkl. 19% MwSt
Verpflegung zzgl.
Seminarunterlagen zzgl.

Seminar jetzt anfragen Merkzettel Icon Auf den Merkzettel
PDF IconPDF Icon
 

Europaweit unter den Besten
Unser Education Center wird seit 2012 beim jährlichen Leistungsaudit für das ITCR - International Training Center Rating® jeweils in der höchsten Leistungsstufe mit 5 von 5 Sternen ausgezeichnet.
Das bestätigt unseren langjährigen Premium-Status als Bildungsanbieter und beweist gleichzeitig, dass wir zu den besten Schulungshäusern in Europa gehören.

IT-Schulungen.com 5 Sterne

 Microsoft Learning Partner

Linux Foundation Training Partner

LPI Gold Approved Training Partner

 
 

Diese Seite weiterempfehlen:

Merkzettel Icon
0
Merkzettel öffnen
0
Besuchsverlauf ansehen
IT-Schulungen.com Control Panel