GlobalElec Sales Insights with PowerBI
4 hidden cells
🧾 Executive summary
GlobalElec's sales were gradually increasing from 2016, and topped in late 2019, before drastic decrease due to COVID-19 pandemic in 2020.
On-site stores in the United States made $23.76M, or 41.3% of total revenue.
Online sales noted steady increase, from 16.92% in 2016 to 22.1% in 2020, and jumping to 27.26% in 2021, possibly due to pandemic restrictions.
For the whole time, the profit margin showed good results, ranging from 0.547 to 0.553 on a quarterly basis. In 2021 Q1, Australia noted 0.563 profit margin.
For all age groups of customers, Computers is the most popular category. The youngest (18-24 years old) prefer white items, while everyone older tends to buy black electronic devices.
📷 Main dashboard screenshot
🌐 Additional dashboards
Thanks for reading my work! Upvote it if you found this useful.