Business Intelligence with SharePoint

•    SharePoint -  Excel Service , Visio Service, PerformancePoint Service
•    Microsoft Excel – Excel, Power view, PowerPivot
•    SQL Server – Integration with the SQL Reporting Service
•    Third Party Tool – Power BI 

Comparison Business Intelligence Capabilities in Different Microsoft SharePoint Environments  

Feature	SharePoint On-Premise	SharePoint Online Plan 1	SharePoint Online Plan 2
BI Center	Yes	No	Yes
Excel Services	Yes	No	Yes, if the workbook size less than 10 MB
Visio Services	Yes	No	Yes
PerformancePoint Services	Yes	No	No
PerformancePoint Services (PPS) Dashboard Migration	Yes	No	No
Power View for Excel in SharePoint	Yes	No	Yes
PowerPivot for Excel in SharePoint	Yes	No	Yes
Scorecards & Dashboards	Yes	No	No
PivotTables and Pivot Charts	Yes	No	Yes
Filter Enhancements and Filter Search	Yes	No	Yes
Schedule Data Refresh	Yes	No	No
Usage Monitoring	Yes	No	Yes
Reporting Services integration With SQL	Yes	No	No

Moreover we can use Power BI (Payable app) for office 365.It provides below features.

• Can create BI sites and called them as “Power BI sites”.
• Provide data stewardship and query sharing and management.
• Can schedule Data Refresh.
• Provide Natural Language Query (Q&A).-(not provide in any other environments)
• Provide predictive forecasting.(not provide in any other environments)
• View Microsoft Excel workbooks in a browser.( if the workbook size less than 250 MB)
• Usage Monitoring.
• Cannot use for Excel Power view and PowerPivot workbooks.

References
https://msdn.microsoft.com/en-us/library/dn877942%28v=sql.120%29.aspx
https://technet.microsoft.com/en-us/library/sharepoint-online-service-description.aspx#bkmk_tablespo
http://www.sharepoint.co.il/sites/share-point/UserContent/files/Appendix_B.pdf
https://msdn.microsoft.com/en-us/library/dn877942%28v=sql.120%29.aspx