BI with SharePoint 2010

Email | Print

SharePoint 2010 offers a wide range of business intelligence solutions, most of which are bundled under the Insights capability. Like much of the rest of SharePoint, Insights makes use of a number of other Microsoft technologies through SharePoint’s Business Connectivity Services, including Excel workbooks, Visio Diagrams, and SQL Reporting Services reports, and external lists.

 A company I recently worked with was using Microsoft Dynamics GP for their ERP solution and wanted to use SharePoint for reporting. Thankfully, Dynamics GP offers data cubes in Analysis Services for Excel. It took just a few minutes to get the cubes installed (beware that earlier versions of Dynamics GP require that Analysis Services for Excel be installed from a 32-bit OS, as noted in KB 945953) and their solution in place. Using this as the starting point for your data warehouse, you can be up and running quickly, creating rich, dynamic reports, making use of the Dashboard Designer, Decomposition Tree, Chart Web Part, and the rest of the assortment of tools that SharePoint Insights offers.

 Using these two tools together (SharePoint 2010 Insights and Dynamics GP’s Analysis Services for Excel) will give you a good BI foundation on which to build. It’s a quick, minimal-hassle way to provide some rich and contextual “insight” into your company through SharePoint. For help with SharePoint contact JourneyTEAM at 800.439.6456.


JourneyTEAM – Utah SharePoint Experts

Related Posts

One question

  1. Sharepoint is an excellent tool for well. sharing data if you’re working in different offices. I can’t even explain how useful it’s been for our company.


Ask This Expert a Question or Leave a Comment