MOC 10778: Implementing Data Models and Reports with Microsoft SQL Server 2012 MOC 10778
Schulungsbeschreibung
Dieser Kurs beschreibt, wie Informationsspezialisten durch Self-Service-Analysen und -Reporting zu mehr Entscheidungsbefugnis verholfen werden kann. Als Teilnehmer lernen Sie, PowerPivot und tabellarische Datenmodelle zu implementieren, Datenvisualisierungen mit Power Views und SQL Server Reporting Services zu erstellen und auszuliefern und mit Data Mining zu einem Geschäftsverständnis zu gelangen.
Dies ist ein Betakurs, der von Microsoft offiziell im Mai 2012 veröffentlicht wird.
Schulungsdaten
Dauer | 5 Tage |
Schulungsort | Berlin, Chemnitz, Dresden, Erfurt, Essen, Halle, Hamburg, Hannover, Leipzig, Neubrandenburg, Potsdam |
Preis | 1850 € zzgl. Mehrwertsteuer |
Examen | Dieser Kurs kann der Vorbereitung auf das Examen 70-466 dienen. |
Sonstiges | Unterlagen, Getränke und Mittagessen im Seminarpreis enthalten |
Termine | 25.06.2012 - 29.06.2012 |
Schulungsinhalt
Introduction to Business Intelligence and Data Modeling
Introduction to Business Intelligence
The Microsoft Business Intelligence Platform
Implementing Reports with Reporting Services
Introduction to Reporting Services
Creating a Report with Report Designer
Grouping and Aggregating Data in a Report
Showing Data Graphically
Filtering Reports Using Parameters
Supporting Self-Service Reporting
Introduction to Report Builder
Creating Reusable Report Items
Managing a Reporting Infrastructure
Managing Security
Managing Report Execution
Delivering Reports with Subscriptions
Troubleshooting Reporting Services
Creating Multidimensional Databases
Introduction to Multidimensional Analysis
Creating Data Sources and Data Source Views
Creating a Cube
Overview of Cube Security
Working with Cubes and Dimensions
Configuring Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Attributes
Working with Measures and Measure Groups
Working With Measures
Working with Measure Groups
Introduction to MDX in this module
MDX Fundamentals
Adding Calculations to a Cube
Using MDX To Query a Cube
Customizing Cube Functionality
Implementing Key Performance Indicators
Implementing Actions
Implementing Perspectives
Implementing Translations
Implementing a Tabular Data Model by Using Microsoft PowerPivot
Introduction to Tabular Data Models and PowerPivot Technologies
Creating a Tabular Data Model by Using PowerPivot for Excel
Sharing a PowerPivot Workbook and Using PowerPivot Gallery
Introduction to Data Analysis Expression (DAX)
DAX Fundamentals
Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
Implementing an Analysis Services Tabular Data Model
Introduction to Analysis Services Tabular Data Model Projects
Implementing an Analysis Services Tabular Data Model in Business Intelligence Development Studio
Creating Data Visualizations With Power View
Introduction to Power View
Visualizing Data with Power View
Performing Predictive Analysis with Data Mining
Overview of Data Mining
Using the Data Mining Add-In for Excel
Creating a Custom Data Mining Solution
Validating a Data Mining Model
Connecting to a and Consuming a Data-Mining Model
Zielgruppen
Datenbank-Professionals
Voraussetzungen
Teilnehmer können nach Besuch des Kurses PowerPivot und tabellarische Datenmodelle implementieren, Datenvisualisierungen mit Power Views und SQL Server Reporting Services erstellen und ausliefern und mit Data Mining zu einem Geschäftsverständnis gelangen.

