One of our very first data marts back in 1997 was for an Oregon retailer with 120 locations. Since that time we've worked on projects with many different types of retailers including; clothing, convenience items, home improvement, exercise equipment and building products. Every project has given us new insight into particular aspects of this industry.

Based on this broad and deep experience Perkins Consulting has developed insight into the key issues for retailers around such topics as seasonality, workforce planning, scheduling, forecasting and complex product hierarchies.

For specific retail services check out our RetailSolutions360 website.

Case Studies

  • Developed a large data warehouse for a convenience store chain with over 120 locations that provided detailed access to data on point of sale data, lottery ticket sales and fuel sales by date, product, location, employee, shift, tendor type and more.
  • We deployed multi-dimensional analysis using Cognos PowerPlay for a building materials retail company that allowed them access to detailed sales information from each of their locations across three states on a daily basis.
  • Developed a data warehouse that integrated inventory and sales information for a multi-channel clothing retailer.
  • Developed a sophisticated web-based analysis tool for a home improvement retailer that allowed them to access just under a billion rows of transaction data with less than two second response times.
  • Helping a leading retailer of exercise equipment deploy IBM Cognos business intelligence tools and apply them in complex reports against an Oracle data warehouse.
  • Worked with a regional multi-location furniture retailer to tune their nightly OLAP cube builds using IBM Cognos Transformer.
  • Updated several critical and complex custom Windows applications for a home improvement retailer to leverage consistent integrated authentication, authorization management using the Microsoft Enterprise Library and secured access to Microsoft SQL Server databases.
  • We developed new custom reporting applications for an organization providing outsourced product expertise to electronics retailers.