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

Importing Images Into SharePoint User Profiles My Sites

To make the user images that we have uploaded into the thumbnail Photo attribute in Active Directory available in SharePoint we will first need to map it to the Picture property in the User Profile Service Application.

1. Firstly you will need to go into the User Profile Service Application.Central Admin > Application Management > Service Applications > Manage Service Applications > User Profile Service Application.
2. Then you will need to go into the Manage User Properties section and edit the Picture property. 
3. Next we will map the Active Directory property thumbnail Photo to the Picture property in SharePoint.
4. Once the mapping has been applied the Manage User Properties page will look like this.
5. Now we will need to run a Full User Profile Synchronization job so that SharePoint can import the user images from Active Directory Synchronization > Start Profile Synchronization > Start Full Synchronization.
6. Lastly we will need to force SharePoint to update the User Profile Database - This will create the thumbnails that are used in My Sites and the User Profile Service. This will need to be run in the SharePoint PowerShell Console with the appropriate My Site permissions.

Reference: Import-user-profile-photos-from-active-directory-into-sharepoint-2010