Ben Penrose’s Post

According to our latest Irish Grocery Market Share report, Dunnes holds 23.2% market share with growth of 7.2% year-on-year. Dunnes growth stems mainly from more frequent trips and larger trips, which contributed a combined €42.7 million to its overall performance. Tesco holds 23.1% of the market, up 7.5% year-on-year. Tesco has the strongest trip frequency growth amongst all retailers for another consecutive month, up 6.7% year-on-year, contributing an additional €46.4 million to its overall performance. SuperValu holds 20.4% of the market with growth of 3.2%. SuperValu shoppers make the most trips in-store when compared to all retailers, an average of 21.6 trips. Explore the current and historical #GroceryMarketShare data on our interactive data viz: https://lnkd.in/e8iNAci5 Read the full article: https://lnkd.in/eVCymxad

🎤According to our latest Irish Grocery Market Share report, Dunnes holds 23.2% market share with growth of 7.2% year-on-year. Dunnes growth stems mainly from more frequent trips and larger trips, which contributed a combined €42.7 million to its overall performance. 🛒 Tesco holds 23.1% of the market, up 7.5% year-on-year. Tesco has the strongest trip frequency growth amongst all retailers for another consecutive month, up 6.7% year-on-year, contributing an additional €46.4 million to its overall performance. 🛍️ SuperValu holds 20.4% of the market with growth of 3.2%. SuperValu shoppers make the most trips in-store when compared to all retailers, an average of 21.6 trips. Explore the current and historical #GroceryMarketShare data on our interactive data viz: https://lnkd.in/eR8qG3zy Read the full article: https://lnkd.in/eRMKuYdF

Did my second project in excel by creating a dashboard for managing the sales in a supermarket. The Supermarket Dashboard provides a comprehensive view of sales data, empowering smarter decisions and driving success in every aisle. From the dashboard we can get the total income, total number of orders and overall rating. We can also get the Gross income by customer type, Gender, City, Branch of store, Product Type and Month. I was also able to make the dashboard interactive by addition of slicers such as city, branch, customer type and gender. Slicers are added to get specific information in the dashboard.

According to our latest Irish Grocery Market Share report, Dunnes holds 23.2% market share with growth of 7.2% year-on-year. Dunnes growth stems mainly from more frequent trips and larger trips, which contributed a combined €42.7 million to its overall performance. Tesco holds 23.1% of the market, up 7.5% year-on-year. Tesco has the strongest trip frequency growth amongst all retailers for another consecutive month, up 6.7% year-on-year, contributing an additional €46.4 million to its overall performance. SuperValu holds 20.4% of the market with growth of 3.2%. SuperValu shoppers make the most trips in-store when compared to all retailers, an average of 21.6 trips. Explore the current and historical #GroceryMarketShare data on our interactive data viz: https://lnkd.in/errc8aGr Read the full article: https://lnkd.in/eHTVZ84V

According to our latest Irish Grocery Market Share report, Dunnes holds 23.2% market share with growth of 7.2% year-on-year. Dunnes growth stems mainly from more frequent trips and larger trips, which contributed a combined €42.7 million to its overall performance. Tesco holds 23.1% of the market, up 7.5% year-on-year. Tesco has the strongest trip frequency growth amongst all retailers for another consecutive month, up 6.7% year-on-year, contributing an additional €46.4 million to its overall performance. SuperValu holds 20.4% of the market with growth of 3.2%. SuperValu shoppers make the most trips in-store when compared to all retailers, an average of 21.6 trips. Explore the current and historical #GroceryMarketShare data on our interactive data viz: https://lnkd.in/ddqzYuJV Read the full article: https://lnkd.in/ddh63rUe

#30daysExcelChallenge Update on Day 16 Question: Use the Supermarket data shared with you to create a dashboard with the following metrics; • Total Sales • Quantity Sold by Product line • Total Cogs • Quantity Sold by Branch • Total Profit • Sales by City • Sales by Gender & Payment Type • Sales by payment type •Quantity total The time we had to create this was quite short but I was able to come up with this dashboard and It was really worth the time. P.S: This is my second time creating an excel dashboard. Might share the first one here soon.

This fact is shocking but true: In some cases, 𝐨𝐯𝐞𝐫 𝟕𝟎% 𝐨𝐟 𝐝𝐞𝐚𝐥𝐞𝐫 𝐫𝐞𝐜𝐨𝐫𝐝𝐬 𝐚𝐫𝐞 𝐢𝐧𝐚𝐜𝐜𝐮𝐫𝐚𝐭𝐞. That means lost revenue, irrelevant offers, and countless missed opportunities. If this were happening in retail, imagine how many customers a supermarket would lose! 𝐓𝐇𝐈𝐍𝐊: When you send out your next offer, are you reaching the right person, and do they still own the vehicle? If you're a dealer and you're not regularly cleansing your data, we’d love to understand: 𝐖𝐇𝐘 𝐍𝐎𝐓? 𝐑𝐞𝐚𝐝 𝐭𝐡𝐞 𝐟𝐮𝐥𝐥 𝐚𝐫𝐭𝐢𝐜𝐥𝐞 𝐭𝐨 𝐝𝐢𝐬𝐜𝐨𝐯𝐞𝐫 𝐭𝐡𝐞 𝐢𝐦𝐩𝐚𝐜𝐭 𝐨𝐟 𝐝𝐢𝐫𝐭𝐲 𝐝𝐚𝐭𝐚 𝐚𝐧𝐝 𝐡𝐨𝐰 𝐚𝐝𝐝𝐫𝐞𝐬𝐬𝐢𝐧𝐠 𝐢𝐭 𝐜𝐚𝐧 𝐮𝐧𝐥𝐨𝐜𝐤 𝐡𝐢𝐝𝐝𝐞𝐧 𝐫𝐞𝐯𝐞𝐧𝐮𝐞: https://lnkd.in/eG5NJ3qf

𝐈 𝐚𝐦 𝐚 𝐭𝐡𝐢𝐞𝐟. There, I said it. When I was 8, I purchased a trinket tray as a souvenir from a holiday in Cornwall with my pocket money I saved up. I got home and realised I had actually picked up two by mistake. 😱𝐓𝐡𝐞 𝐡𝐨𝐫𝐫𝐨𝐫!😱 Well, for fear of arrest 👮 and certain social banishment 🚫, the next morning I took back the spare. Lucky I did, or I would've contributed to that store's shrinkage record. 🔍 𝐎𝐮𝐫 𝐃𝐞𝐞𝐩 𝐃𝐢𝐯𝐞: 𝐒𝐨𝐥𝐮𝐭𝐢𝐨𝐧𝐬 𝐭𝐨 𝐑𝐞𝐝𝐮𝐜𝐞 𝐒𝐡𝐫𝐢𝐧𝐤 Sadly, the shrinkage problem we face today isn't due to innocent 8 year olds making honest mistakes. It is an increasing problem for retailers & it spans far wider than in-store theft. It isn't just retailers feeling the heat either, it is having a big impact on brands. 𝐒𝐨, 𝐰𝐡𝐚𝐭 𝐜𝐚𝐧 𝐲𝐨𝐮 𝐝𝐨? We’ve dissected shrink factors across 𝐜𝐨𝐫𝐩𝐨𝐫𝐚𝐭𝐞, 𝐬𝐮𝐩𝐩𝐥𝐲 𝐜𝐡𝐚𝐢𝐧, 𝐞-𝐜𝐨𝐦𝐦𝐞𝐫𝐜𝐞, 𝐚𝐧𝐝 𝐢𝐧-𝐬𝐭𝐨𝐫𝐞 𝐨𝐩𝐞𝐫𝐚𝐭𝐢𝐨𝐧𝐬. Curious?🤔 𝐒𝐞𝐞 𝐭𝐡𝐞 𝐫𝐞𝐩𝐨𝐫𝐭: The efficiency imperative: solutions to reduce shrink https://bit.ly/45bwlKv 🔒 𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬!  Speaking of shrinkage, you'll need to subscribe to see this particular report. Drop me a DM to find out more! 📲 #FMCG #Shrink #Shrinkage #Retail #Stores #Grocery #brands #privatelabel #UkRetail

Out on watch to observe how the numbers we are crunching all day are actually collected. Learned the complete methodology of direct collection of retail data. Thank you Rizwan Hafeez for guiding the field visit, and Kamran Zafar for arranging it #retailanalytics #retaildata

🔍 EPOS Data | If you could visit only one point of sale, which one would it be? It sounds like a tough choice - but with EPOS data, you can determine exactly where your visit will have the most impact. By analyzing Lost Sales Value (the potential turnover you’re missing out on), EPOS insights guide you straight to the locations that add the most value. Every visit counts. Make sure it’s the right one. 📈 Curious about how data can change the way you work with retailers? Read our complete article on the power of EPOS Data : https://lnkd.in/eQjXRmmq #roamler #data #retail