About Ironbridge Ironbridge Software has been around since 1985 Located in Chicago IL we also have an office New Jersey Started as a consultant for the Nielsen Company in the mid 1980s What do we do Ironbridge is both a software developer and consultant in the CPG industry ID: 593870
Download Presentation The PPT/PDF document "Getting Insights from Big Data" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Getting Insights from Big DataSlide2
About Ironbridge
Ironbridge Software has been around since 1985
Located in Chicago, IL we also have an office New Jersey
Started as a consultant for the Nielsen Company in the mid 1980’s
What do we do? Ironbridge is both a software developer and consultant in the CPG industrySlide3
Big Data or Data Science
“In the last couple of years, there is a new term for Big Data, now it’s called “Data Science”. I can all myself a Data Scientist which sounds a whole lot fancier than Big Data Geek.”Slide4
What is an INSIGHT?
Answer: Something I can take action on.
Bottom up not top downSlide5Slide6
POS Data Issues
Fragmented category
1,000+ brands in department stores
3,400+ collectively in all channels
34 POS retailers
Different syndicated data providers
Department stores and
midtier
from NPD
FDMx
from IRI
Multiple upcs/skus for single itemMultiple vendors and different packagingVarious sizes/promotions by channelCompiling shipment and POS upcsNo single source for item file attributes, over 68,000+ upcsData disparityData extraction methods (EDI, Excel files, download from web access)Different formats (upc/sku, inventory, promo activity, WE dates)Different granularity (daily/weekly/monthly, total/store)Minimal IT supportOnly servicing department store dataCategory Management accessCategory data, not just vendorStrict limited data access standards mandated by Retailers
69 upcs for White Diamonds 1.0 oz !Slide7
Consolidation Benefits
Consolidated location of all data:
Retailer and Syndicated POS
Shipments and Retail Plans
Security:
Access limited by ID
Backed-up, following IT guidelines
Time efficiency:
No time spent on downloads and uploads by category manager
Aggregated totals available immediately
Consistent hierarchy view across all sources of data while maintaining retailer viewSlide8
Netbench
Benefits
SAAS solution doesn’t clog IT team
Ability to reload error files, process restatements
Ease of functionality in reporting tool
Effectively manage large amounts of data
Allows for rapid response in meeting changing Retailer and/or business reporting requirements
System is used across multiple customer channels and geographies (Canada & Europe)Slide9
Sample ReportingSlide10
Data Use and Insights
Dot com vs. Brick and Mortar reporting (account/brand)
Frequent reporting to adjust to strategy
Forecasting across all accounts
Allows for easier projection of launches
Store level analysis view and segmentation
Helps improve ST% on future displays/programs
Brand performance across channels
Direct spend to right customersSlide11Slide12
Insights
Major Cost Savings
Our client is a manufacturer of salad dressings. Scheduling production of the different flavors is determined by the anticipated demand for each. The demand forecast had an accuracy rate of only 38%. Ironbridge built a multiple regression model with weekly sales history for 3 years and every trade promotion during that period. Then by plugging in the trade promotion plan for the next 6 months, we produced a new demand forecast. The model’s accuracy rate was 48%. Just that 10 point improvement enabled the client to schedule production more effectively and to avoid building an entirely new plant. Major cost savings.Slide13
Insights Slide14
Insights
Uncovering New Markets
Our client delivers bottled water to homes nationwide. They have a database of every home served with address and zip code. By comparing population density from the U.S. census data we were able to uncover underserved markets across the country. Further, since this is a premium service by comparing household income we were able to identify the best opportunities for new sales.
http://ibsw.com/insights.htmlSlide15
We bridge the gap between category management & Information Technology.
We are recognized experts in category management, syndicated data and large scale data management systems needed to solve your individual data needs. Slide16
Follow Ironbridge Software
www.ibsw.com