Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition

Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition

by Brian Larson

Paperback(4th ed.)

$45.00 $50.00 Save 10% Current price is $45, Original price is $50. You Save 10%.
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Wednesday, September 25


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.

Distribute Actionable, Timely BI with Microsoft® SQL Server® 2016 and Power BI

Drive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, shows, step-by-step, how to distribute high-performance, custom analytics to users enterprise-wide. Discover how to build BI Semantic Models, create data marts and OLAP cubes, write MDX and DAX scripts, and share insights using Microsoft client tools. The book includes coverage of self-service business intelligence with Power BI.

• Understand the goals and components of successful BI
• Build data marts, OLAP cubes, and Tabular models
• 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
• Implement time-based analytics
• Embed data model content in custom applications using ADOMD.NET
• Use Power BI to gather, model, and visualize data in a self-service environment

Product Details

ISBN-13: 9781259641480
Publisher: McGraw-Hill Professional Publishing
Publication date: 11/02/2016
Edition description: 4th ed.
Pages: 880
Product dimensions: 7.20(w) x 9.10(h) x 1.70(d)

About the Author

Brian Larson (Arden Hills, MN), MCSD, served as a member of the Reporting Services development team on a contract basis, and has contributed to the code base. He is the Chief Creative Officer for Superior Consulting Services (SCS) in the Twin Cities. SCS is a Microsoft Certified Partner and is currently developing many client solutions that use Microsoft BI tools. Brian has been invited to speak on BI topics at several conferences including the PASS Summit, is a SQL Server Pro IdeaXchange Xpert, and has written articles and produced training videos for SQL Server Magazine.

Table of Contents

Part 1: 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 for the Source—The Source of Business Intelligence
Chapter 4: Two, Two, Two Model in One—The BI Semantic Model
Chapter 5: First Steps—Beginning the Development of Business Intelligence
Part 2: Defining Business Intelligence Structures
Chapter 6: Building Foundations—Creating the Data Marts
Chapter 7: Transformers—Integration Services Structure and Components
Chapter 8: Fill'er Up—Using Integration Services for Populating Data Marts
Part 3: Working with a Tabular BI Semantic Model
Chapter 9: Setting the Table—Creating a Tabular BI Semantic Model
Chapter 10: A Fancy Table—Tabular BI Semantic Model Advanced Features
Part 4: Working with a Multidimensional BI Semantic Model
Chapter 11: Cubism—Measures and Dimensions
Chapter 12: Bells and Whistles—Special Features of OLAP Cubes
Chapter 13: Writing a New Script—MDX Scripting
Chapter 14: Pulling It Out and Building It Up—MDX Queries
Part 5: Modeling and Visualization with Power BI
Chapter 15: Power BI Modeling
Chapter 16: Power BI Reporting
Part 6: Delivering
Chapter 17: Special Delivery—Microsoft Business Intelligence Client Tools
Chapter 18: Let's Get Together—Integrating Business Intelligence with Your Applications

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews