or
Sign in to turn on 1-Click ordering.
Trade in Yours
For a £7.29 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 [Paperback]

Philo Janus , Stacia Misner
4.0 out of 5 stars  See all reviews (1 customer review)
Price: £32.99 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want delivery by Thursday, 23 May? Choose Express delivery at checkout. See Details
Trade In this Item for up to £7.29
Trade in Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 for an Amazon.co.uk gift card of up to £7.29, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

1 April 2011 0071716734 978-0071716734

Master Microsoft's Business Intelligence Tools

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to take full advantage of Microsoft's collaborative business intelligence (BI) tools. A variety of powerful, flexible technologies are covered, including SQL Server Analysis Services (SSAS), Excel, Excel Services, PowerPivot, SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), SharePoint Server 2010, PerformancePoint Services, and Master Data Services. This practical guide focuses on deveoloping end-to-end BI solutions that foster informed decision making.

  • Create a multidimensional store for aggregating business data with SSAS
  • Maximize the analysis capabilities of Excel and Excel Services
  • Combine data from different sources and connect data for analysis with PowerPivot
  • Move data into the system using SSIS, InfoPath, Streamsight, and SharePoint 2010 External Lists
  • Build and publish reports with SSRS
  • Integrate data from disparate applications, using SharePoint 2010 BI features
  • Create scorecards and dashboards with PerformancePoint Services
  • Summarize large volumes of data in charts and graphs
  • Use the SSRS map feature for complex visualizations of spatial data
  • Uncover patterns and relationships in data using the SSAS data mining engine
  • Handle master data management with Master Data Services
  • Publish the components of your BI solution and perform administrative tasks


Product details

  • Paperback: 496 pages
  • Publisher: McGraw-Hill Osborne (1 April 2011)
  • Language: English
  • ISBN-10: 0071716734
  • ISBN-13: 978-0071716734
  • Product Dimensions: 18.5 x 2.4 x 23.3 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 848,291 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

About the Author

Phil Janus is a senior technology specialist with Microsoft. He has presented before thousands of users and developers on various topics, including SQL Server and BI, and has worked with large organizations on BI implementations.

Stacia Misner, MCITP, MCTS, is a consultant, trainer, and author specializing in Microsoft BI technologies. She has written several books and articles on SQL Server and is a frequent speaker at SQL Server conferences.


Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

5 star
0
3 star
0
2 star
0
1 star
0
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
Format:Paperback
This book aims itself at any level of experience, and as such the first two chapters give a detailed vendor-agnostic explanation of terms and general business intelligence (BI) overview. This is helpful, but as the book itself acknowledges, it is not a business book but rather a BI book - so you may need to enlist others to help fill in this knowledge. The initial explanations help to get you into the book gently so that you are not initially lost. The book includes exercises to help you learn from doing rather than simply reading, and assumes you have the software available to you.

It's a shame that the publisher has elected not to make the samples available to download as this really does impact the ability of the reader to follow the exercises through (as referenced spread-sheets etc. are not available, so a level of imagination must be used). This decision was obviously taken after the book was written as it expects you to have the samples. The author of chapters 8,10,11,12 and 13 Stacia Misner should however be commended as she has made a copy available on her site, [...]which alleviates this difficulty for those chapters.

Whilst it is recommended that you start by reading the first two chapters to provide a basic understanding of the concepts and terminology, the remainder of the book can to an extent be dipped into according to your need. The next chapters work through each component of the Microsoft BI stack in turn, then the remainder of the book helps you choose which part(s) of the stack are most suited to your environment, and how to implement, maintain and secure them together for the longer term. There is also a handy reference of chart types and their availability in the various Microsoft BI tools at the back of the book.

Being aimed at all levels, this book would work well for a technical analyst as well as a DBA looking to implement a reporting solution, and provides everything from sorting grouping and conditional formatting in Excel through to a Sharepoint/SSAS enterprise solution. It would be an ideal choice for a technically savvy IT manager looking to adopt a reporting solution, as it presents an overall view of the reporting landscape rather that concentrating on a single way of accomplishing a solution, thus allowing a choice to be made by the reader as to the best use of their resource to meet their need. The level of gentle introduction to a concept is helpful to beginners, although these concepts are quickly built upon to allow the breadth of content to be covered. It is however definitely written with the enterprise environment in mind (indeed, certain parts of the stack are only available in enterprise versions of the software). I also like the realistic approach, understanding that many organisations have disparate sources for data, and it is not all already in a data-mart ready for reporting - it may be in many formats, including non-Microsoft data products. Although this book was written specifically for Office 2010 and SQL 2008R2, the authors point out specific areas where these have changed from previous versions, allowing those on an earlier version and considering an upgrade to evaluate the worth of this decision.

This is a well-rounded and informative book which I would recommend if you are looking to implement a business information reporting system in your environment.

My review copy was provided free of charge to the SQL South West User Group, of which I am a member.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  1 review
5 of 6 people found the following review helpful
5.0 out of 5 stars Great Book !!! 28 Mar 2011
By Phil Milner - Published on Amazon.com
Format:Paperback
NOTE: source and sample code for book at the DataInspirations web site (see comments section for exact link)

This is a Well-written book on the latest version (R2) of the Microsoft Business Intelligence tools
Additionally, it has two important features that really make it stand out:

1. It explains the whole set of Microsoft BI tools and MS's vision for BI
2. It explains trends in BI such as how to integrate unstructured data & structured data

The scope of this book is wider than the usual, tool-centric book. That makes it extremely valuable. It's relatively easy to obtain information on tools. It's much more difficult to obtain information on using the right tool for the right job. It's also difficult to obtain simple and comprehensive information on how Microsoft's tools relate to each other.

Finally, this is a great book for many audiences. Both the new and experienced developer community will benefit from the breath of the information. They will also benefit by seeing how the MS BI tools relate to each other and to glimpsing Microsoft's BI vision.
These last two features, tool integration and vision, make this a great book for the IT manager or executive. It provides them an overview of Microsoft BI and also provides additional material to pursue that overview.
Was this review helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!


Look for similar items by category


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges