Business Intelligence:Current State of the ArtJoe HomnickMicrosoft Regional Director

MeetUp: http://aka.ms/gcug

SQL Server 2016

Visualization

Modeling

Power BI

Tabular Multidimensional

ON-PREMISES CLOUD

Mobile and paginated reports

Pin paginated report items to

Power BI dashboards

Access

on-premises data

Power BI

• Power BI Desktop

• Microsoft Excel

• Mobile reports

• Paginated reports

DELIVER

CLOUD

PIN PAGINATED REPORT ITEMS

SQL Server Reporting Services

• Power BI Desktop

• Mobile reports

• Paginated reports

ON-PREMISES

Power BI Web Portal

CONSUME

ONE SET OF MOBILE APPS

Windows App

Android App

iOS App

Web portal

SharePointEMBED

SQL Server Report Builder

Power BI Desktop

POWER BI REPORTS

ANALYZE & AUTHOR

ANALYTICAL REPORTS

Microsoft Excel

MOBILE REPORTS

SQL Server

Mobile Report Publisher

PAGINATED REPORTS

Report Designer inSQL Server Data Tools

Pin paginated report items

to Power BI dashboards

CONSUME

SharePoint

Web portal(paginated and mobile reports)

iOS App

Android App

Windows Phone App

ONE SET OF MOBILE APPS

SQL Server

Reporting Services

Native mode

Mobile Reports now a

component of SSRS

DELIVER

SQL Server 2016 Reporting Services

SQL Server

Reporting Services

SharePoint

integrated mode

MOBILE REPORTS

ANALYZE & AUTHOR

SQL Server

Mobile Report Publisher

PAGINATED REPORTS

SQL Server Report Builder

Report Designer inSQL Server Data Tools

SQL Server 2016

Enhanced analysis

Modern reports

Rich tools

Mobile reports

Hybrid BISharePoint 2016 support

Reporting Services

SQL Server Reporting Services

Paginated reportsDesign beautiful documents using updated

tools and new features

Mobile reportsCreate responsive, interactive reports

optimized for mobile devices

New web portal Consume both types of reports in one web

portal using modern browsers

Modern paginated reports

Modern chart and gauge styles

Updated Report Builder

look-and-feel

Visual Studio 2015 support

Plugin-free printing

Customizable parameter layout

Export to PowerPoint

Generate slides including all report

content in seconds

Move and resize individual objects

Export manually, schedule for

email delivery, or generate

programmatically

Pin report items to Power BI dashboards

Monitor the most important

metrics and trends in one place

Pin charts, gauges, maps,

and images as tiles to

Power BI dashboards

Pin report items to Power BI dashboards

Monitor the most important

metrics and trends in one place

Pin charts, gauges, maps,

and images as tiles to

Power BI dashboards

Pin report items to Power BI dashboards

Monitor the most important

metrics and trends in one place

Pin charts, gauges, maps,

and images as tiles to

Power BI dashboards

Create interactive mobile reportsResponsive experiences for phones and tablets

Consume mobile reportsNative apps for all major mobile platforms

One mobile app for Power BI and

SSRS mobile reports

Native mobile experience

optimized for touch

Keep data up-to-date with real-time

query or scheduled data refresh

Interact with mobile reports even

when disconnected

New, modern web portal for reports

Web APIs

Report server

database

Web portalWeb browsers

Power BI Mobile

Report Builder

Mobile Report Publisher

Visual Studio

SQL ServerSQL Server

Analysis Services

Oracle Teradata

ODBC, OLE DB More/custom

Processing and

rendering

Scheduling and

delivery

Email File share

SharePoint Power BI

Custom

REPORT VIEWING (PCs, mobile)

REPORT DESIGN (PCs)

REPORT SERVER DATA SOURCES

REPORT DELIVERY DESTINATIONS

Custom apps/LOB

SQL Server Analysis Services 2016

Easily create models

IT pro

Increase adoption

Business analyst

Share insights faster

Faster timeto insight

BI consumers

Analysis Services as the BI semantic modelEasily abstract business problems to gain insights

Dimensions and measure groups

Highly scalable and mature

Feature rich and complex

Multidimensional models

Tables and relationships

Fast by design with in-memory

Easy to get started and simple

Tabular models

One semantic model - two ways to build:

BI SEMANTIC MODEL

Data access

Use SQL Server data tools for Visual Studio to create BI semantic models

DATA SOURCES

SQL Server Analysis ServicesCLIENT TOOLS

Data model

Business logic

Queries

MDX Query

DAX Query

Direct access without moving data

Improved diagram view layout

Simplified scripting for tabular models

{"name": "Demo Model","description": "Demo model description","culture": "en-US","dataSources": [....],"tables": [

{"name": "Customer","description": "Customer information.","columns": [

{"name": "ID","dataType": "int64","sourceColumn": "customer_id","sortByColumn": "Last Name"

},

Tabular scripting language

Developing tabular models

public void RefreshTable(){

var server = new Server();server.Connect(ServerConnectionString); //Connect to the server.Database Db = server.Databases["TMDB"];//Connect to the DBModel m = Db.Model; //Get the model//Mark the Sales table to be refreshed.m.Tables["Sales"].Refresh(RefreshType.Full);m.SaveChanges(); //Commit the changes

}Column(s)

Measure(s)

Table(s)

Model

Database

[Placeholder title]

Multidimensional model enhancements

Visualize and explore existing models

with Power BI and Power BI Desktop

Drill-through multi-selection support

with Excel 2016

Multidimensional cube

Simplified setup experience with single

SQL Server Data Tools for Visual Studio

2015

Check for corruption issues on

database or individual objects with

DBCC support for Analysis Services

Diagnose problems with xEvents, a light-

weigh tracing and performance

monitoring system in SQL Server

Management Studio

Dev / Ops in SQL Server 2016

People, process and the right tools

OPSDEV

Access on-premises data any

way you like:

Scheduled refresh

Live connection

Connect to on-premises SQL

Server Analysis Services models:

Tabular and multidimensional

Cloud

On-premises

Connect to on-premises data from Power BI

Cloud

On-premises

Power BI gateway for personal use

Keep data in Power BI up to date

using scheduled refresh

Anyone can refresh –

no IT dependency

Support for a large number of

data sources

Easy to use with a desktop-based

lightweight one-click installer

Cloud

On-premises

Power BI Gateway for enterprise deployments

Centralized way to refresh

on-premises data in Power BI

Control access to

data sources

Monitor gateways and data

sources

Live, interactive query with

on-premises data sources

COMINGSOON

Enhancements for SharePoint BI

Edit mode for PowerPivot workbooks

Support for Excel 2016 workbooks

Scheduled data refresh for Power Query

connections

New chart types, HTML5 rendering, plugin-free

printing, export to PPT, and updated Report Builder

Business Intelligence:Current State of the ArtJoe HomnickMicrosoft Regional Director

MeetUp: http://aka.ms/gcug