Syndicated Data / Report Automation

1
(No Transcript)
2
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 ScanFact PC
• Helped design PLDBS
• Author of NITRO relational access (ACCT PLNR,
  DATABANK)

3
About Ironbridge Software...
4
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

5
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

6
Net-Bench
7
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

8
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

9
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

10
Net-Bench Batch Reporting

• Timely distribution to users
• Reports always refresh
• Use night time batch for mass production
• E-mail notification

11
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

12
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

13
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

14
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

15
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

16
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.)

17
Net-Point
18
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

19
Trade Mix Optimizer
20
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 FSIs (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

21
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

22
Net-Bench Technology
Use as a Data Access engine
Use as a Reporting tool

• An analytical report generating tool .
• A browser-based user interface with the ability
  to access multiple data sources including ACN,
  IRI and relational databases.

• 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.

Access from any browser with connections to your
environment.
23
Net-Bench 3-Tier Deployment
SecurityDatabasesReportsDictionary
RDBMS
NB AdminService
NB SQLService
ACN
NB ACNService
BROWSER
IRI
NB IRIService
One server
24
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
NB IRIService
M metadata only data pulls, integration,
load balancing
http - Nitro - Any Custom Application
One server
25
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
IRI
M
NB DataService
NB IRIService
M metadata only data pulls, integration,
load balancing
One server
26
Reports Folder
27
Start Browser, log in
28
Select a database
29
Select some markets
30
Nested list of brands within vendor within type
within category
31
Time periods roll automatically
32
Select measures, can apply built in functions and
formatting
33
Nested product report ranked by brand within
vendor within type within category
34
Type a title and save the report template. Can
export to Excel and to Trade Mix Optimizer
35
Net-Point Designer mode build a small
presentation then request a customized version
the browser
36
Log on
37
Select a database
38
Make this template using DOMINICKS. Browser
user will see this question when requesting
customized version
39
After selecting from 4 dimensions, insert a pie
chart
40
Connects directly to IRI, Nielsen, any relation
database, SSAS cubes. This is a real chart, not
a picture.
41
Added a second chart and Intellitext picks up
values from the charts.
42
Give the template a name and register it to the
server.
43
End user mode log on in the browser.
44
Pick a report option to wait for it, or email to
me later
45
This time, I pick JEWEL
46
Customized version comes back in a new browser
47
Custom version now show JEWEL data with new
Intellitext banner
48
How good is the model? Do we have all the causal
drivers?
49
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
50
Real time planning sheet change causal factors
and see instant sales forecast
51
Increasing distribution to 100 for 5 weeks
increases sales from 13,577 to 20,128
52
Top Level Integration
53
Drill-Down Screen 1
54
Drill-Down Screen 2
55
Drill-Down Screen 3
56
Drill-Down Screen 4