Which SharePoint business intelligence tool is right for you?
By Tavis Lovell
December 19, 2012 —
(Page 1 of 3)
Choosing the right business intelligence tool for an organization can be tricky. There are several dashboard and reporting solutions available in SharePoint, and picking the right tool(s) to satisfy an organization’s business intelligence goals isn’t always as cut and dry as some would hope. A good starting point is to identify what the options are, and understand what they offer at a high level. With that in mind, let’s take a look at the four most popular business intelligence reporting solutions in SharePoint, and what they have to offer.
Reports developed with Microsoft SQL Server Reporting Services (SSRS) are highly customizable, and that flexibility makes them a great fit for a variety of scenarios. While most commonly used for “Operational” or “Static” reporting, it also has a wide array of visuals, including charts, gauges, indicators, and maps that also allow it to function very effectively as a dashboard tool.
Integrating Reporting Services with your SharePoint environment allows reports and dashboards to be deployed directly to SharePoint document libraries. Once deployed, reports can be viewed via the Report Viewer Web Parts, or by navigating to them directly. If you need tight control over your report formatting and layout, there’s a good chance Reporting Services will be a good fit for you.
• Great for reporting and dashboards
• High level of control over format/layout
• Can connect to a wide range of data sources
• Report development will most likely require a technical resource
• Highly scalable
Many of us have some familiarity working with data using Excel. The great thing about Excel Services is that now you can use a tool you’re already familiar with (Excel) to create reports that you can then publish in SharePoint. Excel Services takes care of all the rendering of the Excel document inside the browser, so that the person viewing your published Excel report doesn’t even need to have Excel installed on his or her computer.
If you already have reports in Excel, this is an excellent opportunity to drive traffic to SharePoint to view them instead of using a file share or e-mailing them out. Security can also be applied to each workbook, allowing you to only share the specific sections of your workbook you want to be visible. If your organization is just getting started with business intelligence, this is a good place to begin your journey so you can get up and running fast.
Share this link:
Dell Software Offers Tips for Empowering Business Users to Embrace DIY SharePoint Customization
A DIY solution enabling users to make their own customizations is crucial to drive SharePoint adoption and strategic projects
AvePoint Enhances Business Productivity with New Versions of SharePoint Apps
AvePoint Meetings and Task & Calendar Sync productivity apps now support Microsoft SharePoint 2013, online and on-premise
Customizing SharePoint Online Using SharePoint Designer, Part 1
Once you get a handle on SharePoint Online, the question becomes: How can I modify it to suit my needs. First of two parts.
This site's content Copyright © 1999 - 2014 by BZ Media LLC, All rights reserved.
Legal and Privacy
Phone: +1 (631) 421-4158 • E-mail: