The steps this start-up took to analyze their data from Woocommerce so they could make valuable business decisions.
Last year when my wife launched SendACarePackage.com, an e-commerce site for sending high quality care packages to college students, I became the de-facto CIO. Our search for an e-commerce platform led us to pick Woocommerce*.
Once we launched the site and built some sales history we knew we needed to analyze the data. We needed to know what products were selling so we could control inventory and expand product lines. We also needed to know how much to spend on advertising. And we wanted to see if people were using custom features we built into Woocommerce.
We needed something that would get us answers fast without having to spend a ton of time or money. As the leader of the Qlik Practice for Analytics8 (one of Qlik’s largest resellers), I was naturally inclined to select Qlik Sense, the latest offering by Qlik, for the task; thankfully I wasn’t disappointed when my wife’s business was on the line.
Mind you, this is just a couple of attributes for a single order. Imagine that for 50 or more attributes of an order: customer name, bill to, ship to, order date, amount, shipping, etc. for a whole bunch of orders. Then do the same thing for product attributes and other data you’d want to report on.
This meant I had to transform the data to report on it. The transformation would have been difficult to impossible with other tools. With Qlik Sense it was as simple as using the GENERIC keyword in my load statement; no data warehouse needed. I’m not a hardcore developer so I did get some help from the Qlik Community here: https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic
Now that I had my data transformed I was able to create a few dashboards to help my wife run her business. Through the power of the associative data model some interesting things came to light and we were able to:
By uncovering these facts, my wife and I were able to refine our product offerings, better manage inventory, align the right mix of products, be more strategic in our marketing efforts, and rearrange our website to increase sales. We’re excited to continue building on the dashboard. As we add in affiliate tracking, google analytics data, and more, I will keep updating the app and keep posting here. Of course, as a startup, I have to be careful what I share but I am happy to talk to any non-competitors in detail about how to connect to Woocommerce so you can start visualizing your data and how those visualizations can help you make better decisions.
To find our more about how Analytics8 and Qlik Sense can help you leverage your data visit the Analytics8 web site.
*According to builtwith.com Woocommerce is the most popular ecommerce platform (http://trends.builtwith.com/shop select entire internet).