slide1 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
About Ironbridge Software... PowerPoint Presentation
Download Presentation
About Ironbridge Software...

Loading in 2 Seconds...

play fullscreen
1 / 56

About Ironbridge Software... - PowerPoint PPT Presentation


  • 367 Views
  • Uploaded on

About Ironbridge Software. Founded in 1989 Headquartered in a suburb of Chicago New York Atlanta Specializing in Sales & Marketing Information Software Data Warehousing Data Integration Ironbridge - Nielsen Development Author of Scan*Fact PC Helped design PLDB’S

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'About Ironbridge Software...' - RoyLauris


Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
about ironbridge software
About Ironbridge Software...

Founded in 1989

Headquartered in a suburb of Chicago

New York

Atlanta

Specializing in Sales & Marketing Information

Software

Data Warehousing

Data Integration

Ironbridge - Nielsen Development

Author of Scan*Fact PC

Helped design PLDB’S

Author of NITRO relational access (ACCT PLNR, DATABANK)

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

about ironbridge software3
About Ironbridge Software...

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

software products
Software Products
  • Net-Bench
    • Browser based reporting
    • Analytics
    • Data Integration
    • Internal and external (syndicated) data
  • Net-Point
    • Automates PowerPoint presentations
    • Design sales presentation once
    • Ends users customize via web site
  • Trade Mix Optimizer

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

ironbridge strategy economic environment
Ironbridge Strategy - Economic Environment
  • Ironbridge develops cost effective software solutions to the CPG industry
    • Real-time/Web-based software
      • Net-Bench: Reporting for internal and syndicated data
      • Net-Point: Automate PowerPoint presentations
      • TMO: Determine your optimum trade mix with ‘Trade Mix Optimizer’
  • Independent ownership – allows us to provide the right solutions for our clients
    • Automated data extracts
    • Web based reporting of syndicated/warehouse data
    • PowerPoint automation
    • Trade Mix Optimization
    • Free installation and training

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

net bench
Net-Bench

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

net bench7
Net-Bench
  • Sales & Marketing analytical tool
    • Browser based: users just go to web site (intranet)
    • Ad-hoc data selection
  • Report generator
    • Canned reports or real-time
    • Collaborative publishing
  • Data integration
    • Shipments, consumption, retail POS, promotions, demographic
  • User interface
    • Browser
    • Dashboard using web service (Excel, PPT, HTML)
  • Works directly with Nielsen & IRI databases
  • Relational DBMS, Analysis Services cubes
    • Very large databases

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

net bench reporting
Net-Bench Reporting
  • Standard daily/weekly reports via browser or via email
  • End users can make ad-hoc data selections
  • Save them as a report
  • End users can design custom measures, geography groups, product groups (dictionary)
  • Share with others (collaborative publishing)
  • Net-Bench uses report templates entirely
  • Data updates automatically, no manual intervention

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

net bench collaborative publishing
Net-Bench Collaborative Publishing
  • Internal database of presentations, analytics and charts
  • Users make their own reports, or save private copy as personal
  • Reports organized by folder
  • User can then publish or use to form the basis of new presentations
  • Published (grant permissions)
    • by organization
    • by user group
    • by individual
  • Within privileges

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

net bench batch reporting
Net-Bench Batch Reporting
  • Timely distribution to users
  • Reports always refresh
  • Use night time batch for mass production
  • E-mail notification

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

net bench security
Net-Bench Security
  • User hierarchy
    • Users are members of groups
    • Groups are members of ‘organizations’
    • Organizations are entirely separate
    • Reports/dictionaries published by user, group or organization
  • Data security
    • Logical views protected by user group
  • Data (row) level security
    • By user by data value
  • Central Administrator

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

net bench relational mapping
Net-Bench Relational Mapping
  • Maps physical relational tables/columns to logical dimensional view
  • Star and snowflake
  • Complex hierarchies
  • Characteristic selection – auto rollup
  • Flexible periodicities
  • Multiple fact tables per logical database
  • Defines harmonizing for multiple integrated databases
  • Cross dimensional aggregation rules

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

net bench integration
Net-Bench Integration
  • From Syndicated, Industry and Internal Data
    • IRI, ACN, Spectra, TD Linx, Internal, POS, Retail Link, EDI
    • Supports IRI-Express, ACN-PLDB, Oracle, DB2, SQL Server, Excel, Ms-Access
  • 2 Alternatives…..
    • 1. Real-time Integration (only product to do this)
      • Data stays at the source: no intermediate cubes/data marts
    • 2. Build integrated data warehouse
    • Both require harmonizing tables

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

net bench access
Net-Bench Access
  • Corporate (LAN) and Remote (Field User) Access
    • Available via browser to anyone logged in (with user id)
    • No software to install
    • Works very well over phone lines
  • Portable Results … for Display at Remote Sites (Not Tethered to a Server)
    • Save reports to Excel, HTML or PowerPoint
    • Stand alone is available

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

net bench system
Net-Bench System
  • Seamless Integration Into your Environment
    • Standard “vanilla” web application
    • Internet Explorer, Firefox, Safari etc.
    • READ ONLY to your in house databases
    • Minimal or no requirements on in-house databases
    • Java Applet in browser
    • Java servlets
      • (Oracle Application Server, IBM WebSphere and Apache)
    • Heavy IRI/ACNielsen use requires two or more Windows computers

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

web service
Web Service
  • Net-Bench Sends Data Direct to your existing application
    • Excel dashboard
    • PowerPoint (Net-Point)
    • Uses INET.OCX and Net-Bench OLAP protocol
    • All the benefits of data integration (ACN, IRI, in house etc.)

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

net point
Net-Point

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

net point18
Net-Point
  • Automate your Powerpoint presentations
    • Browser based: users just go to web site (intranet)
    • Answer a few questions
    • Receive a customized deck, ready for presentation in minutes
  • Your own design - standardized
    • Category Reviews
    • Sales Presentations
  • Features
    • Charts
    • Tables
    • Intelligent text
    • Prompting
    • Variables

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

trade mix optimizer
Trade Mix Optimizer

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

trade mix optimizer overview
Trade Mix Optimizer - Overview
  • Trade Mix Optimizer is a sophisticated business tool
    • Determines drivers for your business
    • Analyzes where your trade promotion dollars are working
    • Quantifies the sales impact of each trade medium
  • All causal factors taken into account
    • Displays, Features, Price and FSI’s (your product and key competitors)
    • Holidays, Seasonal Factors and Weather
  • Granularity
    • Market or Account Level
    • SKU or promo group on product side
  • Primary Source of data
    • IRI/Nielsen, Adview, internal

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

trade mix optimizer benefits
Trade Mix Optimizer - Benefits
  • Planning tool for sales people
    • Not a trade management or short term demand planner
    • Once trade plan finalized results can be consolidated for demand forecasting
  • Easy to use - Excel Workbook
    • Sales reps can try different trade plans and see results immediately
    • Data plugs in the same trade plan as previous 52 weeks
      • End user can make changes and see results instantly
    • Create ‘what if’ scenarios to determine what has significant impact on sales
      • Do aisle displays have a significant impact on sales?
      • What happens when I switch trade dollars from a less effective medium?
      • What occurs when I increase the %ACV distribution?
  • Business Model Correlations
    • Between sales and each causal fact
    • Automatically rejects if poor correlation exists
    • Reports dollar impact for each fact
      • Per point of ACV distribution
      • Per dollar of price

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

net bench technology
Net-Bench Technology

Use as a Reporting tool…

Use as a Data Access engine…

  • A back-end data integration engine .
  • A web service interface with the ability to integrate multiple data sources including ACN®, IRI® and relational databases through any custom application.
  • An analytical report generating tool .
  • 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.

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

net bench 3 tier deployment
Net-Bench 3-Tier Deployment

SecurityDatabasesReportsDictionary

RDBMS

NB AdminService

NB SQLService

ACN

NB ACNService

BROWSER

NB IRIService

IRI

One server

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

slide24

Web Service Deployment

NB AdminService

RDBMS

SecurityDatabasesReportsDictionary

NB SQLService

M

NB SQLService

ACN

NB ACNService

M

M

M

NB ACNService

NB IRIService

M

IRI

M

NB DataService*

M= metadata only

*= data pulls, integration, load balancing

NB IRIService

http + - Nitro - Any Custom Application

One server

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

slide25

Net-Bench 4-Tier Deployment

NB AdminService

SecurityDatabasesReportsDictionary

RDBMS

NB SQLService

M

NB SQLService

M

ACN

M

BROWSER

NB ACNService

M

M

NB ACNService

NB IRIService

M

IRI

NB DataService*

NB IRIService

M= metadata only

*= data pulls, integration, load balancing

One server

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

slide26

Reports Folder

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

slide27

Start Browser, log in

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

slide28

Select a database

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

slide29

Select some markets

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

slide30

Nested list of brands within vendor within type within category

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

slide31

Time periods roll automatically

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

slide32

Select measures, can apply built in functions and formatting

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

slide33

Nested product report ranked by brand within vendor within type within category

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

slide34

Type a title and save the report template. Can export to Excel and to ‘Trade Mix Optimizer’

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

slide35

Net-Point ‘Designer’ mode: build a small presentation then request a customized version the browser

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

slide36

Log on

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

slide37

Select a database

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

slide38

Make this template using DOMINICK’S. Browser user will see this question when requesting customized version

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

slide39

After selecting from 4 dimensions, insert a pie chart

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

slide40

Connects directly to IRI, Nielsen, any relation database, SSAS cubes. This is a real chart, not a picture.

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

slide41

Added a second chart and ‘Intellitext’: picks up values from the charts.

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

slide42

Give the template a name and register it to the server.

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

slide43

“End user mode”: log on in the browser.

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

slide44

Pick a report: option to wait for it, or email to me later

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

slide45

This time, I pick JEWEL

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

slide46

Customized version comes back in a new browser

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

slide47

Custom version now show JEWEL data with new ‘Intellitext’ banner

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

slide48

How good is the model? Do we have all the causal drivers?

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

slide49

Running an FSI is worth $255 every week for every point of distribution. Raising price by $1.00 will lose $254 per week. Every competitor aisle display loses us $177

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

slide50

Real time planning sheet: change causal factors and see instant sales forecast

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

slide51

Increasing distribution to 100% for 5 weeks increases sales from $13,577 to $20,128

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

slide52

Top Level Integration

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

slide53

Drill-Down Screen #1

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

slide54

Drill-Down Screen #2

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

slide55

Drill-Down Screen #3

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

slide56

Drill-Down Screen #4

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