Delivering Business Intelligence with Microsoft SQL Server 2012 3E / Edition 3

Delivering Business Intelligence with Microsoft SQL Server 2012 3E / Edition 3

by Brian Larson
     
 

View All Available Formats & Editions

ISBN-10: 0071759387

ISBN-13: 9780071759380

Pub. Date: 04/09/2012

Publisher: McGraw-Hill Professional Publishing

Implement a Robust BI Solution with Microsoft SQL Server 2012

Equip your organization for informed, timely decision making using the expert tips and best practices in this practical guide. Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition explains how to effectively develop, customize, and distribute meaningful information to

Overview

Implement a Robust BI Solution with Microsoft SQL Server 2012

Equip your organization for informed, timely decision making using the expert tips and best practices in 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
  • Create KPIs and digital dashboards
  • Use data mining to identify patterns, correlations, and clusters
  • Implement time-based analytics
  • Embed BI reports in custom applications using ADOMD.NET

Product Details

ISBN-13:
9780071759380
Publisher:
McGraw-Hill Professional Publishing
Publication date:
04/09/2012
Edition description:
List
Pages:
832
Sales rank:
577,264
Product dimensions:
7.30(w) x 9.10(h) x 1.60(d)

Related Subjects

Table of 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 Service 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—Introduction to Data Mining

Chapter 16. Building the Mine—Working with the Data Mining Model

Chapter 17. Spelunking—Exploration Using Data Mining

Part VI: Delivering

Chapter 18. Special Delivery—Microsoft Business Intelligence Client Tools

Chapter 19. Let's Get Together—Integrating Business Intelligence with Your Applications

Index

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >