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:
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.
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
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
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
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
