Monday, July 28, 2014

Finding Ways to Use Big Data to Help Small Shops


Brian Janezic at one of the Auto Wash Express car washes he owns in Tucson. Credit Chris Richards for The New York Times

Brian Janezic, 27, was in the equipment room of one of the two Auto Wash Express self-service locations he owns in Tucson, going through his cleaning supplies and vending machine items to determine what to reorder, when it hit him. “We have machines that automatically size and wash a car, mix chemicals, activate pumps, turn on lights — and here I am still counting inventory by hand.”

An online search introduced him to FileMaker Pro, a software product well suited to small businesses and tailored to the iPads that Mr. Janezic envisioned for himself and his three remote employees — not to mention the employees serving the six Arizona Auto Wash Express locations owned by his parents. “Now we can pull up any of our sites and see what’s on hand,” he said, adding that the FileMaker software “creates a PDF of a purchase order for us to send to one of our local suppliers or an online supplier.”

That was only part of the savings. Before Mr. Janezic installed sensors linked to FileMaker on each location’s eight drums of carwash chemicals — windshield bug removal solutions, pre-wash chemicals for tires, waxes, glass cleaners — monitoring use meant taking a yardstick to each drum, noting liquid levels and measuring again a week later. Gallons consumed divided by the number of cars washed told him how much of each solution was consumed per wash.
Mr. Janezic uses software to monitor fluid levels in the drums of carwash chemicals.  Credit Chris Richards for The New York Times
“Now we’re able to monitor those levels continuously,” he said. “So instead of having two data points in the span of a week, we’ll have 500 data points. And we can do that across our entire company. We might want to see how much pre-soak we’re using, because we have a standard we want to keep within.” So the new system improves quality control, and it can send a text message or email alert should, say, a valve stick open, potentially draining a $250 drum of soap.

A wealth of information that some call big data is becoming increasingly available to small businesses. Such information was once available only to big corporations with vast computing power and deep information technology departments — and more recently to online start-up companies with data-mining capabilities.

In 2010, just 1.7 percent of small businesses were using business intelligence software, according to a survey of companies with fewer than 100 employees conducted by IDC, whose analysts provide information technology advice to businesses small and large. By last year, 9.2 percent had adopted such tools, reported Ray Boggs, a small-business market analyst at IDC, citing easier-to-use products and lower prices as prime drivers of the increase.

“You don’t need a degree. You don’t need a manual,” said Ramon Ray, co-creator and host of the annual Small Business Summit, where entrepreneurs meet with technology and marketing experts. “You can drag and drop spreadsheets, upload a file — even from your phone. If you have fleets of vehicles, you run those vehicles better; you can staff better, because you know where your employees should be, and when. The new tools provide better customer insights, so you know better what to sell them or what not to sell them; you can see which of your products has the best profit margin. You don’t have to do things on gut check anymore.”

With price plans starting at $3 a user a month, one such software tool, Desk.com, helps small businesses address customer feedback — not just by pooling and parsing emails to customer service reps but also by monitoring Facebook feeds, Twitter comments and Yelp posts to help quell brush fires promptly.

“Say you’re a mom-and-pop dry cleaner and somebody says on Twitter, ‘My dry cleaner is terrible. They broke all my buttons,' ” said Leyla Seka, senior vice president and general manager of Desk.com. “That would show up in Desk. And then you could respond: ‘Sorry, please bring your shirts back and we’ll fix them immediately. And here’s a 20-percent-off coupon.’

Chris Mittelstaedt, founder of the FruitGuys, based in South San Francisco, Calif., said the software had helped his 90-employee company respond to and better interpret the 1,000 to 1,300 emails fielded weekly by customer service representatives. The FruitGuys sell fresh fruit to workplaces across the country. Until a year ago, before the company agreed to pay about $40 a month to Desk.com, its four customer service representatives tended to work in isolation. Now, a shared email inbox helps them to spot information and trends. It also speeds response time.

“Embarrassing as it is to admit, there’s some basic data that we didn’t have before, things like how many emails per week and our response time,” Mr. Mittelstaedt said. “It often took us over 24 hours to get back to people, which was not acceptable. Now, we’re getting back to customers and solving complicated issues within two hours.”

The company also gets helpful business intelligence, according to Nicole Wagner, who is the chief of customer service. “We’ll see trends,” she said, including late deliveries and multiple emails like, “ ‘Hey, we really loved the avocados this week’ — information we can pass on to our buyers.”

“We’ve always been able to get waitstaff check averages,” said Andy Husbands, who is chef and owner at Tremont 647, a 100-seat restaurant in Boston. “But now we’re able to bore down deeper.” On a new performance page for a star waiter named David, up popped a $5 brunch item, specialty pop tarts. Mr. Husbands realized David got virtually every Sunday morning table he served to order at least one. It was no surprise, then, that Mr. Husbands promptly invited David to share his pop-tart-selling prowess at a premeal staff meeting.

Mr. Husbands and his managers use such performance pages and other business metrics, many pertaining to customers, through a cloud-based tool called Swipely. Angus Davis, the founder and chief executive of Swipely, calls it “an affordable on-ramp to big data.” By replacing so-called payment processing companies that exist between merchants and the banks that issue consumer credit cards, Swipely gains access to a wealth of data, which it analyzes and presents on easy-to-understand dashboards, “more than half the time at little or no cost,” according to Mr. Davis.

“The crux of Swipely is using the data behind transactions to help businesses make smarter decisions — bringing the same tools and technologies that online companies have been using for years to the 95 percent of retail that happens off line,” Mr. Davis said. “We’ve built specialized tools for retailers and restaurants that answer the types of questions those small businesses have, like which item on their menu is most likely to turn a first-time customer into a repeat customer. But answering that question requires us to look at a tremendous amount of data.”

Examining his own data, in fact, prompted Mr. Janezic to look beyond his family’s Auto Wash Express locations. After enhancing his FileMaker Pro inventory management system on a different platform, he created a spinoff enterprise called WashStat, which he now sells to other carwash owners. That, too, is business intelligence.

No comments:

Post a Comment