Delivering Business Intelligence with Microsoft SQL Server 2016 (4th Edition)

Description

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.

Key Features

• 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

Table of Contents

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

Author Biography

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.