Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.
Download
1 / 56

Software Products - PowerPoint PPT Presentation


  • 359 Views
  • Updated 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 'Software Products' - RoyLauris


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 l.jpg
About Ironbridge Software... to the Consumer Goods Industry.

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 l.jpg
About Ironbridge Software... to the Consumer Goods Industry.

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


Software products l.jpg
Software Products to the Consumer Goods Industry.

  • 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 l.jpg
Ironbridge Strategy - Economic Environment to the Consumer Goods Industry.

  • 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 l.jpg
Net-Bench to the Consumer Goods Industry.

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


Net bench7 l.jpg
Net-Bench to the Consumer Goods Industry.

  • 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 l.jpg
Net-Bench Reporting to the Consumer Goods Industry.

  • 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 l.jpg
Net-Bench Collaborative Publishing to the Consumer Goods Industry.

  • 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 l.jpg
Net-Bench Batch Reporting to the Consumer Goods Industry.

  • 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 l.jpg
Net-Bench Security to the Consumer Goods Industry.

  • 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 l.jpg
Net-Bench Relational Mapping to the Consumer Goods Industry.

  • 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 l.jpg
Net-Bench Integration to the Consumer Goods Industry.

  • 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 l.jpg
Net-Bench Access to the Consumer Goods Industry.

  • 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 l.jpg
Net-Bench System to the Consumer Goods Industry.

  • 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 l.jpg
Web Service to the Consumer Goods Industry.

  • 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 l.jpg
Net-Point to the Consumer Goods Industry.

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


Net point18 l.jpg
Net-Point to the Consumer Goods Industry.

  • 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 l.jpg
Trade Mix Optimizer to the Consumer Goods Industry.

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


Trade mix optimizer overview l.jpg
Trade Mix Optimizer to the Consumer Goods Industry. - 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 l.jpg
Trade Mix Optimizer to the Consumer Goods Industry. - 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 l.jpg
Net-Bench Technology to the Consumer Goods Industry.

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 l.jpg
Net-Bench 3-Tier Deployment to the Consumer Goods Industry.

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 l.jpg

Web Service Deployment to the Consumer Goods Industry.

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 l.jpg

Net-Bench 4-Tier Deployment to the Consumer Goods Industry.

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 l.jpg

Reports Folder to the Consumer Goods Industry.

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


Slide27 l.jpg

Start Browser, log in to the Consumer Goods Industry.

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


Slide28 l.jpg

Select a database to the Consumer Goods Industry.

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


Slide29 l.jpg

Select some markets to the Consumer Goods Industry.

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


Slide30 l.jpg

Nested list of brands within vendor within type within category

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


Slide31 l.jpg

Time periods roll automatically category

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


Slide32 l.jpg

Select measures, can apply built in functions and formatting category

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


Slide33 l.jpg

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

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


Slide34 l.jpg

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 l.jpg

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 l.jpg

Log on then request a customized version the browser

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


Slide37 l.jpg

Select a database then request a customized version the browser

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


Slide38 l.jpg

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 l.jpg

After selecting from 4 dimensions, insert a pie chart see this question when requesting customized version

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


Slide40 l.jpg

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 l.jpg

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

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


Slide42 l.jpg

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

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


Slide43 l.jpg

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

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


Slide44 l.jpg

Pick a report: option to wait for it, or email to me later from the charts.

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


Slide45 l.jpg

This time, I pick JEWEL from the charts.

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


Slide46 l.jpg

Customized version comes back in a new browser from the charts.

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


Slide47 l.jpg

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

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


Slide48 l.jpg

How good is the model? Do we have all the causal drivers? ‘Intellitext’ banner

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


Slide49 l.jpg

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 l.jpg

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

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


Slide51 l.jpg

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 l.jpg

Top Level Integration from $13,577 to $20,128

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


Slide53 l.jpg

Drill-Down Screen #1 from $13,577 to $20,128

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


Slide54 l.jpg

Drill-Down Screen #2 from $13,577 to $20,128

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


Slide55 l.jpg

Drill-Down Screen #3 from $13,577 to $20,128

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


Slide56 l.jpg

Drill-Down Screen #4 from $13,577 to $20,128

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


ad