1 / 56

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

RoyLauris
Download Presentation

About Ironbridge Software...

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

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

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

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  6. Net-Bench Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

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

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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.) Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  17. Net-Point Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  19. Trade Mix Optimizer Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

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

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

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

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

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

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

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

  27. Start Browser, log in Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  28. Select a database Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  29. Select some markets Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  30. Nested list of brands within vendor within type within category Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  31. Time periods roll automatically Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  32. Select measures, can apply built in functions and formatting Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  33. Nested product report ranked by brand within vendor within type within category Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

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

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

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

  37. Select a database Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

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

  39. After selecting from 4 dimensions, insert a pie chart Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

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

  41. Added a second chart and ‘Intellitext’: picks up values from the charts. Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  42. Give the template a name and register it to the server. Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  43. “End user mode”: log on in the browser. Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  44. Pick a report: option to wait for it, or email to me later Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  45. This time, I pick JEWEL Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  46. Customized version comes back in a new browser Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  47. Custom version now show JEWEL data with new ‘Intellitext’ banner Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  48. How good is the model? Do we have all the causal drivers? Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  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 Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

  50. Real time planning sheet: change causal factors and see instant sales forecast Ironbridge Software, Inc. | Software & Consulting Services to the Consumer Goods Industry.

More Related