Implementing Data Models and Reports with Microsoft SQL Server

Download (0)

Full text

(1)

Implementing Data Models and Reports with Microsoft® SQL Server®

Dauer: 5 Tage Kursnummer: M20466

Überblick:

Business Intelligence (BI) wird für Unternehmen von verschiedenen Größen aufgrund des dadurch entstehenden Wettbewerbsvorteils immer wichtiger.

Durch die kombinierten Ressourcen von SQL Server 2012/2014 und SharePoint 2013 wird es immer einfacher für Unternehmen, eine BI Lösung zu entwickeln, die ganz auf die Bedürfnisse des Unternehmens abgestimmt ist und dabei die Kosten wesentlich reduziert.

Dieser fünftägige Kurs zeigt den Teilnehmern, wie sie Mitarbeiter im Unternehmen befähigen, Analysen und Reportings selbst zu erstellen. Sie lernen in diesem Kurs, wie Sie eine multidimensionale Analyse-Lösung implementieren, PowerPivot und tabulare Daten-Modelle kreieren und wie Sie umfangreiche Datanvisualisierungen mit PowerView und SQL Server Reporting Services liefern.

In diesem Kurs werden die original Microsoft Kursunterlagen (MOC 20466) verwendet.

IHR GLOBAL-BONUS: 1-2-3 PROMO Mehr Teilnehmer = Höherer Rabattsatz

Sparen Sie bis zu 25% bei Anmeldung mehrerer Teilnehmer!

So funktionierts...

Wer soll teilnehmen?:

Dieses Training richtet sich an Entwickler von Business Intelligence Lösungen, die eine Analyse- und Reporting-Lösung entwickeln sollen.

Kursziel:

Nach diesem Kurs können Sie: Implement measures and measure groups in a cube. Describe the components, architecture, and nature of a BI

solution.

Use MDX Syntax.

Create reports with Reporting Services.

Customize a cube.

Create reusable report items that simplify self-service reporting.

Implement a Tabular Data Model in PowerPivot.

Manage report execurtion and delivery.

Use DAX to query a tabular model.

create a multidimensional database with Analysis Services.

Implement a Tabular Database.

Implement dimensions in a cube.

Use PowerView to create interactive data visualizations.

Voraussetzungen:

Examen und Zertifizierungen

Eine Teilnahme am Kurs Implementing a Data Warehouse with Dieses Training dient als Vorbereitung auf die Prüfungen 70-466:

(2)

empfohlen. Zur Teilnahme an diesem Training werden Kenntnisse 2012 und 70-467: Designing Business Intelligence Solutions with aus dem Bereich Microsoft SQL Server 2012 (oder 2008/2008 R2) Microsoft SQL Server 2012 und ermöglicht damit zur Zertifizierung

benötigt. zum MCSE - Business Intelligence.

Als Voraussetzung zur Erlangung diese MCSE Zertifizierung müssen Sie auch zuvor die Zertifizierung zum MCSA - SQL Server 2012 abgeschlossen haben.

(3)

Detaillierte Kursbeschreibung:

Creating Multidimensional Databases

line line line

Creating Data Sources and Data Source Grouping and Aggregating Data in a Introduction to Business Intelligence and Data Views Report

Modeling Showing Data Graphically

line Filteirng Reports by Using Parameters

line Publishing and Viewing a Report

Implementing Reports with SQL Server Grouping and Aggregating Data in a Report Parts

Reporting Services Report Managing Report Execution

line Showing Data Graphically Subscriptions and Data Alert

Creating a Report with Report Designer Filteirng Reports by Using Parameters Troubleshooting Reporting Services Publishing and Viewing a Report Creating a Cube

Report Parts Overview of Cube Security

line Managing Report Execution Defining Atribute Hierarchies

Grouping and Aggregating Data in a Report Subscriptions and Data Alert Sorting and Grouping Attributes Showing Data Graphically Troubleshooting Reporting Services Working with Measure Groups Filteirng Reports by Using Parameters Creating a Cube Adding Calculations to a Cube Publishing and Viewing a Report Overview of Cube Security Using MDX to Query a Cube

Report Parts Defining Atribute Hierarchies Working with Actions

Managing Report Execution Sorting and Grouping Attributes Working with Perspectives Subscriptions and Data Alert Working with Measure Groups Working with Translations

Troubleshooting Reporting Services Adding Calculations to a Cube Sharing a PowerPivot Workbook and

Creating a Cube Using MDX to Query a Cube Using PowerPivot Gallery

Overview of Cube Security Working with Actions Using DAX to Create Calculated Column Defining Atribute Hierarchies Working with Perspectives and Meaures in a Tabular Data Model Sorting and Grouping Attributes Working with Translations Validating a Data Mining Solution Working with Measure Groups Sharing a PowerPivot Workbook and Consuming a Data Mining Solution Adding Calculations to a Cube Using PowerPivot Gallery

Using MDX to Query a Cube Using DAX to Create Calculated Column Working with Actions and Meaures in a Tabular Data Model line

Working with Perspectives Validating a Data Mining Solution Grouping and Aggregating Data in a Working with Translations Consuming a Data Mining Solution Report

Sharing a PowerPivot Workbook and Using Showing Data Graphically

PowerPivot Gallery Filteirng Reports by Using Parameters

Using DAX to Create Calculated Column line Publishing and Viewing a Report and Meaures in a Tabular Data Model Grouping and Aggregating Data in a Report Parts

Validating a Data Mining Solution Report Managing Report Execution

Consuming a Data Mining Solution Showing Data Graphically Subscriptions and Data Alert Filteirng Reports by Using Parameters Troubleshooting Reporting Services Publishing and Viewing a Report Creating a Cube

line Report Parts Overview of Cube Security

Grouping and Aggregating Data in a Report Managing Report Execution Defining Atribute Hierarchies Showing Data Graphically Subscriptions and Data Alert Sorting and Grouping Attributes Filteirng Reports by Using Parameters Troubleshooting Reporting Services Working with Measure Groups Publishing and Viewing a Report Creating a Cube Adding Calculations to a Cube

Report Parts Overview of Cube Security Using MDX to Query a Cube

Managing Report Execution Defining Atribute Hierarchies Working with Actions Subscriptions and Data Alert Sorting and Grouping Attributes Working with Perspectives Troubleshooting Reporting Services Working with Measure Groups Working with Translations

Creating a Cube Adding Calculations to a Cube Sharing a PowerPivot Workbook and Overview of Cube Security Using MDX to Query a Cube Using PowerPivot Gallery

Defining Atribute Hierarchies Working with Actions Using DAX to Create Calculated Column Sorting and Grouping Attributes Working with Perspectives and Meaures in a Tabular Data Model Working with Measure Groups Working with Translations Validating a Data Mining Solution Adding Calculations to a Cube Sharing a PowerPivot Workbook and Consuming a Data Mining Solution Using MDX to Query a Cube Using PowerPivot Gallery

Working with Actions Using DAX to Create Calculated Column Implementing a Tabular Data Model with Working with Perspectives and Meaures in a Tabular Data Model Microsoft PowerPivot

Working with Translations Validating a Data Mining Solution line

Sharing a PowerPivot Workbook and Using Consuming a Data Mining Solution Creating a Tabular Data Model by Using

PowerPivot Gallery PowerPivot for Excel

Using DAX to Create Calculated Column Working with Dimensions and Meaures in a Tabular Data Model line

(4)

Consuming a Data Mining Solution Grouping and Aggregating Data in a Report

line Showing Data Graphically

line Grouping and Aggregating Data in a Filteirng Reports by Using Parameters Grouping and Aggregating Data in a Report Report Publishing and Viewing a Report Showing Data Graphically Showing Data Graphically Report Parts

Filteirng Reports by Using Parameters Filteirng Reports by Using Parameters Managing Report Execution Publishing and Viewing a Report Publishing and Viewing a Report Subscriptions and Data Alert

Report Parts Report Parts Troubleshooting Reporting Services

Managing Report Execution Managing Report Execution Creating a Cube

Subscriptions and Data Alert Subscriptions and Data Alert Overview of Cube Security Troubleshooting Reporting Services Troubleshooting Reporting Services Defining Atribute Hierarchies

Creating a Cube Creating a Cube Sorting and Grouping Attributes

Overview of Cube Security Overview of Cube Security Working with Measure Groups Defining Atribute Hierarchies Defining Atribute Hierarchies Adding Calculations to a Cube Sorting and Grouping Attributes Sorting and Grouping Attributes Using MDX to Query a Cube Working with Measure Groups Working with Measure Groups Working with Actions Adding Calculations to a Cube Adding Calculations to a Cube Working with Perspectives Using MDX to Query a Cube Using MDX to Query a Cube Working with Translations

Working with Actions Working with Actions Sharing a PowerPivot Workbook and Working with Perspectives Working with Perspectives Using PowerPivot Gallery

Working with Translations Working with Translations Using DAX to Create Calculated Column Sharing a PowerPivot Workbook and Using Sharing a PowerPivot Workbook and and Meaures in a Tabular Data Model PowerPivot Gallery Using PowerPivot Gallery Validating a Data Mining Solution Using DAX to Create Calculated Column Using DAX to Create Calculated Column Consuming a Data Mining Solution and Meaures in a Tabular Data Model and Meaures in a Tabular Data Model

Validating a Data Mining Solution Validating a Data Mining Solution Introduction to DAX Consuming a Data Mining Solution Consuming a Data Mining Solution line

DAX Fundamentals

line line

Grouping and Aggregating Data in a Report Grouping and Aggregating Data in a line

Showing Data Graphically Report Grouping and Aggregating Data in a

Filteirng Reports by Using Parameters Showing Data Graphically Report

Publishing and Viewing a Report Filteirng Reports by Using Parameters Showing Data Graphically

Report Parts Publishing and Viewing a Report Filteirng Reports by Using Parameters

Managing Report Execution Report Parts Publishing and Viewing a Report

Subscriptions and Data Alert Managing Report Execution Report Parts

Troubleshooting Reporting Services Subscriptions and Data Alert Managing Report Execution Creating a Cube Troubleshooting Reporting Services Subscriptions and Data Alert Overview of Cube Security Creating a Cube Troubleshooting Reporting Services Defining Atribute Hierarchies Overview of Cube Security Creating a Cube

Sorting and Grouping Attributes Defining Atribute Hierarchies Overview of Cube Security Working with Measure Groups Sorting and Grouping Attributes Defining Atribute Hierarchies Adding Calculations to a Cube Working with Measure Groups Sorting and Grouping Attributes Using MDX to Query a Cube Adding Calculations to a Cube Working with Measure Groups Working with Actions Using MDX to Query a Cube Adding Calculations to a Cube Working with Perspectives Working with Actions Using MDX to Query a Cube Working with Translations Working with Perspectives Working with Actions Sharing a PowerPivot Workbook and Using Working with Translations Working with Perspectives PowerPivot Gallery Sharing a PowerPivot Workbook and Working with Translations

Using DAX to Create Calculated Column Using PowerPivot Gallery Sharing a PowerPivot Workbook and and Meaures in a Tabular Data Model Using DAX to Create Calculated Column Using PowerPivot Gallery

Validating a Data Mining Solution and Meaures in a Tabular Data Model Using DAX to Create Calculated Column Consuming a Data Mining Solution Validating a Data Mining Solution and Meaures in a Tabular Data Model

Consuming a Data Mining Solution Validating a Data Mining Solution

Supporting Self Service Reporting Consuming a Data Mining Solution

line Working with Meaures and Measure Groups

Shared Data Sources and Datasets line Implementing an Analysis Services Tabular Working with Measures Data Model

line

line Developing an Analysis Services Tabular

Grouping and Aggregating Data in a Report line Data Model in SQL Server Data Tools Showing Data Graphically Grouping and Aggregating Data in a

Filteirng Reports by Using Parameters Report Creating Data Visualizations with Power View Publishing and Viewing a Report Showing Data Graphically line

(5)

Report Parts Filteirng Reports by Using Parameters

Managing Report Execution Publishing and Viewing a Report Performing Predictive Analysis with Data

Subscriptions and Data Alert Report Parts Mining

Troubleshooting Reporting Services Managing Report Execution line

Creating a Cube Subscriptions and Data Alert Creating a Data Mining Solution Overview of Cube Security Troubleshooting Reporting Services

Defining Atribute Hierarchies Creating a Cube

Sorting and Grouping Attributes Overview of Cube Security line

Working with Measure Groups Defining Atribute Hierarchies Grouping and Aggregating Data in a Adding Calculations to a Cube Sorting and Grouping Attributes Report

Using MDX to Query a Cube Working with Measure Groups Showing Data Graphically

Working with Actions Adding Calculations to a Cube Filteirng Reports by Using Parameters Working with Perspectives Using MDX to Query a Cube Publishing and Viewing a Report

Working with Translations Working with Actions Report Parts

Sharing a PowerPivot Workbook and Using Working with Perspectives Managing Report Execution PowerPivot Gallery Working with Translations Subscriptions and Data Alert Using DAX to Create Calculated Column Sharing a PowerPivot Workbook and Troubleshooting Reporting Services and Meaures in a Tabular Data Model Using PowerPivot Gallery Creating a Cube

Validating a Data Mining Solution Using DAX to Create Calculated Column Overview of Cube Security Consuming a Data Mining Solution and Meaures in a Tabular Data Model Defining Atribute Hierarchies

Validating a Data Mining Solution Sorting and Grouping Attributes Managing Report Execution and Delivery Consuming a Data Mining Solution Working with Measure Groups

line Adding Calculations to a Cube

Managing Report Security Introduction to MDX Using MDX to Query a Cube

line Working with Actions

MDX Fundamentals Working with Perspectives

line Working with Translations

Grouping and Aggregating Data in a Report Sharing a PowerPivot Workbook and

Showing Data Graphically line Using PowerPivot Gallery

Filteirng Reports by Using Parameters Grouping and Aggregating Data in a Using DAX to Create Calculated Column Publishing and Viewing a Report Report and Meaures in a Tabular Data Model Report Parts Showing Data Graphically Validating a Data Mining Solution Managing Report Execution Filteirng Reports by Using Parameters Consuming a Data Mining Solution Subscriptions and Data Alert Publishing and Viewing a Report

Troubleshooting Reporting Services Report Parts

Creating a Cube Managing Report Execution line

Overview of Cube Security Subscriptions and Data Alert Grouping and Aggregating Data in a Defining Atribute Hierarchies Troubleshooting Reporting Services Report

Sorting and Grouping Attributes Creating a Cube Showing Data Graphically

Working with Measure Groups Overview of Cube Security Filteirng Reports by Using Parameters Adding Calculations to a Cube Defining Atribute Hierarchies Publishing and Viewing a Report Using MDX to Query a Cube Sorting and Grouping Attributes Report Parts

Working with Actions Working with Measure Groups Managing Report Execution Working with Perspectives Adding Calculations to a Cube Subscriptions and Data Alert Working with Translations Using MDX to Query a Cube Troubleshooting Reporting Services Sharing a PowerPivot Workbook and Using Working with Actions Creating a Cube

PowerPivot Gallery Working with Perspectives Overview of Cube Security Using DAX to Create Calculated Column Working with Translations Defining Atribute Hierarchies and Meaures in a Tabular Data Model Sharing a PowerPivot Workbook and Sorting and Grouping Attributes Validating a Data Mining Solution Using PowerPivot Gallery Working with Measure Groups Consuming a Data Mining Solution Using DAX to Create Calculated Column Adding Calculations to a Cube and Meaures in a Tabular Data Model Using MDX to Query a Cube Validating a Data Mining Solution Working with Actions

line Consuming a Data Mining Solution Working with Perspectives

Grouping and Aggregating Data in a Report Working with Translations

Showing Data Graphically Sharing a PowerPivot Workbook and

Filteirng Reports by Using Parameters line Using PowerPivot Gallery

Publishing and Viewing a Report Grouping and Aggregating Data in a Using DAX to Create Calculated Column

Report Parts Report and Meaures in a Tabular Data Model

Managing Report Execution Showing Data Graphically Validating a Data Mining Solution Subscriptions and Data Alert Filteirng Reports by Using Parameters Consuming a Data Mining Solution Troubleshooting Reporting Services Publishing and Viewing a Report

Creating a Cube Report Parts

Overview of Cube Security Managing Report Execution Defining Atribute Hierarchies Subscriptions and Data Alert Sorting and Grouping Attributes Troubleshooting Reporting Services

(6)

Working with Measure Groups Creating a Cube

Adding Calculations to a Cube Overview of Cube Security Using MDX to Query a Cube Defining Atribute Hierarchies Working with Actions Sorting and Grouping Attributes Working with Perspectives Working with Measure Groups Working with Translations Adding Calculations to a Cube Sharing a PowerPivot Workbook and Using Using MDX to Query a Cube PowerPivot Gallery Working with Actions Using DAX to Create Calculated Column Working with Perspectives and Meaures in a Tabular Data Model Working with Translations

Validating a Data Mining Solution Sharing a PowerPivot Workbook and Consuming a Data Mining Solution Using PowerPivot Gallery

Using DAX to Create Calculated Column and Meaures in a Tabular Data Model

line Validating a Data Mining Solution

Grouping and Aggregating Data in a Report Consuming a Data Mining Solution Showing Data Graphically

Filteirng Reports by Using Parameters Customizing Cube Functionality Publishing and Viewing a Report line

Report Parts Working with Key Performance Indicators Managing Report Execution

Subscriptions and Data Alert

Troubleshooting Reporting Services line

Creating a Cube Grouping and Aggregating Data in a Overview of Cube Security Report

Defining Atribute Hierarchies Showing Data Graphically

Sorting and Grouping Attributes Filteirng Reports by Using Parameters Working with Measure Groups Publishing and Viewing a Report Adding Calculations to a Cube Report Parts

Using MDX to Query a Cube Managing Report Execution Working with Actions Subscriptions and Data Alert Working with Perspectives Troubleshooting Reporting Services Working with Translations Creating a Cube

Sharing a PowerPivot Workbook and Using Overview of Cube Security PowerPivot Gallery Defining Atribute Hierarchies Using DAX to Create Calculated Column Sorting and Grouping Attributes and Meaures in a Tabular Data Model Working with Measure Groups Validating a Data Mining Solution Adding Calculations to a Cube Consuming a Data Mining Solution Using MDX to Query a Cube

Working with Actions Working with Perspectives Working with Translations

Sharing a PowerPivot Workbook and Using PowerPivot Gallery

Using DAX to Create Calculated Column and Meaures in a Tabular Data Model Validating a Data Mining Solution Consuming a Data Mining Solution

Weitere Informationen:

Für weitere Informationen oder Buchung kontaktieren Sie uns bitte unter 01/66 55 655 3000 info@globalknowledge.at

www.globalknowledge.at

Figure

Updating...

References

Related subjects :