Larson B. Delivering Business Intelligence with MS SQL Server 2016

Fourth Edition. — McGraw-Hill Education, 2017. —1030 p. — ISBN: 978-1-259-64149-7Drive 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 environmentPart I Business Intelligence
Equipping the Organization for Effective Decision Making
Making the Most of What You’ve Got: Using Business Intelligence
Seeking the Source: The Source of Business Intelligence
Two, Two, Two Models in One: The BI Semantic Model
First Steps: Beginning the Development of Business Intelligence
Part II Defining Business Intelligence Structures
Building Foundations: Creating Data Marts
Transformers: Integration Services Structure and Components
Fill ’er Up: Using Integration Services for Populating Data Marts
Part III Working with a Tabular BI Semantic Model
Setting the Table: Creating a Tabular BI Semantic Model
A Fancy Table: Tabular BI Semantic Model Advanced Features
Part IV Working with a Multidimensional BI Semantic Model
Cubism: Measures and Dimensions
Bells and Whistles: Special Features of OLAP Cubes
Writing a New Script: MDX Scripting
Pulling It Out and Building It Up: MDX Queries
Part V Modeling and Visualizing with Power BI
Power to the People: Loading Data with Power BI
I Can See Clearly Now: Data Visualization with Power BI Reporting
Part VI Delivering
Special Delivery: Microsoft Business Intelligence Client Tools
Let’s Get Together: Integrating Business Intelligence with Your Applications