Digi Academy

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

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

What you will get out of this module: * An overview of the Microsoft Business Intelligence Stack * An understanding of the available technologies What Business Intelligence can do for your organization

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Cosa impari in questo corso?

Server
Reporting
Business intelligence
SQL
e-Business

Programma

What to watch out for in implementation


The Scope and what types of tools address each?


Examine and run a prebuilt SQL Integration Services Package that performs an Extract Transform and Load into a Data mart.


This is the Hello World experience in MDX. This is where you will learn why you can get an answer without really asking a question. And this is where you say goodbye to SQL habits.



What you will get out of this module:


* The difference between multidimensional and flat or tabular space


* The importance of schemas in SQL Server Analysis Services


* Basic syntax of MDX


MultiDimensional VS Tabular Space


Data Warehouse Data Mart


MDX Introduction


The Editors


Familiarization with the SQL Server Management Studio Query Editor


Familiarization with the Business Intelligence Development Studio Query Editor


SQL Profiler


Basic MDX


What you will get out of this module:


* Working knowledge of Dimensions


* The ability to explain what a tuple does


* Why SSAS cells are important and their properties


* How to construct a MDX Set


* Utilize built in Set Functions


Dimensions


Dimension Attributes


Hierarchies


Referencing Members


Tuples


Cells


Sets


Set Functions


Dimension Properties


Dimension Attributes


Single Dimension Hierarchies


Multidimensional Hierarchies


The All Member


The Members function


Referencing Members


Syntax errors


Partial Tuple references


Multiple Axis


Crossjoin


Auto-Exists


Exists


Removing Duplicate Tuples


What you will get out of this module:


* Importance of Navigation to reporting


* How to locate a cells relatives


* How to use Navigational Functions in reporting


* Controlling Sorting of reports


* Filtering the results of a report


* How to combine a sets


Navigation in reporting


Relatives


Navigational Functions


Controlling Sorting


Filtering the results


How to combine a set


Navigating a Hierarchy


Locating Immediate relatives


Using the members function effectively


Hierarchize Function


What you will get out of this module:


* How to utilize expressions


* How to use MDX functions in Calculations


* Variances through the With clause


* How to use sets in expressions


* How to work with statistical functions


Expressions


Calculated members


Formatting output through the With clause


Dynamic Expressions


IIF function


Statistical Functions


Determining which tuples satisfy a parameter in a report


Explore variations of the With Clause


Create Members


Calculate Percentages


Advanced Formatting


What you will get out of this module:


* Understanding of time in SSAS


* How to perform time based calculations


* Navigating Time Dimensions


* How to use a calculated measure in a time Dimension


* How to Sum and Aggregate data over time


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


ParallelPeriod


OpeningPeriod


ClosingPeriod


LastPeriod


Year-To-Date


Calculated Measures and a time Dimension


Comparing Periods


Sum Function


Aggregate Function


Max


Min


Use Crossjoin and ParallelPeriod


What you will get out of this module:


* This module combines techniques from the other modules and expands where necessary.


* You should develop an understanding of how to approach and solve MDX problems.


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


What you will get out of this module:


* How to use MDX in a SQL Server Reporting Services Report


* MDX in PerformancePoint Services 2010


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 (Not installed PowerPoint and Video demonstration)


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


What you will get out of this module:


* How to use MDX in a Business Intelligence Development Studio Editor


* MDX in Calculations in Form view


* How to create KPIs


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


Use Business Intelligence Development Studio to create KPIs


Create a named calculation


Create a Leaf KPI


Create an Objective KPI


Utilize IIF logic in a KPI



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto