Delivering Business Intelligence with Microsoft SQL Server 2012

by Brian Larson

About the Book: Delivering Business Intelligence with Microsoft SQL Server 2012: 3rd Edition This practical guide. Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition explains how to effectively develop, customize, and distribute meaningful information to users enterprise-wide. Learn how to build data marts and create BI Semantic Models, work with the MDX and DAX languages, and share insights using Microsoft client tools. Data mining and forecasting are also covered in this comprehensive resource. Understand the goals and components of successful BI Design, deploy, and manage data marts and OLAP cubes Load and cleanse data with SQL Server Integration Services Manipulate and analyze data using MDX and DAX scripts and queries Work with SQL Server Analysis Services and the BI Semantic Model Author interactive reports using SQL Server Data Tools Contents Part I Business Intelligence Chapter 1 Equipping the Organization for Effective Decision Making Chapter 2 Making the Most of What You've Got-Using Business Intelligence Chapter 3 Seeking the Source-The Source of Business Intelligence Chapter 4 Two, Two, Two Models in One-The BI Semantic Model Chapter 5 First Steps-Beginning the Development of Business Intelligence Part II Defining Business Intelligence Structures Chapter 6 Building Foundations-Creating Data Marts Chapter 7 Transformers-Integration Services Structure and Components Chapter 8 Fill 'er Up-Using Integration Services for Populating Data Marts Part III Working with a Multidimensional BI Semantic Model Chapter 9 Cubism-Measures and Dimensions Chapter 10 Bells and Whistles-Special Features of OLAP Cubes Chapter 11 Writing a New Script-MDX Scripting Chapter 12 Pulling It Out and Building It Up-MDX Queries Part IV Working with a Tabular BI Semantic Model Chapter 13 Setting the Table-Creating a Tabular BI Semantic Model Chapter 14 A Fancy Table-Tabular BI Semantic Model Advanced Features Part V Mining Chapter 15 Panning for Gold-Introd

Genres: Bisexual

832 pages, Paperback

Published March 16, 2012

Reviews

[Anna · Rating 4 out of 5]

A very good overview of the entire BI process - from data acquisition to delivering of reports. There are enough details for someone who wants to gate a glimpse of the product and the features. Should have read it a few years ago, though.

[Bradley Woods · Rating 5 out of 5]

Book was extremely helpful in understanding the SSAS side of busines intelligence.