BI in Excel and Excel Services

Business intelligence (BI) is all about bringing together data and turning it into meaningful information that people can use to make better business decisions. Just in case you didn’t already know, Excel 2013 includes a lot of exciting new BI capabilities, such as the following: Timeline controls that enable people to view information for a range…

1

​Microsoft BI Solution Builder: Business Intelligence tools and capabilities are available

Recently, Microsoft released the BI Solution Builder (http://bisolutionbuilder.com), an online tool that you can use to find out what business intelligence capabilities are available to you based on what your organization currently owns. It’s quick and easy to use, and it can help you put your BI environment to work in short order. For example,…

1

Extra! Extra! Apple iPad Users Can Now View SharePoint Business Intelligence Content

In the recent blog post, December 2011 CU for SharePoint 2010 has been released, Senior Escalation Engineer for SharePoint Stefan Goßner provides an overview of Cumulative Update 2011-12 (CU 2011-12) for SharePoint Server 2010 (thanks, Stefan!). For SharePoint business intelligence users, CU 2011-12 for Microsoft SharePoint Server 2010 is particularly exciting because it opens the…

7

Use Excel and PowerPivot for Excel to analyze SQL Server Analysis Services data

Analyzing data that you import from an external source such as SQL Server Analysis Services (SSAS) can be complicated.  The Microsoft TechNet article, Analyze data from SQL Server Analysis Services explains how to use Excel or PowerPivot for Excel to analyze this data. This newly published article includes three sections: Analyzing data in Excel 2010…

0

Excel Services 2010 Data Refresh Flowchart: What is going on behind the scenes

Correctly configuring the data refresh in Excel Services in Microsoft SharePoint Server 2010 can be challenging.  You need to make sure that Excel Services data is available to only those authorized while ensuring an incident free refresh of the data when opening a workbook. It is helpful to know what is going on behind the…

0