Visionet Supplier Performance Management Solution - SME Deck

sweetleafapartInternet και Εφαρμογές Web

7 Αυγ 2012 (πριν από 4 χρόνια και 10 μήνες)

329 εμφανίσεις

Bringing Your IT Vision to Reality

1

Leveraging SharePoint
2010
&
PowerPivot for Enterprise
BI




March 2012

…Bringing Your IT Vision to Reality


Jawad Khan, VP Reporting/BI Solutions

Mark Zadroga, VP Sales & Marketing

Bringing Your IT Vision to Reality

2

Agenda

Bringing Your IT Vision to Reality

Introduction


16+
years of Software Services Experience


Domain expertise
-

Retail,
Fin’l

Services, & Distribution


Longstanding customer relationships


High employee retention


better customer service



ISO 9001, CMMI Level 3, & SAS70 Certified


Partnerships
-

MSFT, IBM, Oracle, & MicroStrategy


BizTalk, WebMethods,
Tibco

Certified


100s of successful projects and references


IT Enabled BPO Services



Deep experience
in
AD,
Maint

& Support,
Migrations/Conversions, Testing/QA


Solution Centers for Business Systems, EAI,
Reporting/BI, and Portals & Collaboration


Mature offshore deployment and delivery model

Why
Visionet?




Credentials




Value
Proposition

3

Bringing Your IT Vision to Reality

4

Competencies & Solution Centers

Production
Support

4

Maintenance & Support

Application Development

Re
-
engineering/ Conversions

Testing/ QA Services

Industry Solutions

Reporting / BI / MDM

Enterprise
Appl

Integration

Portals / Collaboration

Enterprise Systems

Bringing Your IT Vision to Reality

5

Production
Support

5

Maintenance & Support

Application Development

Re
-
engineering/ Conversions

Testing/ QA Services

Industry Solutions

Reporting / BI / MDM

Enterprise
Appl

Integration

Portals / Collaboration

Enterprise Systems


Cloud
Deployments

Customer

Infrastructure

Deployments

Any Device

Anywhere

Solutions Execution

Bringing Your IT Vision to Reality

Solution Offerings
-

General

Application Development


.NET Based Web & Desktop Applications


J2EE Based Web & Desktop Applications


Adobe Flex & Silverlight

Reporting/BI/MDM

(Microsoft, MicroStrategy
and OBIEE)


App Dev/Conversions/Maintenance & Support


Data Integration


Data Modeling & Warehouse Development


Corporate Reporting (SQR, SSRS, MSTR, OBIEE, Crystal, BIRT)

BPM

(JBPM, Web Methods,
IBM Business Process
Management, Oracle BPM)


Process Modeling


Process Integrations


Process Execution


Process Monitoring & Optimization

EAI

(
WebMethods
, IBM
Process Server,
Smooks
,
TIBCO, MQ Series,
WebSphere

ESB,
Jboss

ESB)


Business Partner Integrations (EDI)


Interface Architecture Design & Development


Point to Point & SOA Integrations

Portals/Collaboration
(SharePoint)


Workflow Driven Custom Application Development

Mobile

Computing


Html5 based Smart Device Apps Development

Cloud

Enablement


Microsoft Azure based App Development & Deployment


Amazon EC2 based App Development & Deployment

6

Bringing Your IT Vision to Reality

Partial Client List

7

Go to Main Menu

Bringing Your IT Vision to Reality

8


Committed to making Business Intelligence relevant for our customers

Why Visionet!


Dedicated BI Solution Center and BI Resources


Well Developed and Mature Services Delivery Methodology


Expert Business Applications Development Teams


One Stop Shop


Concept to Post Production Support


Quality Solutions from a Hybrid Delivery Model

Bringing Your IT Vision to Reality

9

Business Intelligence

Simple

Relevant

Pragmatic

Bringing Your IT Vision to Reality

10

Traditional Scenario


Corporate Executives

Corporate
Data
Sources

LOB

Workers

Bringing Your IT Vision to Reality

11

Key Challenges with Traditional Scenario


Individual centric approach

Inefficient utilization of computing resources

Risks for delays in information availability

Challenges in knowledge retention

Exec leadership’s dependency on staff for reporting

Tedious workflow for end users

Not conducive to collaboration oriented culture

Bringing Your IT Vision to Reality


Access to
consistent and
accurate
information on
demand


Helps Optimize the
decision making
across the
enterprise


Web Based Access


Ability to process
millions of rows
fast


Quick and easy to
create solutions


Significant bottom
line savings at
minimal operating
cost

Optimal
Utilization of
Resources

Highly scalable
and Agile

Provides
information
swiftly to all
stake holders

Promote the
culture of
collaboration
and knowledge
sharing

Advantages of SharePoint and MS BI Platform

Bringing Your IT Vision to Reality

SharePoint 2010 Capabilities


13

Bringing Your IT Vision to Reality

14

Microsoft BI Stack


SQL Server Integration

Services

SQL Server Data
Warehouse

SQL Server Analysis
Services

MS Excel/ Power Pivot/
SSRS/Performance Point

Dashboards, scorecards,

Analytics, Visualizations

MS SharePoint Portals, Excel
Services, Report Libraries

Bringing Your IT Vision to Reality

Corporate Executives

Corporate
Data
Sources

LOB

Workers

15

Enterprise BI
Scenario

with SharePoint 2010

Corporate
Data
Sources

Corporate
Executives

Corp.

Workers

Bringing Your IT Vision to Reality

Rapidly Respond to Business Needs

Developer
Productivity

Composite

Solutions

Data

Connectivity

Delivery Scheduling

Payroll Management

Pricing Analysis

Sales Reporting

Hiring Processes

Exec

Dashboards

IT Service Portals

Conference Planning

Divisional Portals

Expertise Finders

Compliance Review Sites

Project Tracking

Personal Profile Sites

Citizen Portals

Business
-
collaboration solutions

Bringing Your IT Vision to Reality

SharePoint Insights


Excel Services


PowerPivot


Report Services


Performance
Point
Services


Visio Services

SharePoint / BI Technology Stack


Bringing Your IT Vision to Reality


Supports
the server
-
side calculation and browser
-
based rendering of Excel workbooks


Use
for:


Real
-
time, interactive reporting with support for parameters


Exposure of all or part of a
workbook


Development of analytical solutions


The Excel Web Access Web Part supports embedding workbook reports into Web Part
Pages


Excel Services


Bringing Your IT Vision to Reality

PowerPivot


the ‘easy’ cube



PowerPivot empowers end users to create self
-
service BI solutions in Excel
2010


Allows more than 1 million records to reside in a workbook


These
capabilities are achieved by two add
-
ins:


SQL Server PowerPivot for Excel Add
-
in


SQL Server PowerPivot for SharePoint Add
-
in


Provides centralized storage, data refresh and management of workbooks created by
using PowerPivot for Excel


Uses Excel Services to enable browser access to workbooks


Bringing Your IT Vision to Reality

PowerPivot
-

the ‘easy’ cube



Bringing Your IT Vision to Reality

PowerPivot


the ‘easy’ cube


Data is
loaded/aggregated
in PowerPivot

Any
transformation is
made using DAX

Self
-
service
reporting is done
using Pivot tables
and charts

Document is
published to
SharePoint
PowerPivot gallery


Bringing Your IT Vision to Reality


Performance Management (PM) application


Defines rich KPI and scorecard definitions to

support
monitoring


Includes comprehensive report types to
support analysis


Delivers interactive browser
-
based dashboards


Dashboard solutions are based on
several
related elements

Performance Point Services


Bringing Your IT Vision to Reality


Supports central access to, and browser
-
based
rendering of Visio diagrams


Diagrams can be based on refreshable data
sources


Use for:


Bringing diagrams to life with data
-
driven
visuals connected to real
-
time data


Sharing interactive, browser
-
based
diagrams


Connects to SQL Server, SharePoint list
data, Excel Services and OLE DB/ODBC
sources


The Visio Web Access Web Part supports
embedding diagrams into Web Part Pages

Visio Services


Bringing Your IT Vision to Reality

24

24

Case study

Client Business Focus

Large Supply Chain business, Designer,
manufacturer, retailer, wholesaler

Data Sources

IBM AS/400, MS SQL Server 2008, Oracle 10g

Development Team Size

4

Duration

3

Months

Solution Features

Automation,

Data Integration, On
-
demand
visualization

and
reporting, Collaboration,

AdHoc

analysis

Bringing Your IT Vision to Reality

25

Real life problem


Challenges


Eliminate manual effort


Ensure Time Delivery of
Reports


Enable execs and senior
management with ah
-
hoc
capability for getting
business insights


Enable access on tablet


Example


Multiple data sources


4
-
5 hours required for
manual creations


Needed nearly 15
-
18
times a month






Daily
.
vince
.
retail
.
xlsx
Sheet
1
Final Excel Document
Modern
(
Sheet
)
Designer
Life Style
Rebecca
MTD Invoiced
Daily invoiced
Packed
/
Awaiting

..
Daily
.
Invoice
.
xlsx
Sheet
1
MTD
$
MTD
$
Daily Invoiced
$
Input here
(
Sheet
)
Manual
Dock
$,
Indy
$
daily
.
danny
.
xlsx
Sheet
:
Walmart Daily
REDLANDS
$
REDLANDS
$
(
Proclarity
-

WH
70
what
'
s on Pick
)
Manual
WM
--

AS
400
DATA

(
Microsoft Query
--

Jeff
)
Manual Entry
DOCK
$
INDY
$
Sheet
:
MM
(
FR
01
)
Daily
REDLANDS
$
Sheet
:
Candies
(
FR
01
)
Daily
REDLANDS
$
Daily
.
Report
.
xlsx
2011
Sales
_
Earn
-
ENC
<
Month Forecast
>
FBI Cube
Forecast
Manual
2011
Sales
_
Earn
-
MM
<
Month Forecast
>
2011
Sales
_
Earn
-
VN
<
Month Forecast
>
Ivc Open Modern Lifestyle
-
2011
.
xlsx
]
My MIchelle By Label
'
Open
/
Shipped
Vince
Open
/
Shipped
Uncofirmed
.
xlsx
Sheet
:
Total
Unconfirmed Dollars
$
ProClarity w
/
unconfirmed
SAO indicator
Manual
?
Unconfirmed
$
daily
.
receipts
.
xlsx
Sheet
1
Units Received
DailyMeister
.
xlsx
2011
Sales
-
Month
FBI Cube
Forecast
Manual
DailyAdams
.
xlsx
2011
Sales
_
Earn
-
AD
(
Value
)
Manual
Corp Act
/
Fcst
Open Shipped
Corp Act
/
Fcst
Open
/
Shipped
DM
Open Shipped
LifeStyle
-
Ship By
Packed
/
Awaiting Pickup
MTD Invoiced
Daily invoiced
Packed
/
Awaiting

...
MTD Invoiced
Daily invoiced
Packed
/
Awaiting
……
.
MTD Invoiced
Daily invoiced
Packed
/
Awaiting
……
.
Daily
.
Miami
.
xlsx
Sheet
1
(
Proclarity
-

WH
063
Manual
Manual
Manual
$
to Process
(
CXL
1
$
)
2011
Sales
_
Earn
-
LD
<
Month Forecast
>
Open
/
Shipped
EBA Cube
ProClarity View
EBA Cube
ProClarity View
EBA Cube
ProClarity View
Sales Order Cube
(
Open for the month
)
Invoice Cube
Shipped for
the month
ENC
Open
/
Shipped
Bringing Your IT Vision to Reality

Simplified Architecture


Data Sources

SSAS Cubes

DW

OLTP

Others

SharePoint Site content

Excel Documents

Excel Services

Power Pivot
Documents

Power Pivot Services

PPS
Reports/Dashboards

ProClarity Views

PAS (ProClarity
Analytics Server)

26

Bringing Your IT Vision to Reality

27

Results


Old Report

New SharePoint,
Power Pivot Based
Report

Bringing Your IT Vision to Reality

28

28

Demonstration

Bringing Your IT Vision to Reality

Summary

End User Benefits


Quick
Turnaround to Business Changes


Scalable and able to handle large data


Empowering
Business Users


Leveraging
Core Investment


Rich and Dynamic Reporting


Integrated Development Environment

“BI for everyone!”

Bringing Your IT Vision to Reality

Questions ?


iPad

Drawing


Thank You!

…Bringing Your IT Vision to Reality

www.visionetsystems.com

cjohnson@visionetsytems.com


Cliff Johnson, Sales & Marketing Operations