Delivering Business Intelligence with Microsoft SQL Server 2012 3/E
3rd Edition
Will be published approx. on 16. May 2012
Book
Paperback/Softback
832 pages
978-0-07-175938-0 (ISBN)
Description
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Implement a Robust BI Solution with Microsoft SQL Server 2012Equip 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
Implement a Robust BI Solution with Microsoft SQL Server 2012Equip 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
More details
Edition
3rd edition
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
25 Illustrations
Dimensions
Height: 229 mm
Width: 185 mm
Thickness: 38 mm
Weight
1407 gr
ISBN-13
978-0-07-175938-0 (9780071759380)
Schweitzer Classification
Other editions
New editions
Book
11/2016
4th Edition
McGraw-Hill Education
€56.20
Shipment within 15-20 days
Person
Brian Larson (Arden Hills, MN) served as a contract member of the Reporting Services development team and contributed to the code base. He has contributed to SQL Server Magazine and is the Chief of Technology for Superior Consulting Services. With over 18 years of experience in the computer industry, and 14 years as a software development consultant, Brian is an MCSD as well as an MCDBA, and has authored and delivered training curriculum for SQL Server 2000 and C#.NET as well as numerous custom applications.
Content
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
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