|
Business Intelligence and Office SharePoint
2007:
Traditionally, the tools for accessing large
amounts of unstructured data for the purpose of
analysis were available only to people with
years of experience in data warehousing or data
mining. Publishing to the Web by using data from
multiple sources is something historically
restricted to developers and consultants. By
using the new features available in Office
SharePoint Server 2007, information workers can
assemble data from multiple sources and publish
that data on the Web.
Office SharePoint Server 2007 can link to
business applications, such as SAP, Siebel, and
Microsoft SQL Server 2005, allowing you to
easily publish reports, lists, and key
performance indicators (KPIs).
When you publish reports from the data in one of
these systems, you provide strategic or
operational data for decision-makers. Examples
of reports include Microsoft Office Excel
workbooks, a SQL Server Reporting Services
report, or a Microsoft Office Access report.
Executives and line managers rely on timely and
accurate reports to make informed decisions.
At the center of the new Office SharePoint
Server 2007 Business Intelligence features is
the Report Center. The Report Center is a site
that provides a central location for storing
reports that are common to a group, whether it
is as small as a one team or as large as an
entire organization.
|
The Report Center:
The Report Center site provides a
central location for
business-intelligence-related
information.
|
Excel Services:
Excel Services enables you to store an
Excel workbook on a server and then
publish any part of that workbook on a
Web page.
|
Connections to external data sources:
Use data from other business
applications such as SAP, Siebel and MS
SQL Server 2005
|
Key Performance Indicators (KPIs):
Visual cues that communicate the amount
of progress toward measurable goals.
|
Filter Web Parts:
By using filters you can display more
meaningful information.
|
Dashboards:
Dashboards are tools that are used to
communicate status and to drive action. |
|
|
The Focus of the
seminar will be on providing Business
Intelligence (B.I.) solutions based on
SharePoint and related technologies. Business
Intelligence with Office SharePoint Server 2007
makes it easy for decision-makers to access and
analyze information anytime, anywhere. You can
get up-to-date information wherever people work,
collaborate, and make decisions, whether it's on
the desktop or over the Web. Now, aligning
employee's objectives with your corporate goals
is as easy as creating a spreadsheet or report.
We’ll take you through the steps needed to build
a B.I. solution hosted by SharePoint, that
utilizes built-in tools and elements as well as
connects to external, live data sources such as
existing Line Of Business systems and databases. |
