Choosing Microsoft Business Intelligence (BI) Tools for Analysis and Reporting

Choosing Microsoft Business Intelligence (BI) Tools for Analysis and Reporting

 

Applies To: SQL Server 2016 Preview

The following table maps workloads for data analysis and reporting to the Microsoft BI tools that are best suited for those workloads. The intent is to help you choose the tool that best meets your needs. For more information about a product, click the product link in the table.

If you’re looking for a brief overview of these tools to help you decide which tools are right for you, see Introducing Microsoft Business Intelligence (BI) Tools.

Workloads

User

BI Tools

Excel

SharePoint

SharePoint Online

Power BI

SQL Server

Self-Service BI

Analyst/End User

Easily discover, and access public and corporate data

Excel 2016

Data Catalog

Create powerful data models

Power Pivot

Perform self-service predictive analytics

Data Mining Add-Ins for Excel (Excel 2016 supported)

Visualize and explore data

Power View

3D Maps

Ask questions using natural language query

Q & A

Access reports using mobile devices

HTML 5 (supports viewing <10MB files)

HTML 5 (supports viewing <250MB)

Power BI apps for mobile devices

Collaborate and share

SharePoint Sites

SharePoint Team Sites

BI Center site

Corporate BI

IT Pro

Create multi-dimensional/tabular corporate models

Analysis Services

Create ad-hoc data visualizations

Power View for SharePoint

Create dashboards

SharePoint Dashboards

PerformancePoint Services

Create operational reports

1Reporting Services

Create custom and embedded reports

1Reporting Services

Advanced Analytics

Data Scientist

Perform self-service predictive analytics

Data Mining Add-Ins for Excel (Excel 2016 supported)

Use data mining algorithms

Data Mining in Analysis Services

1 Reporting Services has a number features that support delivering modern, paginated reports.

Community Additions

ADD
Show:
© 2016 Microsoft