Designing an OLAP Solution Architecture Using MS SQL Server 2005 (M2796)

Examinar Training GmbH
In Frankfurt Am Main, Karlsruhe, Nürnberg und an 4 weiteren Standorten

1.654 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
-89-9... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

Beschreibung

Capture the business and technical requirements for a BI solution, Design and implement a logical Online Analytical Processing (OLAP) solution architecture, design physical storage for a multidimensional solution, create calculated members and named sets, implement Key Performance Indicators (KPIs), actions, and stored procedures, design the infras...

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Dresden
Am Brauhaus 8, 01099, Sachsen, Deutschland
Plan ansehen
auf Anfrage
Düsseldorf
Kanzlerstraße 4, 40472, Nordrhein-Westfalen, NRW, Deutschland
Plan ansehen
auf Anfrage
Frankfurt Am Main
Gervinusstraße 18, 60322, Hessen, Deutschland
Plan ansehen
auf Anfrage
Karlsruhe
Neureuterstr. 37b, 76185, Baden-Württemberg, Deutschland
Plan ansehen
auf Anfrage
München
Werner-Eckert-Straße 11, 81829, Bayern, Deutschland
Plan ansehen
Alle ansehen (7)

Häufig gestellte Fragen

· Voraussetzungen

Before attending this course, students must: Creating Transact-SQL queries Writing and optimizing advanced queries (for example, queries that contain complex joins or ...

Themenkreis

Voraussetzung:
Before attending this course, students must:
Creating Transact-SQL queries
Writing and optimizing advanced queries (for example, queries that contain complex joins or subqueries)
Creating database objects such as tables, views, and indexes
Conceptual understanding of OLAP technologies, multi-dimensional data, MDX, and relational database modeling. For example, know what facts, dimensions, measures, calculated measures, and foreign keys are.
Be familiar with SQL Server 2005 features, tools, and technologies. In particular, they must have built and queried a cube.
Already know how to use:
Microsoft SQL Server Business Intelligence Development Studio
Microsoft SQL Server Management Studio
Themen:
Capture the business and technical requirements for a BI solution, Design and implement a logical Online Analytical Processing (OLAP) solution architecture, design physical storage for a multidimensional solution, create calculated members and named sets, implement Key Performance Indicators (KPIs), actions, and stored procedures, design the infrastructure for an OLAP solution, deploy and secure an Analysis Services solution in a production environment, Monitor and optimize an Analysis Services solution, implement a Data Mining Solution.
Inhalt:
Capturing Business and Technical Requirements
Capturing Business and Technical Requirements
Designing and Implementing a Logical OLAP Solution Architecture
Designing and Implementing a UDM
Designing Physical Storage for a Multidimensional Solution
Designing and Implementing Physical Storage
Creating Calculations
Implementing Calculations
Extending Cube Functionality
Implementing Advanced Functionality
Designing an Analysis Services Infrastructure
Designing and Implementing Analysis Services Infrastructure
Deploying a Multidimensional Solution into Production
Deploying Analysis Services into Production
Optimizing an OLAP Solution
Optimizing Analysis Services
Implementing Data Mining
Implementing Data Mining

Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen