Seminarsuche
Suche
Startseite
IT Seminare & Training Business Intelligence Microsoft Data Warehousing MOC 50578 MDX with Microsoft Analysis Services: How to ask questions and get accurate answers from your DataMOC 50578 MDX with Microsoft Analysis Services: How to ask questions and get accurate answers from your Data- Seminare
Seminarinformationen
Seminar-Ziel
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.
Teilnehmer Zielgruppe
Kurs 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.
Seminardauer
- 3 Tage
- 09:00 Uhr bis 17:00 Uhr
Schulungsunterlagen
- nach Absprache
Seminar-Inhalt / 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
Weitere Schulungen zu Thema Microsoft Data Warehousing
Unternehmenssteuerung mit Microsoft Office PerformancePoint Server 2007 - Monitoring und Analyse
MOC 6234 Implementing and Maintaining Microsoft SQL Server 2008 - Analysis Services
MOC 2792 Implementierung und Pflege von Microsoft SQL Server 2005 Integration Services
Excel-Pivot 2007 mit Analysis Services 2005/2008 als Analysewerkzeug
- keine Seminare auf Ihrem Merkzettel
IT-Schulungen.com erhält beim
Internationalen Training Center Rating
(ITCR) die höchste Bewertung und wird
mit Premium Services ausgezeichnet.
