Getting started with business intelligence in the new Office

Reliable business intelligence and insight are the keys to a thriving business. Excel, SharePoint, and Office 365 make in an organization as part of the daily work more for everyone business intelligence (BI) in the new Office.  New and improved features in familiar tools like Excel enable all in one company to easily discover, model, analyze, and visualize data from different sources. With SharePoint all experience levels can jointly develop and share insights on dashboards and scorecards, and this experience continues seamlessly in the cloud with Office 365. For enterprise environments, these functions are further enhanced by SQL Server for higher performance and scalability both locally and in the cloud with BI-azure. Ultimately, everyone in the organization using Microsoft BI, can develop insights that help to make the new discoveries and better and more informed decisions.

Gemini was a popular add-in for Excel 2010, enables hundreds of millions of rows in Excel to create the large data models. In Excel, this feature will reduce the effort for the downloads and installation now natively embedded. PowerPivot is supported in SharePoint with SQL Server Analysis Services where the PowerPivot workbooks largely can be released models in the entire organization. New features such as quick explore help users navigate their data and analysis fast offers preview of your diagrams, charts and scorecards.

Users can:

Combining and analyzing large data sets with PowerPivotSummarize data and discover trends with quick ExploreInstantly preview charts and pivot tables with fast analysis

Introducing SQL Server 2012, power view provides a canvas to create Visual dashboards in SharePoint. Now this function in Excel and SharePoint is embedded, so that business users can create stunning reports to share and interact throughout the organization. The field list to the Pan and change the views now supports Excel Services in the browser. We have also extended PerformancePoint services provide additional features such as themes, filter extensions, authentication improvements, new BI Portal and server-side migration.

Users can:

Do browse interactive data with power ViewShare reports with your colleagues with Excel ServicesWork together, make decisions on dashboards with PerformancePoint services from

Self-service BI has often triggered maintain the integrity of the reports and security concerns for it professionals. With the new request tool in Excel and audit and service control manager in SharePoint IT governance teams can manage created more self service BI end user assets. Together, will compare these features help in various versions of the reports and track changes in report libraries to a version of the truth, to ensure your insights.

Users can:

Consolidation and simplification of management with SharePointDiagnose workbooks for errors and track changes by using spreadsheet InquireManage spreadsheet risk within an organization with audit and service control manager

An opportunity that started with Microsoft BI is through our new Microsoft BI solution Builder online-tool, that helps to configure the correct platform for your organization.

Try it out today at: http://www.bisolutionbuilder.com/

Find more resources on the Microsoft BI on the Microsoft Business Intelligence Blog.

BI features supported by Office 365?

With the new updates to Office 365, we support now features such as quick explore, Gemini and power view in SharePoint online for BI scenarios. There are however a few limitations when compared to the in-place environment:

Workbook maximum group size 10MBNo external data RefreshNo PerformancePoint ServicesNo PowerPivot Gallery

Offer information on the full Microsoft cloud BI in the future we will announce.

Are Excel workbooks backwards compatible?

The data model-enabled workbooks in Excel 2013 are not backward-compatible with earlier versions of Excel. Excel 2010 workbooks prompts however the automatic update on Excel 2013 data models when opened in Excel 2013 client for forward compatibility with Gemini models. Excel 2010 workbooks that are stored in SharePoint in which must be Excel-2013 client open and upgrade to the newer model of data in Excel Services in SharePoint 2013 used.

Are BI features in Office home and student RT supported?

On the client side the embedded Excel in Office home and student-RT includes in the delivery of Windows RT, not the most BI features, providing the full Excel 2013 Professional plus client. In particular, PowerPivot, power view is quickly explore and request not available in Office home and student of RT.

On the SharePoint page, most of the functions in the mobile browsers of today's tablets, except the Web parts support the Silverlight as well as PowerPivot Gallery, power views in Excel Services, and decomposition, will require trees in PerformancePoint services.

View the original article here