Electrify your insights with BI
📖 Background
Equipment, such as computers and smartphones, is widely available today, and the global consumer electronics market generated an impressive $950 billion in revenue in 2024.
What better way than to utilize your BI skills on a dataset related to this vast industry? As a BI analyst for GlobalElec, a leading global electronics retailer, you will help analyze and visualize the company’s sales data, covering customers, products, sales, stores, and international exchange rates.
Your task is to uncover trends like the dominance of telephony, the rise of online sales, and regional market leaders while crafting impactful dashboards in a BI tool of your choice.
Showcase your ability to transform raw data into actionable insights and shape the future of GlobalElec!
💾 The data
The data can be downloaded from the Files section (File > Show workbook files).
| Group | Column name | Dataset | Definition |
|---|---|---|---|
| Customers | CustomerKey | Customers.csv | Primary key to identify customers |
| Customers | Gender | Customers.csv | Customer gender |
| Customers | Name | Customers.csv | Customer full name |
| Customers | City | Customers.csv | Customer city |
| Customers | State Code | Customers.csv | Customer state (abbreviated) |
| Customers | State | Customers.csv | Customer state (full) |
| Customers | Zip Code | Customers.csv | Customer zip code |
| Customers | Country | Customers.csv | Customer country |
| Customers | Continent | Customers.csv | Customer continent |
| Customers | Birthday | Customers.csv | Customer date of birth |
| Products | ProductKey | Products.csv | Primary key to identify products |
| Products | Product Name | Products.csv | Product name |
| Products | Brand | Products.csv | Product brand |
| Products | Color | Products.csv | Product color |
| Products | Unit Cost USD | Products.csv | Cost to produce the product in USD |
| Products | Unit Price USD | Products.csv | Product list price in USD |
| Products | SubcategoryKey | Products.csv | Key to identify product subcategories |
| Products | Subcategory | Products.csv | Product subcategory name |
| Products | CategoryKey | Products.csv | Key to identify product categories |
| Products | Category | Products.csv | Product category name |
| Sales | Order Number | Sales.csv | Unique ID for each order |
| Sales | Line Item | Sales.csv | Identifies individual products purchased |
| Sales | Order Date | Sales.csv | Date the order was placed |
| Sales | Delivery Date | Sales.csv | Date the order was delivered |
| Sales | CustomerKey | Sales.csv | Unique key identifying which customer ordered |
| Sales | StoreKey | Sales.csv | Unique key identifying which store processed |
| Sales | ProductKey | Sales.csv | Unique key identifying which product purchased |
| Sales | Quantity | Sales.csv | Number of items purchased |
| Sales | Currency Code | Sales.csv | Currency used to process the order |
| Stores | StoreKey | Stores.csv | Primary key to identify stores |
| Stores | Country | Stores.csv | Store country |
| Stores | State | Stores.csv | Store state |
| Stores | Square Meters | Stores.csv | Store footprint in square meters |
| Stores | Open Date | Stores.csv | Store open date |
| Exchange Rates | Date | Exchange_Rates.csv | Date |
| Exchange Rates | Currency | Exchange_Rates.csv | Currency code |
| Exchange Rates | Exchange | Exchange_Rates.csv | Exchange rate compared to USD |
💪 Challenge
Using any BI tool you have access to, create interactive visuals and a dashboard to summarize your research. Things to consider:
- Use this Workspace to prepare your data (optional).
- Some ideas to get you started (Don't feel limited by these, you're encouraged to use your skills to consolidate as much information as possible):
- Which countries or regions contribute the most to overall revenue?
- Which product categories and regions yield the highest profit margins?
- Are there patterns or changes in delivery times across different regions or product categories?
- Create a screenshot of your main dashboard/visuals, and paste that into the designated field.
- Summarize your findings in an executive summary.
✍️ Judging criteria
This is a community-based competition. The top 5 most upvoted entries will win.
The winners will receive DataCamp merchandise.
🧾 Executive summary
In a couple of lines, write your main findings here.
GolabelTech Sales Overview (Jan 2016 - Feb 2021)
Total Sales: GolabelTech achieved impressive sales of $55.35 million over the period from January 2016 to February 2021, reflecting strong market performance.
Profit Performance: The company maintained an average profit margin of 41.2%, translating into substantial profitability.
Sales Distribution: More than half of the total profit, specifically 53.9%, originated from the United States, contributing $29.78 million in sales. This highlights the U.S. market as a critical driver of revenue.
Online Sales Impact: Online sales have played a significant role, representing 20.62% of the company's overall profit. This underscores the importance of e-commerce in GolabelTech's business model.
Shipping Efficiency: The average shipping time is 4.6 days, indicating effective logistics for regular shipping. However, it is noted that some shipments can take as long as 17 days, suggesting room for improvement in delivery times for certain orders.
Product Categories:
- Games and Toys: This category boasts the highest profit margin at 45.34%, with total sales reaching $718,600. This indicates strong demand and pricing power in this segment.
- Home Appliances: Washers and dryers from the home appliance category generate the highest average profit per unit, amounting to $3,341. This highlights the profitability of these essential items.
Customer Demographics:
Approximately 50% of total sales are attributed to customers aged 55 and ol der. This demographic insight can inform marketing strategies and product offerings tailored to this age group.
Sales Trends:
Notably, the year-over-year (YoY) percentage of total sales has shown a continuous decline since 2019, indicating potential challenges in maintaining sales growth.
📷 Dashboard screenshot
🌐 Upload your dashboard
Ideally, paste your link to your online available dashboard here.
Otherwise, upload your dashboard file to the Files section (File > Show workbook files).**