|
Introduction
SharePoint 2010
Business
Intelligence brings
informal and formal
information together
to enable users to
access the
information they
need, and make
timely, more
relevant business
decisions. It
provides the
platform for users
to continuously ask
the questions to get
the insights they
need and move the
business forward.
Create, deliver, and
share your business
views and by
mashing-up the data
that’s relevant to
team, securely
maintained by IT.
Enable users to find
the information they
need across
unstructured assets
like blogs, wikis,
presentations,
documents and
structured assets
like reports,
spreadsheets, and
analytical systems.
Empower users to
discover the right
people and expertise
to make better
informed and more
agile business
decisions.
IT is empowered to
meet the needs of
the business through
a unified
infrastructure that
provides the right
level of services,
interoperability
with client tools,
and back-end systems
for 24/7
availability,
seamless
manageability, and
extensibility with
common industry
standards and
developer tools.
SharePoint 2010 as a
platform for
Business
Intelligence offers
various tools to
build
Business
Intelligence
solutions.
This workshop will
take you through the
some of the tools
like :
Excel Services
makes it simple to
use, share, secure,
and manage Microsoft
Office Excel
workbooks as
interactive reports
in a consistent way
throughout the
enterprise and
create dashboards.
With rich
programmability
capabilities, you
can take your
workbooks further by
extending your
workbooks on the
server and
maintaining a single
version of the
truth, all the while
protecting the
intellectual
property contained
within the spread
sheet.
PowerPivot
gives users the
power to create
compelling
self-service BI
solutions,
facilitates sharing
and collaboration on
user-generated BI
solutions in a
Microsoft SharePoint
Server 2010
environment, and
enables IT
organizations to
increase operational
efficiencies through
Microsoft SQL Server
2008 R2-based
management tools.
Visio Services
provides the
capability to create
Web-based Visio
visualizations via
Visio Services,
which improve the
process of conveying
the status of a
process or flowchart
to business users
and key decision
makers.
Chart Web Parts
allows creating
charts directly in
SharePoint using
just your
web-browser on data
gathered in
SharePoint Lists or
from Excel
workbooks. Through a
simple wizard, users
can create simple
dashboards quickly
and easily.
Status Indicator
Lists quickly allows
to create and manage
Key Performance
Indicators (KPIs) to
convey the status of
your projects, and
overall performance
of short or
long-term goals with
a broader audience.
Business
Connectivity
Services allows you
to create SharePoint
applications that
bring external data
into the Office
system, extending
the rich Office user
experience and
SharePoint
collaboration
capabilities to
business data and
processes, while
offering complete
Create, Read, Update
and Delete
functionality,
whether in
SharePoint or
offline in Office.
PerformancePoint
Services is a
performance
management service
that you can use to
monitor and analyze
your business. By
providing flexible,
easy-to-use tools
for building
dashboards,
scorecards, and key
performance
indicators (KPIs),
PerformancePoint
Services can help
individuals across
an organization make
informed business
decisions that align
with companywide
objectives and
strategy.
Using Microsoft
Visio 2010,
Microsoft SharePoint
Server 2010,
Microsoft Office PerformancePoint
Dashboard Designer,
and Microsoft Excel
2010, Business
Connectivity
Services, PowerPivot
together empowers
decision makers,
improves
organizational
effectiveness, and
increases IT
efficiency.
Why Attend
In this practical
workshop we look at
how to use
SharePoint as the
platform for
Business
Intelligence and
explore a number of
new capabilities
SharePoint 2010
encompasses
pertinent to the
Business
Intelligence. Create
Charts, KPIs,
scorecards and other
metrics by
consolidating
information from
multiple systems and
assemble
contextual-driven
dashboards and
display on a single
webpage to simplify
analytics. Access
the right
information to
translate strategy
into action and
enable
accountability.
Use solutions that
are owned by the
business, integrated
with business goals,
and that facilitate
collaboration and
provide business
insights to all
employees leading to
better, faster, more
relevant decisions
can be delivered
through a familiar
environment,
integrated into a
business
collaboration
infrastructure, and
built on a trusted
and extensible
platform.
At the end of the
workshop,
participants will be
able to answer the
following questions:
-
Implement BI
Strategies and
explore data in
new and dynamic
ways.
-
SharePoint
dashboard and
its elements.
-
Centrally
maintaining and
sharing reports,
metrics,
scorecards, and
KPIs.
-
How data can be
visually brought
to life with
interactive
dashboards.
-
How will
SharePoint
Business
Intelligence
impact
-
What business
intelligence
services are
available with
SharePoint 2010
and when would
use them.
-
Possible data
sources for each
business
intelligence
service
Who Should Attend?
-
Business Analyst
-
Business
Intelligence
Consultants
-
Business
Intelligence
Architects
-
Business
Intelligence
Developers
Case Study
This case study is
about Contoso Inc, a
fictitious company.
Contoso has
operations in North
America, Europe, and
Asia with brick and
mortar, ecommerce,
and multi-channel
retailing
components. The
company also
manufactures several
product lines, with
manufacturing
operations in Asia.
This case study is
central to the ideas
about a management
system based on
performance
measurement in
relation to Contoso
as it first examines
its goals in a key
area of its
organization, and
then plans what it
needs to measure to
manage effectively
and reach these
stated goals. We
will follow its
process as it moves
from the work of
identifying business
goals and
requirements to
gathering and
analysing data,
identifying
measures, designing
key performance
indicators (KPIs)
and scorecards, and
designing reports
and final dashboards
to can provide
actionable data and
data-driven insights
to dig in and
identify trends for
all the
stakeholders.
Contoso is looking
to broaden its
market share by
targeting their
sales to their best
customers, extending
their product
availability through
an external Web
site, and reducing
their cost of sales
through lower
production costs."
As part of an
overall company
initiative to grow
Contoso, the CEO
decided to outline
several short-term
and long-term goals
they would like to
achieve and start
laying the
foundation for these
changes now and the
upcoming season.
They know that these
goals relate to
market expansion and
increasing
popularity.
To better define and
plan for its
expansion
strategies, Contoso
needs to understand
current performance
and overall market
performance.
Decision makers and
executives need to
answer the following
questions quickly:
-
How is the
Contoso
performing now?
-
How is the
Contoso
performing
relative to
market
indicators?
-
How is the
laptop sales are
faring in some
of the stores?
-
How can we
better
understand the
market to
position the
company in the
best way
possible?
-
Which type of
products brings
in the most
revenue?
-
Based on the
analysis, what
targets do we
want to set?
-
Based on the
analysis, what
factors can help
targets?
|
