Sharepoint BI

Most executives are convinced about the value of decision data, scorecards and dashboards and even about full-fledged EPM systems, but the point where they often get stuck is this : How do I enroll my colleagues into this process of continually improving performance? Its not the system or technology that hinders performance management. It’s the culture.

Insight Consultants understands and appreciates companies that contemplate enterprise-wide business intelligence and performance management solutions. We help them create a system that is non-intrusive and collaborative and enables the entire company to embrace an enterprise BI solutions. Leveraging the new Microsoft Sharepoint 2010, Insight will help in inculcating a culture where performance monitoring is a shared responsibility of every employee in the organization. We specialise in implementing the various extensions of Sharepoint 2010 such as PowerPivot, SQL server services and Performance point services.

Sharepoint Server 2010 – The Future Is Collaboration

Sharepoint Server 2010 is a collaborative platform that helps you create, collate, analyse and present data your way: personally, as a work team, as a business unit or even at the organization level. Sharepoint 2010 is the new business intelligence suite from Microsoft, which now includes

  • Microsoft Excel 2010 with advanced PowerPivot and reporting functionalities
  • Visio services for creating aerial maps of disparate enterprise-wide databases
  • PerformancePoint services for creating custom dashboards and KPIs, data management and manipulation services through SQL server services
  • Sharepoint Server Enterprise Content Management services.

At Insight, we can contextualize Sharepoint Server 2010 and help build reports, dashboards, KPIs and database structures that suit your company’s size and culture.

Sharepoint Server 2010 has a bouquet of new features all geared towards making businesses perform intelligently and optimally. Some of them are :

  • Access Services & Visio Services – earlier being separate products of the Microsoft desktop suite, these have now found greater use as part of the SPS 2010 pack
  • SharePoint Designer Enhancements – better usability for business users about workflow designs, editing pages and setting up BCS
  • BI components – perhaps the biggest win for SPS 2010 buyers comes from this. This version comes with Excel 2010, with Microsoft’s strategic move to make Excel the bread-and-butter solution for business analysts. Powerful powerpivot functionalities and PerformancePoint server integration are added bonuses.
  • Social networking capabilities

and the list goes on. For a feature-by-feature comparison between SPS 2010 and MOSS 2007 see this post

Business benefits of Sharepoint Server 2010 platform

SS 2010 platform for developing and designing business intelligent solutions is inherent with many rewards elaborated briefly as below:

Connects and empowers people by allowing them to work together in ways that are most effective for them. Whether through the PC, browser or mobile phone, SharePoint 2010 offers an intuitive and familiar user experience.

Cost-effective with a unified infrastructure offers enterprise-scale manageability and availability. Whether deployed on-premises or as hosted services, SharePoint 2010 lowers total cost of ownership by offering an integrated set of features and by allowing organizations to consolidate their business-productivity solutions on top of SharePoint. This leads to a reduction in costs related to maintenance, training and infrastructure management.

Rapidly respond to business needs with dynamic and easily deployed solutions. Whether it’s a business user, a power user or a professional developer, SharePoint 2010 offers the tools and capabilities to design and create business solutions that can be integrated with existing enterprise data, tools and processes.
SharePoint Foundation 2010 provides the following scalable, reliable, high-performance capabilities for site management:

Storage – Allowing content such as documents (Office documents, PDFs, custom binary files), web pages, lists, and other types of information to reside in a common data repository (Microsoft SQL Server™) with full data management capabilities, version control, meta data, and site-level search.

Management – Enabling centralized and delegated administrative facilities for SharePoint sites from operational and application perspectives, in addition to ongoing site monitoring.

Deployment – Providing an architecture that supports flexible, distributed, and scalable deployment architectures, across web and database servers; enabling configuration and site feature management.

Site Model – Providing a template-based infrastructure for deployment of custom sites, providing automated navigation and a consistent user interface while allowing for extensive and flexible customization of site formatting and layout.

Extensibility – Delivering a comprehensive application programming interface (API) that allows custom applications to be built on the SharePoint Foundation 2010 architecture, employing use of XML Web services and REST APIs, and providing event handlers for cross-integration with other applications and methods for migrating content into SharePoint sites.

From a business perspective, SharePoint Foundation 2010 provides the following foundational business-collaboration features:

  • Document collaboration
  • Wikis and blogs
  • RSS support
  • Discussion boards
  • Project task management
  • Contacts, calendars, and tasks
  • E-mail storing and management
  • Better design for working with Microsoft Office 2010
  • Richer offline support using SharePoint Workspace 2010

With the multi-faceted Microsoft Sharepoint Server 2010, the unique combination of Excel and Power pivot for ease of use and safety of data storage on SQL server, Business intelligence truly comes of age. A powerful, collaborative tool, SS 2010 can help improve:

a) understanding of the target market and help make targeted marketing campaigns more effective

b) consolidate monthly financial statements across locations and geographies

c) responsiveness to customer needs

d) inventory management and optimize storage space

e) cost efficiencies in marketing, storage, and operational processes

We can contextualize Sharepoint Server 2010 and help build reports, dashboards, KPIs and database structures that suit your company size and culture.

Comments are closed.