Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.

  • Apple
  • Android
  • Windows Phone
  • Android

Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.

Kindle-Preis: EUR 18,32
inkl. MwSt.

Diese Aktionen werden auf diesen Artikel angewendet:

Einige Angebote können miteinander kombiniert werden, andere nicht. Für mehr Details lesen Sie bitte die Nutzungsbedingungen der jeweiligen Promotion.

An Ihren Kindle oder ein anderes Gerät senden

An Ihren Kindle oder ein anderes Gerät senden

Facebook Twitter Pinterest <Einbetten>
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide von [Rad, Reza]
Anzeige für Kindle-App

Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide Kindle Edition


Alle Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Preis
Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
EUR 18,32

Kindle-Deal des Monats
Kindle-Deal des Monats
Ausgewählte Top-eBooks mit einem Preisvorteil von bis zu 50% warten auf Sie. Entdecken Sie jeden Monat eine neue Auswahl. Hier klicken

Produktbeschreibungen

Kurzbeschreibung

Get to grips with Microsoft Business Intelligence and data warehousing technologies using this practi cal guide

About This Book


  • Discover the Dimensional Modeling concept while designing a data warehouse

  • Learn Data Movement based on technologies such as SSIS, MDS, and DQS

  • Design dashboards and reports with Microsoft BI technologies

Who This Book Is For

If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you.


It's assumed that you will have some experience in databases systems and T-SQL. This book is will give you a good upshot view of each component and scenarios featuring the use of that component in Data Warehousing and Business Intelligence systems.

What You Will Learn


  • Perform Data Modeling with SSAS Multidimensional and MDX

  • Use DAX and SSAS tabular for Data Modeling

  • Manage Master Data with MDS

  • Reveal Knowledge Driven Data Quality with DQS

  • Understand prediction and Data Mining

  • Identify data patterns and predictive models

  • Design Dashboards with PerformancePoint and Power View

  • Explore Power Query and Power Map as components of Power BI

  • Create Reports with SQL Server Reporting Services and integrate them in applications

In Detail

Take advantage of the real power behind the BI components of SQL Server 2014, Excel 2013, and SharePoint 2013 with this hands-on book. This book will give you a competitive advantage by helping you to quickly learn how to design and build BI system with Microsoft BI tools.

This book starts with designing a data warehouse with dimensional modeling, and then looks at creating data models based on SSAS multidimensional and Tabular technologies. It will illustrate how to use SSIS for ETL, and MDS and DQS for data governance and data quality. The book is packed with real-world examples that will give you a good understanding of the BI and DW components of SQL Server 2014, Excel 2013, and SharePoint 2013.

Über den Autor und weitere Mitwirkende

Reza Rad

Reza Rad has more than 10 years of experience in databases and soft ware applications. Most of his work experience is in data warehousing and business intelligence. He has worked with Microsoft technologies from SQL Server 7 and Visual Basic 6 to the latest versions of SQL Server and .NET. He has a Bachelor's degree in Computer Engineering. Reza is a DW/BI architect and consultant. He has worked with large enterprises around the world and delivered highquality data warehousing and BI solutions for them. He has worked with industries in different sectors, such as Health, Finance, Logistics, Sales, Order Management, Manufacturing, Telecommunication, and so on. Reza has been awarded the Microsoft Most Valuable Professional in SQL Server from 2011 to 2014. He is an international speaker in SQL Server, BI, and DW conferences around the world. He speaks in SQL PASS Summits, Microsoft TechEd, SQL Saturdays, SQL Server user groups, and code camps. Reza has written books on SQL Server and databases. One of his most recent books is SQL Server 2012 Integration Services: An Expert Cookbook, Packt Publishing. Reza is a big fan of datarelated technologies, his expertise is in EIM, ETL, Data governance, big data, data warehousing, BI, data visualizati on, Master Data Management, OLAP, and so on. He is the author of Webcast series on the RADACAD website (http://www.radacad.com). He writes articles and blog posts on his technical blog (http://www.rad.pasfu.com); he writes about most of the Microsoft technologies, such as SSIS, MDS, DQS, SSAS, Power BI, HDInsight, and so on. His blog contains the latest information on his presentations and publications. Reza is a Mentor and a Microsoft Certified Trainer. He has been in the professional training business for many years. He conducts extensive 400 handedlevel training for many enterprises around the world via both remote and inperson training. He is an active member of MSDN forums, especially those on SQL Server and Power BI. He is also the leader of the New Zealand Data Warehousing and Business Intelligence user group, which is a registered chapter of PASS.


Produktinformation

  • Format: Kindle Edition
  • Dateigröße: 26215 KB
  • Seitenzahl der Print-Ausgabe: 352 Seiten
  • ISBN-Quelle für Seitenzahl: 1849688885
  • Verlag: Packt Publishing (26. Mai 2014)
  • Verkauf durch: Amazon Media EU S.à r.l.
  • Sprache: Englisch
  • ASIN: B00KLAJ6OA
  • Text-to-Speech (Vorlesemodus): Aktiviert
  • X-Ray:
  • Word Wise: Nicht aktiviert
  • Verbesserter Schriftsatz: Nicht aktiviert
  • Durchschnittliche Kundenbewertung: Schreiben Sie die erste Bewertung
  • Amazon Bestseller-Rang: #212.246 Bezahlt in Kindle-Shop (Siehe Top 100 Bezahlt in Kindle-Shop)

  •  Ist der Verkauf dieses Produkts für Sie nicht akzeptabel?

Kundenrezensionen

Es gibt noch keine Kundenrezensionen auf Amazon.de
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Stern

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: 4.3 von 5 Sternen 10 Rezensionen
4 von 4 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen A comprehensive coverage of all the modern BI offerings from Microisoft even for a mature BI person 1. August 2014
Von A. Zubarev - Veröffentlicht auf Amazon.com
Format: Taschenbuch
The book, even though is marketed under the “Beginner’s Guide” moniker, is actually suitable for an intermediate Business Intelligence professional. Judge yourself: the book covers as advanced topics as:

Data Modeling using SSAS Multidimensional and Tabular with MDX and DAX
Manage Master Data with MDS
Reveal Knowledge Driven Data Quality with DQS
Understand prediction and Data Mining
Identify data patterns
Design Dashboards with PerformancePoint and Power View
Explore Power Query and Power Map as components of Power BI
Create powerful reports using Visual Studio

I think this list speaks for itself, it is an impressive, unprecedented coverage of topics.

A little more about the book: it is divided into sections as to first acknowledge the reader on what are the advantages to using a specific technology, then a short deeper dive into the exact usage example summed up into a detailed coverage of how a task was tackled and what would be readers’ take-aways. The book has high quality graphics and was read on my laptop as well as on Android tablet. All that makes this book a winner in absorbing a lot of technical content in short time plus make it stick in the head.

The book references enough external resources in case one would like to explore any topic further. In my opinion the book serves as a huge time saver in getting familiar with the latest Microsoft BI offerings and would easily allow anybody, even new to Power BI or DQS enter a Proof of Concept mode or make a quick presentation for a project stakeholder.

I liked the most the content on predictions and the cool visualizations that can be done with Power Map and Power View. My personal opinion, Power BI overall as a data visualization and analysis platform is just sassy!

A few notes to a prospective reader: one needs MS Office 2013 installed, have access to Microsoft Server 2012, an active Azure account and preferably run the whole software suite on a Virtual Machine.
3 von 3 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen This book provides a great entry point to learning Microsoft’s BI tools. Recommended. 6. April 2016
Von Ian Stirk - Veröffentlicht auf Amazon.com
Format: Taschenbuch
Hi,

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.

This book aims to explore Microsoft’s Business Intelligence (BI) tools and is targeted at beginners. This sounds like a contradiction.

The book is aimed at: “...BI professionals (consultants, architects, and developers) who want to become familiar with Microsoft BI tools”.

So, belying its title, it is not a book for the complete beginner, some knowledge of databases and architecture, is required to get the most from the book.

Below is a chapter-by-chapter exploration of the topics covered.

Chapter 1 Data Warehouse Design

The book opens with a look at the initial steps in creating a BI system, designing the data warehouse, which is optimized for reporting and analysis, and is used to help with decision making.

The chapter continues with a look at the architecture and components of a BI system. Data from various source systems is extracted, transformed and loaded (ETL) into the data warehouse. A common ETL tool is SQL Server Integration Services (SSIS). From the data warehouse, another structure is created, using SQL Server Analysis Services (SSAS), which is either file-based (OLAP cube) or memory-based (tabular model). Next, data visualization is discussed, this is what the user sees, and such tools include SQL Server Reporting Services (SSRS), Excel, and Power View. Master Data Management (MDM) maintains the definitive version of reference data, accessible via the Master Data Services (DMS). Finally, the Data Quality Services (DQS) component is used to maintain and improve data quality.

Next, the chapter looks at building a data warehouse, emphasising its denormalized flattened tables, which improve report query performance. The section then discusses dimensional modelling, defining some salient terms: fact/measure (business numbers/amounts), dimension (descriptions), attributes (columns), fact table (facts with links to dimensions), and grain (level of fact table detail). The star and snowflake schemas are explained, the latter has a degree of normalization in the dimension tables. The star schema is preferred for performance reasons.

Next, a small data warehouse is designed, based on sales information for a chain of supermarkets. Various business questions (e.g. what reports are needed) help decide the scope of the work, together with the level of data to store (the grain). Next, the various steps of Kimball’s best practices are followed: choose business process, identify grain, design dimensions, design facts. Some optimizations are discussed (e.g. replacing strings, using integer surrogate keys in the fact table).

The chapter ends with a look at different types of facts (transactional, snapshot, accumulating), and types of dimension (outriggers, role playing, degenerate). Finally, slowly changing dimensions are explained (0: no change accepted, 1: overwrite old value, 2: add a new record to preserve history).

This chapter provides a useful overview of what BI is, its major components, how they fit together, and provides a helpful walkthrough of an example data warehouse. It’s noted that data warehouse design is a critical step.

The chapter is generally easy to read, with useful explanations, helpful diagrams, inter-chapter references, and website links. The book requires some previous knowledge of databases systems (OLAP in particular). These traits apply to the whole of the book.
.
.
.
Conclusion

This book aims to explore Microsoft’s Business Intelligence (BI) tools, and succeeds. The book is generally easy to read, with useful explanations, practical step-by-step walkthroughs, helpful screenshots, inter-chapter references, and website links.

There is much more to learn about Microsoft’s BI tools, many of the components discussed here have many other options that have not been discussed, but the book does provide a useful entry point to the most commonly used BI components.

The book does require some previous knowledge of databases systems, so it’s not a guide for the complete beginner - contrary to its title. Sometimes, insufficient information is provided before an example walkthrough (i.e. why we do something), however, useful information is provided after the walkthrough. There are a few areas of bad grammar but nothing too onerous.

It might have been useful to include some comment on the growing importance of Big Data, and Machine Learning. I do wonder if they might lead to the decline of proprietary data warehouses and BI tools in the near future.

If you have some knowledge of database systems (OLAP in particular), this book provides a great entry point to learning Microsoft’s BI tools. Recommended.
2 von 2 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen Underwhelmed 17. September 2015
Von Amazon Customer - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
I am somewhat disappointed in this book. There are some grammatical errors where at times you have to reread the sentence to understand the point the author is trying to make but overall this is not that bad and you can generally figure out the meaning. The very frustrating part is that the examples are inconsistent. In some cases there are very clear instructions on how to do a specific part in the 'Time for Action' examples and in other cases it just instructs you to do something, without any direction, so the reader is stuck trying to figure out what to do. At times I am left frustrated and I have to walk away and come back to it. In other cases it appears the author just took for granted that after you have done something one time way back in the beginning of the book you will remember it 100 pages later. It doesn't necessarily have to be spelled out but at least having a reference to the page where the previous action took place would be nice.

This book is also very syntax driven. What I mean by this is there are instructions on HOW to do something but it doesn't go into the WHY you are doing it. I understand this is a beginner's book but I just expected more of an explanation on why AND how things are done.

The first part of the book talks about building the Data Warehouse but it doesn't explain in very much detail about how the dimension and fact tables were constructed, what was the methodology behind it and why they were designed the way they were. To me that is important information to understand and this book just gives you a link to an already created data warehouse that you download and use. To me it would have been MUCH more helpful to guide the reader through the actual creation of the data warehouse so that a clear understanding of why the dimension and fact tables were created and the path to get to that point.

I would not recommend this book for someone who is trying to understand the concepts of creating a data warehouse. As a book about how to perform actions once it is created it is ok for that, but not great
1 von 1 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Great book, for bringing you from zero, to skilled enough to begin implementing BI at your work 24. Juni 2014
Von Christian Henrik Reich - Veröffentlicht auf Amazon.com
Format: Kindle Edition
A very comprehensive book, which gives you all the tools to get started with BI on SQL Server. Yet, it is a page turner which is nice if you are an IT professional reading many books.

Many good examples with detailed explanations afterwards.
2.0 von 5 Sternen Not for learning the details 25. Januar 2016
Von Jeremy - Veröffentlicht auf Amazon.com
Format: Kindle Edition Verifizierter Kauf
This is not a good beginners guide. It does not explain why all these steps are being done. "Look what I just made, even though I have no idea why" is not a good place for a beginner. I tried the sample book before purchasing; it read with promise. However, the sample really oversells it. I don't recommend this book.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.
click to open popover