ReachFarther Builds Excel WalMart Panel Data Application for Pep

During the first quarter of 2008, ReachFarther developed an Excel-based reporting tool based on Wal-Mart panel data for PepsiCo.

The Excel-based format might not be as “sexy” as some newer technologies, but it allows large corporations with rigid IT infrastructures to create very powerful analytic applications. More importantly, the end product works entirely within the existing software configuration run by Sales and Category Development, and blessed by IT. In many cases, this means the tools can be developed without the assistance of IT entirely.

For years Microsoft Office applications like Word, Excel, PowerPoint, and Access have been able to share information using VBA, Microsoft Visual Basic for Applications. This application-based programming language makes it possible to leverage the strengths of each of the Office tools to produce some very powerful packages. For PepsiCo, the syndicated data is stored in an Access database and Microsoft Excel executes dynamic SQL statements against the data source to generate a series of 20 standard graphs within Excel. These graphs are completely automated based on a number of dropdown menu selections made on a master control panel.

The real power of this configuration is that the two files can be distributed within the PepsiCo network via email and saved to each user’s computer. Each individual user can then generate the standard reports based on only the markets, measures, and demographic groups that are important to their business. The charts are also generated on the fly, which makes producing comparison decks fast and easy.

With the integration between Microsoft Office applications we discussed above, the charts can simply be cut-and-pasted from Excel right into presentation decks built in PowerPoint. This simple application makes it easy for Sales and Category Development to spin syndicated data quickly and easily to add real internal value, and drive sales and marketing efforts within each retailer.

ReachFarther worked closely with our vendor partner Hudson Analytics who provided invaluable information architecture design for the final product. Their expertise with syndicated data, specifically shopper insights and panel products, added the analytic punch to the application that makes it a truly valuable tool.

Other News

ReachFarther Selected as Best Web Design Agency in NJ!

The Top 13 New Jersey Web Design Agencies of 2019, According to DesignRush Studies show that 62 percent of companies can increase sales by creating responsive mobile-friendly interfaces for their website. DesignRush rounded up the best New Jersey website design...

When You Need It Done Right and Done Quickly

So you’re faced with an insanely tight deadline in order to produce a print advertisement that’s going to run in a full-color publication, you’ve got no copy, no creative, and only a high-level idea. What do you do? You call ReachFarther of course. Houston,...

Simplify Your Video Content with Vimeo

We work with a number of clients that rely heavily on video in marketing efforts, and during the early 2000’s rendering those videos online had been cumbersome process. We were basically stuck with Flash as one of the only consistent means of providing...

SQL Server 2008 FREETEXTTABLE Returns Zero Values

We recently migrated a database from SQL Server 2005 to SQL Server 2008 and ran into unexpected problems with the search results returned by FREETEXTTABLE queries that had worked fine for years in SQL 2005. Specifically, the FREETEXT TABLE RANK column returned zero...