Below is the list of some enhanced BI features in SP 2013. The information is taken from Share Point forum.
Excel BI
Excel BI offers certain new features to support business
intelligence applications.
These include the following:
In-Memory BI Engine (IMBI): The In Memory multidimensional
data analysis engine (IMBI), also known as the Vertipaq engine, allows for
almost instant analysis of millions of rows and is a fully integrated feature
in the Excel client.
Power View Add-in for Excel: Power View
("Crescent") enables users to visualize and interact with modeled
data by using highly interactive visualizations, animations and smart
querying.. Users can present and share insights with others through rich
storyboard presentation capabilities. PowerView is powered by the BI Semantic
Model and the VertiPaq engine.
Decoupled PivotChart and PivotTable reports: Users can now
create PivotChart reports without having to include a PivotTable report on the
same page.
Excel Services
Excel Services offers certain new features to support
business intelligence applications. These include the following:
Calculated measures and members: Excel Services supports
calculated measures and calculated members that are created in Excel.
Enhanced timeline controls: Excel Services supports timeline
controls that render and behave as they do in the Excel client.
Application BI Servers: Administrators can specify SQL
Server Analysis Services servers to support more advanced analytic capabilities
in Excel Services.
Business Intelligence Center update: The Business
Intelligence Center site template has been streamlined. It not only has a new
look, it is easier to use.
Data exploration improvements: People can more easily
explore data and conduct analysis in Excel Services reports that use SQL Server
Analysis Services data or PowerPivot data models. For example, users can point
to a value in a PivotChart or PivotTable report and see suggested ways to view
additional information. Users can also use commands such as Drill Down To to
conduct analysis. Users can also apply the Drill Down command by using a single
mouse click.
Field list and field well support: Excel Services enables
people to easily view and change which items are displayed in rows, columns,
values, and filters in PivotChart reports and PivotTable reports that have been
published to Excel Services.
PerformancePoint
Services
PerformancePoint Services offers certain new features to
support business intelligence applications. These include the following:
BI Center Update: The new BI Center is cleaner, and easier
to use with folders and libraries configured for easy use.
Support for Analysis Services Effective User: This new
feature eliminates the need for Kerberos delegation when per-user
authentication is used for Analysis Services data sources. By supporting
Analysis Services Effective User feature, authorization checks will be based on
the user specified by the EffectiveUserName property instead of using the
currently authenticated user.
PerformancePoint Support on iPad: PerformancePoint
dashboards can now be viewed and interacted with on iPad devices using the
Safari web browser.
Dashboard Migration: Users will be able to copy entire
dashboards and dependencies, including the .aspx file, to other users, servers,
or site collections. This feature also allows the ability to migrate single
items to other environments and migrate content by using Windows PowerShell
commands.
Filter Enhancements & Filter Search: The UI has been
enhanced to allow users to easily view and manage filters including giving
users the ability to search for items within filters without having to navigate
through the tree.
Visio Services
Visio Services offers some new features
Maximum Cache Size: A new service parameter, it is located
on the Central Admininstration Visio Graphics Service Application Global
Settings page. The default value is 5120 MB.
Health Analyzer rules: New corresponding Health Analyzer
rules have been added to reflect the new Maximum Cache Size parameter.
Updated Windows PowerShell cmdlets, Set-SPVisioPerformance:
This cmdlet has been updated to include the new Maximum Cache Size parameter.
Commenting on drawings supported: Users can add meaningful
comments to a Visio Drawing (*.vsdx) collaboratively on the web via Visio
Services in full page rendering mode.
We can't compare external lists with standard
lists where data is stored inside of SharePoint. Since the data is stored
outside SharePoint, there are many Limitations in External Lists. Many of the
Ribbon features will not be available for external Lists.