B.I. the way...

SharePoint Business Intelligence Blog

Report Building with Excel Services

Report Building with Excel Services

  • Comments 4
  • Likes

One of the most useful features of Excel Services is report building. Reports can include business intelligence data or any type of data you are working with in Excel Services. Generating and publishing Excel Services reports is one of the basic parts of a dashboard.

Excel Services reports function very much like Excel workbooks and can appear similarly when you view them, whether you view an Excel workbook on your computer or in a SharePoint document library. Excel Services reports can include a variety of standard Excel features and functionality, such as conditional formatting, formulas, and charts. When you publish an Excel workbook to Excel Services, your workbook becomes the data source for an Excel Services report type in the Dashboard Designer. Creating any type of Excel Services report is a two step process. You begin by using the wizard to create the basic report structure. Then you can select the data to display in the report.

There are several white papers available for creating various types of reports within Excel Services:

·         Building a Report Based on Cube Functions for Excel Web Access

·         Building an OLAP PivotTable Report with Excel Services

·         Building a Relational PivotTable Report with Excel Services

·         Building a Report with a Chart for Excel Web Access Based on Cube Functions


  • Excel 2007 really opened the doors to making some custom and very professional dashboard reports.


    <a href="www.oneclickcommissions.com/excel-reports.html">Excel Reports</a>

  • The article is very helpful! Thank you, I'll be sure to use your advice. Personally, I had some problems converting excel files over to PDF. I got so annoyed from manually moving the information (such as commission reports, invoices, etc.) over to another document, but then I found this program at my work that quickly and painlessly converts my excel documents into PDF and ready to go templates and reports, saving me aggravating hours upon hours. It provides my business a simple way to make individualized statements for our business associates, taking our invoices and seamlessly placing the information in the awesome templates. Check it out here: www.nirvaha.com/excel-to-pdf.html

  • This has been very helpful! Heres one more place where I came across the sure fire benefits of excel reporting: www.excelreports.info/reports-in-excel

  • Excel is quite useful tool for day-to-day analysis. But if you need advanced predictions and pattern recognition it would not be enough.

    More BI services based on the latest technologies www.scnsoft.com/.../business-intelligence

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment