Möchten Sie verkaufen? Hier verkaufen
Microsoft® SQL Server(TM) 2000 Analysis Services Step by Step (DV-DLT Fundamentals)
 
 
Den Verlag informieren!
Ich möchte dieses Buch auf dem Kindle lesen.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

Microsoft® SQL Server(TM) 2000 Analysis Services Step by Step (DV-DLT Fundamentals) [Englisch] [Taschenbuch]

OLAP Train , Reed Jacobson
5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)

Erhältlich bei diesen Anbietern.



Produktinformation

  • Taschenbuch: 400 Seiten
  • Verlag: Microsoft Press Books; Auflage: Pap/Cdr (6. Oktober 2000)
  • Sprache: Englisch
  • ISBN-10: 0735609047
  • ISBN-13: 978-0735609044
  • Größe und/oder Gewicht: 23,1 x 18,8 x 2,8 cm
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: Nr. 495.767 in Englische Bücher (Siehe Top 100 in Englische Bücher)
  • Komplettes Inhaltsverzeichnis ansehen

Mehr über den Autor

Reed Jacobson
Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Besuchen Sie die Seite von Reed Jacobson auf Amazon

Produktbeschreibungen

Kurzbeschreibung

MICROSOFT #174; SQL SERVER 2000 ANALYSIS SERVICES STEP BY STEP shows Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000. You ll discover why these services make it easier to analyze huge amounts of data quickly, and you ll learn how to develop a wide range of advanced dimensional-data applications from enterprise reporting tools to advanced decision-support systems. The book s easy-to-follow lessons begin with clear objectives and include real-world business examples, with a companion CD full of sample files that support each lesson. This title shows you how to: Administer the Analysis Manager: Understand the fundamentals behind data dimensions and hierarchies, data warehousing, and the Microsoft Analysis Services architecture, and use the Microsoft Analysis Manager application to define and populate data cubes. Create and display cubes: Define and modify measures and dimensions. Design, build, process, and view cubes, from simple to advanced, with cube and dimension editors.Use Microsoft Excel PivotTable #174; Reports and the PivotTable List in Microsoft Excel to browse cubes, and create cubes using Microsoft Office. Query cubes: Use multidimensional expressions (MDX) values and sets and the MDX Sample application to query and display dimensional data. Perform advanced administration: Choose data storage options and the Storage Design Wizard to optimize, manage, and update data efficiently. Automate the Analysis server to process an OLAP database. Work with partitions and automate updates, and apply security to cubes.

Synopsis

MICROSOFT #174; SQL SERVER 2000 ANALYSIS SERVICES STEP BY STEP shows Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000. You ll discover why these services make it easier to analyze huge amounts of data quickly, and you ll learn how to develop a wide range of advanced dimensional-data applications from enterprise reporting tools to advanced decision-support systems. The book s easy-to-follow lessons begin with clear objectives and include real-world business examples, with a companion CD full of sample files that support each lesson. This title shows you how to: Administer the Analysis Manager: Understand the fundamentals behind data dimensions and hierarchies, data warehousing, and the Microsoft Analysis Services architecture, and use the Microsoft Analysis Manager application to define and populate data cubes. Create and display cubes: Define and modify measures and dimensions. Design, build, process, and view cubes, from simple to advanced, with cube and dimension editors.Use Microsoft Excel PivotTable #174; Reports and the PivotTable List in Microsoft Excel to browse cubes, and create cubes using Microsoft Office.

Query cubes: Use multidimensional expressions (MDX) values and sets and the MDX Sample application to query and display dimensional data. Perform advanced administration: Choose data storage options and the Storage Design Wizard to optimize, manage, and update data efficiently. Automate the Analysis server to process an OLAP database. Work with partitions and automate updates, and apply security to cubes.


In diesem Buch (Mehr dazu)
Einleitungssatz
Suppose that you are the president of a small, new company. Lesen Sie die erste Seite
Mehr entdecken
Wortanzeiger
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Hier reinlesen und suchen:

Tags

 (Was ist das?)
Bei einem Tag handelt es sich um ein Schlagwort, das zum Produkt passt.
Tags erleichtern allen Kunden die Suche und die Sortierung ihrer Lieblingsprodukte.
 

Eine digitale Version dieses Buchs im Kindle-Shop verkaufen

Wenn Sie ein Verleger oder Autor sind und die digitalen Rechte an einem Buch haben, können Sie die digitale Version des Buchs in unserem Kindle-Shop verkaufen. Weitere Informationen

Kundenrezensionen

4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
Die hilfreichsten Kundenrezensionen
4 von 4 Kunden fanden die folgende Rezension hilfreich
Von Ein Kunde
Format:Taschenbuch
Soferne man ein Basiswissen besitzt, was OLAP ist, ist dieses Buch hervorragend dazu geeignet, sich die Analysis Services anhand von kleinen Beispielen anzusehen. Die Beispiele gefallen mir deswegen sehr gut, weil sie aus verschiedenen Themenbereichen stammen (Cubes für Sales-, Finance- oder Webanalyse) und so einen recht guten Überblick über die Einsatzmöglichkeiten gewährleisten. Die einzelnen steps sind klar und leicht verständlich erläutert.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com:  26 Rezensionen
28 von 29 Kunden fanden die folgende Rezension hilfreich
Good for getting started with Analysis Services 18. April 2001
Von Douglas Welzel - Veröffentlicht auf Amazon.com
Format:Taschenbuch
This Step by Step guide serves as a great starting point for getting familiar with Microsoft's Analysis services. It starts with a quick introduction to data warehousing (without resorting to giving an entire history of the subject, as seems so common today) and how it relates to OLAP and then moves right into the Analysis Servies tools.

The chapters are well written and get you the information you need, without missing any major details. Even if you don't plan to take the "step by step" approach, this book is worth having by your side.

All right... now for the downsides. At best this book is good for beginners. These are some of the areas where I found it came up short:

- Sizing systems that will support Analysis Services. The book talks a bit about how big cubes are, but there is no information about cube performance/cube sizing, etc. Basically, this book won't help you develop a hardware plan for hosting Analysis Services.

- Accessing Analysis Services via the web. All of Microsoft's literature talks about how SQL Server 2000's great support for the web/XML. Strangely, it is very hard to find this information for Analysis Services, and this book doesn't provide any guidance. Right now it seems that the best you can do to find this information is hunt around Microsoft's site.

Overall I still think this is good book. However, if you are going to be building a large Analysis Services system, expect to be looking for other sources to answer all of your questions.

16 von 16 Kunden fanden die folgende Rezension hilfreich
Analysis Services 6. Dezember 2000
Von "johnr98798" - Veröffentlicht auf Amazon.com
Format:Taschenbuch
This book is very basic and should provide a good foundation for those people who are not familiar with SQL 7's OLAP or the newer implementation called 'analysis services'.

It is easy to read, the examples on the cd work perfectly and the tutorials provide a good overview of how to create your own cubes.

It's pretty thin and after reading through the first few chapters I found myself putting it down and just diving into designing my own stuff with microsoft's interface. It's a very logical application and with little or no resource materials people could easily figure this out with the tutorials included with the software.

This is not a good reference book, though I'm at a loss as to what would be a decent reference book on this subject since it's one of those things you either know or you don't.

MDX is VERY thin, and since you can teach the basics to yourself, a reference/primer book on MDX may suit you better.

12 von 12 Kunden fanden die folgende Rezension hilfreich
Not what it needs to be 11. November 2001
Von Ein Kunde - Veröffentlicht auf Amazon.com
Format:Taschenbuch
This book shows some basic examples by mousing through the menus with a pre-cooked script, but the on-line tutorial does about the same thing. However, there are no explanations why one would select one option over another, no explanations about how to construct different cubes to solve problems and no explanations about the syntax of Analysis services. There is no overriding theory presented that allows one to gain an understanding about how to frame and solve problems using Analysis services nor about what kinds of problems can and can't be solved. After reading the book I have a high level understanding about potentially what can be done, but I have not gained enough information to build anything useful.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 


Aktive Diskussionen in ähnlichen Foren
Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   
Ähnliche Foren


Lieblingslisten


Ähnliche Artikel finden


Anhand des Sachgebietes nach ähnlichen Produkten suchen:


Ihr Kommentar