Using Microsoft Business Intelligence Dashboards and Reports in the Federal Government

Leveraging Existing Investments in Microsoft Technology for Analytics and Reporting

Download the whitepaper

Business Intelligence tools offer many advantages to government agencies, such as dashboard creation, custom reporting, and analytics, but these tools can be costly to procure and implement. However, Microsoft’s Business Intelligence (BI) Offerings leverage existing technology investments to develop integrated reporting and analytics that enable users to gain access to accurate, up-to-date information for better decision making. These technologies enable agencies to expand their business intelligence capabilities with minimal investment. Dev Technology’s whitepaper on this topic showcases the following tools available from Microsoft as part of its BI Offerings and how they could be implemented in the federal environment.

  • SQL Server Reporting Services (SSRS): Included with SQL Server, this is a highly scalable solution that empowers real-time decision making through the creation of operational reports and ad-hoc reports.
  • PowerPivot for Excel and SharePoint: This is a data mashup and data exploration tool that can load large amounts of data from almost any source, process it quickly, and model with analytical capabilities. PowerPivot is available as a free add-in for Excel, or as part of an Enterprise License for SharePoint 2010.
  • PerformancePoint Services: PerformancePoint Services provides a rich set of tools and services for building interactive dashboards that can help agencies monitor and analyze performance. It is included as part of an Enterprise License for SharePoint 2010.
  • Business Connectivity Services: Business Connectivity Services is part of SharePoint 2010 and enables SharePoint to connect with data from non-Microsoft platforms such as Oracle or Web Service connections. This enables agencies to leverage the full set of Microsoft BI capabilities without changing their current systems.

Most agencies currently have access to these tools through their implementations of SharePoint 2010 and SQL Server, resulting in the ability to take advantage of industry leading business intelligence capabilities at a lower cost than competing products that require the purchase of a new license. They also seamlessly integrate into current architectures and application solutions as they are part of already approved tools. In addition, many of these tools can be configured by users, enabling self-service and reducing the need for contractor assistance when modifying reporting needs. Microsoft BI Tools enable agencies to benefit from faster and improved decision making with minimal cost.

Download the full PDF version of the white paper to learn more about how these tools can improve business intelligence for minimal cost.