MS SQL Server 2012 - Analysis Services and MDX

• Dauer:
  2 Tage
• Zeit:
  10:00 - 16:00
• Lieferart:
  Online
• Zielgruppe:
  Business Intelligence Developer
• Vorkenntnisse:
  Experience with Business Intelligence concepts
• Methode:
  Lecture with examples and exercises.
• Erfahren Sie in der Demo mehr darüber, wie Online-Kurse durchgeführt werden.
• Kursnummer:
  2022945
• 
  Themen:
  Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas. This training teaches you the Multidimensional Expressions (MDX) query language. With this practical, learn-by-doing course you’ll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to construct and execute MDX queries, work with tuples, sets, and expressions, build complex sets to retrieve the exact data users need, perform aggregation functions and navigate data hierarchies, and assemble time-based business metrics.

MDX Language - MDX-Query-Editor in MS SQL Server Management Studio - Simple MDX Queries

N-dimensional Space - Cube Space - Accessing Data with Tuples - - Understanding Cells - Working with Partial Tuples - Building Tuples with User-Hierarchies - Set Basics - Understanding the SELECT Statement - Building Sets with Functions - Filtering Sets - Combining Sets - Performing Aggregation: Performing Summation, Calculating Averages, Identifying Minimum and Maximum Values, Counting Tuples in Sets - Working with Time: Understanding the Time Dimension, Calculating an Accumulating Total, Performing Period-over-Period Analysis, Combining Time-Based Metrics

Understanding the MDX Script - Constructing Calculated Members - Assembling Named Sets

Understanding Dynamic Security - Implementing Attribute-Hierarchy Restrictions - Implementing Cell-Level Restrictions

Connecting to Analysis Services - Designing the Dataset - Adding Parameters to the Dataset - Presenting the Data in the Report

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.

Veröffentlichungen

• "MS SQL Server - XML und SOAP-Webservices" (Comelio Medien, ISBN 978-3-939701-03-3)
• "MS SQL Server - T-SQL Programmierung und Abfragen" (Comelio Medien, ISBN 978-3-939701-02-6)
• "SQL und relationale Datenbanken" (Comelio Medien, ISBN 978-3-939701-52-1)
• "Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen" (Comelio Medien, ISBN 978-3-939701-23-1)
• "System und Systematik von Fragebögen" (Comelio Medien, ISBN 978-3-939701-26-2)
• "MS SQL Server - XML und SOAP-Webservices" (Comelio Medien, ISBN 978-3-939701-03-3)
• "MS SQL Server - T-SQL Programmierung und Abfragen" (Comelio Medien, ISBN 978-3-939701-02-6)
• "SQL und relationale Datenbanken" (Comelio Medien, ISBN 978-3-939701-52-1)
• "Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen" (Comelio Medien, ISBN 978-3-939701-23-1)
• "System und Systematik von Fragebögen" (Comelio Medien, ISBN 978-3-939701-26-2)

Erfahrung: He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Projekte: He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining.

Forschung: He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Zertifizierung: Marco Skulschus is "Microsoft Certified Trainer" and passed the ComptiaCTT+ examination.

Bei der Anmeldung von mehreren Teilnehmern bieten wir Ihnen attraktive Rabatte an. Ab drei Teilnehmern kann sich ein Inhouse-Seminar bei Ihnen lohnen. Gern erstellen wir Ihnen ein individuelles Angebot.
Alle Preise zuzüglich der gesetzlichen Mehrwertsteuer.