Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

cabbagewheatInternet and Web Development

Nov 13, 2013 (3 years and 8 months ago)

58 views

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

About Ironbridge Software...

o
Founded in 1989

o
Headquartered in a suburb of Chicago

o
New York

o
Atlanta

o
Specializing in Sales & Marketing Information

o
Software

o
Data Warehousing

o
Data Integration

o
Food, Beverage and Household Companies


Clients include: PepsiCo, Energizer Battery, Reckitt/Benckiser, SC Johnson, SPINS,

Kraft Foods, DS Waters Of America, Sargento Foods and more….

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Ironbridge Strategy
-

Responsive

o
Senior Professionals



working, not just overseeing, for our clients to
deliver highest quality solutions.

o
Experienced

o
Talented

o
Creative

o
Independent ownership



allows us to provide the
right

solutions for our
clients.

o
Responsive

o
Flexible

o
Exceeding client expectations


Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Consulting Services

o
Data Warehousing

o
Internal orders, shipments, COGS, promotion data

o
External: retail POS, syndicated consumption, demographic


o
Real Time Integration

o
Keep syndicated data at source

o
Keep detail internal data at source

o
Build harmonizing tables and aggregation tables


o
Category Management


o
Consumer Insights


o
Dashboard style applications

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench

o
Sales & Marketing analytical tool

o
Browser based: users just go to web site (intranet)

o
Ad
-
hoc data selection


o
Report generator

o
Canned reports or real
-
time

o
Collaborative publishing


o
Data integration

o
Shipments, consumption, retail POS, promotions, demographic


o
User interface

o
Browser

o
Dashboard using web service (Excel, PPT, HTML)


o
Very large databases

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench Reporting

o
Standard daily/weekly reports via browser or via email

o
End users can make ad
-
hoc data selections

o
Save them as a report

o
End users can design custom measures, geography groups, product groups
(dictionary)

o
Share with others (collaborative publishing)

o
Net
-
Bench uses report templates entirely

o
Data updates automatically, no manual intervention



Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench Collaborative Publishing

o
Internal database of presentations, analytics and charts


o
Users make their own reports, or save private copy as personal


o
Reports organized by folder


o
User can then publish
or use to form the basis of new presentations


o
Published (grant permissions)

o
by organization

o
by user group

o
by individual


o
Within privileges




Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench Batch Reporting

o
Timely distribution to users


o
Reports always refresh


o
Use night time batch for mass production


o
E
-
mail notification



Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench Security

o
User hierarchy

o
Users are members of groups

o
Groups are members of

organizations


o
Organizations are entirely separate

o
Reports/dictionaries published by user, group or organization

o
Data security

o
Logical views protected by user group

o
Data (row) level security

o
By user by data value

o
Central Administrator

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench Relational Mapping

o
Maps physical relational tables/columns to logical dimensional
view

o
Star and snowflake

o
Complex hierarchies

o
Characteristic selection


auto rollup

o
Flexible periodicities

o
Multiple fact tables per logical database

o
Defines harmonizing for multiple integrated databases

o
Cross dimensional aggregation rules

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench Integration

o
Data Integration From Syndicated, Industry and Internal Data


o
Integrates in real time (only product to do this)


o
IRI, ACN, Spectra, TD Linx, Internal, POS, Retail Link, EDI


o
Supports IRI
-
Express, ACN
-
PLDB, Oracle, DB2, SQL Server, Excel, Ms
-
Access


o
Data stays at the source: no intermediate cubes


o
Requires harmonizing tables

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench Access

o
Corporate (LAN) and Remote (Field User) Access



o
Available via browser to anyone logged in (with user id)


o
No software to install


o
Works very well over phone lines


o
Portable Results


for Display at Remote Sites (Not Tethered to a
Server)


o
Save reports to Excel, HTML or PowerPoint


o
Stand alone is available


Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Web Service

o
Net
-
Bench Sends Data Direct to your existing application


o
Excel dashboard


o
PowerPoint (Net
-
Point)


o
Uses INET.OCX and Net
-
Bench OLAP protocol


o
All the benefits of data integration (ACN, IRI, in house etc.)

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Support

o
Support

o
Technical | Availability of Technical Assistance

o
For general help call 847.699.3369

o
Authors are available by cell phone

o
Training | Formalized Training of System Functionality / Components

o
2
-
5 days included in license

o
New release functionality

o
User | Software / On
-
line Functionality

o
Context sensitive help on
-
line



Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench System

o
Seamless Integration Into your Environment


o
Standard

vanilla


web application


o
Internet Explorer, Netscape etc.


o
READ ONLY

to your in house databases


o
Minimal or no requirements on in
-
house databases


o
Java Applet in browser


o
Java servlets

o
(Oracle Application Server, IBM WebSphere and Apache)

o
Heavy IRI/ACNielsen use requires two or more Windows computers


Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench Technology

o
An analytical report generating tool .


o
A browser
-
based user interface with the
ability to access multiple data sources
including ACN®, IRI® and relational
databases.


Access from any browser with
connections to your environment.

Use as a Data Access engine…

Use as a Reporting tool…

o
A back
-
end data integration engine .


o
A web service interface with the ability to
integrate multiple data sources including ACN®,
IRI® and relational databases through any custom
application.


Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench 3
-
Tier Deployment

NB Admin

Service

RDBMS

ACN

IRI

BROWSER

NB SQL

Service

NB ACN

Service

NB IRI

Service

One server

Security


Databases


Reports


Dictionary

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Web Service Deployment

NB Admin

Service

RDBMS

ACN

IRI

NB SQL

Service

NB ACN

Service

NB IRI

Service

One server

NB Data

Service*

M

M

M

M

M

M

NB ACN

Service

NB IRI

Service

NB SQL

Service

Security


Databases


Reports


Dictionary

M
= metadata only

*

= data pulls, integration,


load balancing

http +


-

Nitro


-

Any Custom


Application

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Net
-
Bench 4
-
Tier Deployment

NB Admin

Service

RDBMS

ACN

IRI

NB SQL

Service

NB ACN

Service

NB IRI

Service

One server

NB Data

Service*

M

M

M

M

M

M

M
= metadata only

*

= data pulls, integration,


load balancing

NB ACN

Service

NB IRI

Service

NB SQL

Service

BROWSER

Security


Databases


Reports


Dictionary

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Reports Folder

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Top Level Integration

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Drill
-
Down Screen #1

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Drill
-
Down Screen #2

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Drill
-
Down Screen #3

Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

Drill
-
Down Screen #4