» » Foundations of SQL Server 2008 R2 Business Intelligence (Expert's Voice in SQL Server)

Free eBook Foundations of SQL Server 2008 R2 Business Intelligence (Expert's Voice in SQL Server) download

by Guy Fouche,Lynn Langit

Free eBook Foundations of SQL Server 2008 R2 Business Intelligence (Expert's Voice in SQL Server) download ISBN: 1430233249
Author: Guy Fouche,Lynn Langit
Publisher: Apress; 2nd ed. edition (April 1, 2011)
Language: English
Pages: 448
Category: Technologies and Future
Subcategory: Computer Science
Size MP3: 1669 mb
Size FLAC: 1432 mb
Rating: 4.7
Format: azw doc txt rtf


FREE shipping on qualifying offers. It is always a joy reading books from APRESS mostly because the authors are subject matter experts and offer hands-on expertise.

FREE shipping on qualifying offers. Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. It’s a complete business intelligence (BI) platform. The database is at its core. The content is helpful and well laid out from ground up for anyone who needs to know about SQL Server 2008 R2 from a BI perspective.

SQL Server 2008 puts an incredible amount of BI functionality at your disposal. Also provided are clear examples of predictive analysis made possible through powerful data mining features in SQL Server. But how do you take advantage of it? That’s what this book is all about. If you’re an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you can’t afford to be without this book; you can’t afford to ignore the powerful business intelligence suite that Microsoft has placed at your disposal. Provides the "big picture" of Microsoft’s BI tool suite.

Guy Fouché, Lynn Langit. Foundations of SQL Server 2008 R2 Business Intelligence introduces the exciting gamut of business intelligence tools included with SQL Server 2008. Its a complete business intelligence (BI) platform. The database is at the core, and surrounding the database are tools for data mining, modeling, reporting, analyzing, charting, and integration with other, enterprise-level software packages. SQL Server 2008 puts an incredibl. ONTINUE READING.

About this book But how do you take advantage of it? That’s what this book is all about.

Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Authors Guy Fouché and Lynn Langit show how to implement end-to-end BI solutions using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and other tools in the Microsoft business intelligence toolkit.

Microsoft has designed SQL Server 2008 to be more than just a database

Microsoft has designed SQL Server 2008 to be more than just a database. SQL Server 2008 puts an incredible amount of BI functionality at your disposal. Authors Guy Fouch and Lynn Langit show how to implement end-to-end BI solutions using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and other tools in the Microsoft BI toolkit.

19 results for sql server 2008 business intelligence. Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Of.

Microsoft has designed SQL Server 2008 to be more than just a database. It's a complete business intelligence (BI) platform.

Автор: Fouche G Название: Foundations of SQL Server 2008 R2 Business Intelligence Издательство: Springer .

Описание: This book will help DBAs and business intelligence architects work with the latest 3-D visualization techniques that revolutionize data reporting, analysis, and measurement in SQL Server 2008.

This past week we released SQL Server 2008 R2 to manufacturing. Donald Farmer, he of the BI fame, has been on a roll lately. He and I have something of a competition going most of the time, but it’s a friendly competition.

Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. It’s a complete business intelligence (BI) platform. The database is at its core, and surrounding the core are tools for data mining, modeling, reporting, analyzing, charting, and integration with other enterprise-level software packages.

SQL Server 2008 puts an incredible amount of BI functionality at your disposal. But how do you take advantage of it? That’s what this book is all about. Authors Guy Fouché and Lynn Langit show how to implement end-to-end BI solutions using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and other tools in the Microsoft business intelligence toolkit. You’ll learn about all-features such as PowerPivot and Report Builder 3.0. Also provided are clear examples of predictive analysis made possible through powerful data mining features in SQL Server.

If you’re an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you can’t afford to be without this book; you can’t afford to ignore the powerful business intelligence suite that Microsoft has placed at your disposal.

Provides the "big picture" of Microsoft’s BI tool suite Covers PowerPivot and other game-changing technologies introduced alongside SQL Server 2008 Release 2 Gives a practical analysis of features based on real-world practices
User reviews
MisterMax
It is always a joy reading books from APRESS mostly because the authors are subject matter experts and offer hands-on expertise. The content is helpful and well laid out from ground up for anyone who needs to know about SQL Server 2008 R2 from a BI perspective. The first five chapters lay framework to an understanding of schemas, dimensions and modeling theory. The book offers thorough insight of star, snow flake schemas, Slow Changing (SCD) Dimensions, Rapid Changing (RCD) Dimensions, KPIs, Calculated and Derived Measures. The authors do a good job with listing examples using the AdventureWorks database which is accessible to everyone with ample screen shots to make it a step-by-step guide.

The middle section of this book talks in detail about designing and deploying SSIS, SSAS packages to support enterprise ETL processes, types of data transformation techniques along with pros and cons of each storage model. SSIS has been covered in detail spanning three chapters with everything needed to implement it including industry's state of the art logging and security standards.

Lastly, the book delves into data mining, reporting (SSRS) services concepts and using MDX/DMX to query cube information that's created based on the principles laid out in earlier chapters and illustrates use of traditional pivot tables and new "Power Pivot" feature within Microsoft Excel 2010 available as a free plug-in and offers tight integration with SQL Server 2008 R2 data mining capabilities.

I will highly recommend it to anyone looking to get up and running quickly or exploring BI offering from Microsoft having read most of the "SQL Server Online Books" as it's one of the good "foundation" books available in market I have run into that blends field experience in an easy to digest format.
Amhirishes
If you need a book, that will give you an excellent foundation that will follow you, if you ever decided to be a BI (Business Intelligence) expert.

Well this is the book for you. This book contains all that you need to get started and use BI, using SQL Server 2008 R2. It contains all that you need to get started. Everything is already layout for your success in the BI arena. This book is intended for advance users as a refresher to solidify your foundation. I have heard like 7 speeches of Lynn Langit for the past 4 years and she is very enthusiastic with regards to what she is doing in Microsoft. She really knows what she is saying. This being said, this book is definitely a book to keep as a professional in the BI arena. This book has only 427 pages but every page is important in understanding the subject matter. It does not contain anything extra. This is a serious book to read for serious BI professional. I have learned a lot from this book and it is worth the $49.99 price tag.

Happy reading Lawrence Matias
ARE
This book is pretty good at explaining how to use the Microsoft BI toolset, including SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Data Mining. I am glad I read it and wholeheartedly recommend it to anyone who is working with SQL Server. It provides ample examples for working with these products and it also delves into Report Builder, Excel, PowerPivot, and MDX. I like the organization of the book and the path it takes in discussing the different tools. The first subject it discusses is OLAP which is the subject that most readers probably are most interested in. So once you have a better understanding of OLAP and how SQL Server can address the subject area, then it moves on to using the other BI tools. The only thing I did not like about the book was that it does not cover Report Builder 3.0. It looks like a previous version of Report Builder. But, as far as I am concerned, that is ok, because I do not plan on using Report Builder. It also omits any discussion of shared datasets which are introduced by SQL Server 2008 R2 and it does not warn about updating the properties under certain situations (such as when deploying reports) when using SQL Server 2008 R2.