When a business owner first considers incorporating dynamic data-driven analysis into their routine management, the prospect can sometimes seem overwhelming. Technology infrastructure, mobile app development, real-time updates – where do you start first? It’s easy to forget that all you really need to begin on a small scale are a computer, a phone, and tools such as Power BI and Power Apps.
Just ask incoming Seattle high school seniors Julia Reguera, 16, and Ava Zech, 17. Earlier this summer, Julia and Ava launched a fashion-forward, charitable thrift store in downtown Las Vegas called Hand Me Ups. The store is stocked with brand name clothing donated from classmates and social media followers, with 100 percent of the proceeds going to multiple charities such as the Environmental Defense Fund, Rape Crisis Center, and the Nevada Childhood Cancer Foundation.
How do they track their sales, inventory, and donations? With Power BI and Power Apps! We talked with Julia (who also happens to be the daughter of Microsoft Principal Program Manager and Power BI evangelist Marc Reguera) about how Hand Me Ups implemented their data analytics, and how it’s working out for this unique seasonal business.
What data are you tracking from the Hand Me Ups storefront?
J: I track every single sale transaction. I do this so I can know the exact time of sale, the number of items sold, as well as the price of each item.
How do you collect this data, and how easy was it to get the technology running in the store?
J: Each sale transaction is recorded using Square, which is very easy to use with my cell phone. I download the data after we close from Square as an Excel workbook. Then, I append that data every day into a Power BI file on my OneDrive, and then I simply refresh my file on the Power BI service.
Tell us about the process of picking which numbers to track and what features you wanted in the point of sale system.
J: I helped design the Power App by describing what I needed to do for every sale we did. Every time we make a sale, we ask the buyer to choose which charities they’d like us to donate the proceeds of the sale. Once they pick one of the 12 charities we offer, we need to enter the amount of the sale. The app needed to: 1) let me select one of the 12 charities, and 2) enter an amount towards that charity.
For the dashboard, I needed to know not only how many sales we made, but also more importantly our profit, because in the end that is what we give to charities.
CLICK HERE to read the full article and find out how Power BI is helping Hand Me Ups keep track of their data analytics!
To learn more on how Tallan can transform your data analytics into actionable insights and help you maximize profitability, CLICK HERE.