Updated Makeup Inventory – Category and Cost Analysis

I first posted my makeup inventory analysis last March but there have been a lot of changes in my collection since then which served as an excuse for me to spend a day playing with Tableau. For the most part, I’ll follow last year’s template to go through this but if you have any other ideas on how to make this more insightful, please let me know. I’m definitely into analytics and updating this inventory definitely helped me get a better overview of my collection and pinpoint some problem areas. Continue reading “Updated Makeup Inventory – Category and Cost Analysis”

Makeup Inventory – Category and Cost Analysis

Did I mention that I have a slight compulsion towards spreadsheets? And while I have used one to track my wardrobe inventory last year, I finally decided to pull one together for my makeup collection. I feel like to some extent ‘makeup inventory’ is just the new makeup collection concept but it wouldn’t be me if I didn’t let some of my work analysis creep into this. Like my wardrobe inventory, I have Excel spreadsheet set up for every single makeup product I own but in no way will I be able to track cost per wear, nor do I find it necessary. For the purpose of this post, I have focused on yearly spending, category breakdown and threw in a brand diagram as a bonus. Continue reading “Makeup Inventory – Category and Cost Analysis”