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

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

Decipher the Secure Store Service for Excel Services 2010

Creating and configuring the Secure Store Service for Excel Services in Microsoft SharePoint Server 2010 is often a complicated process. I’ve recently revised the Configure Secure Store Service for Excel Services (SharePoint Server 2010) article on TechNet to provide an easier administrative experience for this process. In Excel Services 2010, the Secure Store Service is…

0

Creating PerformancePoint dashboards using Project Server data

You might have seen the new Business Intelligence Center that is available for Microsoft Project Server 2010. If you haven’t seen it or used it yet, watch this fantastic video that my teammate published. She does an excellent job of introducing you to the Business Intelligence Center and how it relates to Project Server. Video:…

0

Data in the cloud! DataMarket Add-In for Excel and Excel Services

There are some exciting things happening around Microsoft cloud services. One of the services is Windows Azure marketplace DataMarket, a cloud service that helps end users who need data for business analysis and decision making. You can conveniently consume the data you subscribe to directly in such Microsoft Office applications as Microsoft Excel 2010 and…

0

White paper update: Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products

In July, we published a white paper on how to configure Kerberos authentication end-to-end in several SQL Server and SharePoint 2010 business intelligence environments. The overview of this white paper is in the TechNet article here. We have updated the white paper in the following ways: Additional information regarding Kerberos constrained delegation and protocol transitioning. Additional information regarding Kerberos token…

0

Three integrated business intelligence solutions

The following is a summary of recently published business intelligence solutions and the corresponding solution download link. The solutions include Microsoft Office, SharePoint 2010, and SQL Server 2008. Self-Service Analytics: Sales Solution This business intelligence (BI) solution scenario describes the steps that employees of the fictional company Contoso take as they analyze sales and promotions data and share that…

0

Excel Services and Excel Web App: Common features, different features

Excel Services extends the Excel desktop experience to the Web and is built upon a server-hosted version of the Excel calculation engine. Advantages include enabling users to interact with Excel workbooks directly in their web browser, without having to have the Excel client installed on a client computer. This increases the overall reach and use-case…

1

How to create planning solutions and scenarios using Office 2010, SharePoint Server 2010, and SQL Server 2008 R2

For a detailed look at understanding planning solutions using Office 2010, SharePoint Server 2010 and SQL 2008 R2, check out this white paper, “Planning, Budgeting & Forecasting for the Office of Finance: Understanding Planning Solutions and Scenarios with Microsoft Office 2010, Microsoft SharePoint Server 2010 and Microsoft SQL Server 2008 R2”.  Many companies still rely…

2

Excel Web App

The Excel product team is offering the new Excel Web App as part of the browser-based Microsoft Office Web Apps. The Excel Web App is a companion to the Excel client, and it provides users with the ability to create, view, edit, and collaborate on Excel workbooks in several supported browsers.   The following excellent posts…

0