San Francisco Revenue Analysis
San Francisco is the clear leader in revenue generation for Priscables Electronics, making approximately $8 million in total sales. This is significantly higher than other major cities like Los Angeles and New York, which follow at a considerable distance.
The dominant performance of San Francisco suggests a strong market presence and customer base in the area. This could be attributed to demographic factors, higher disposable income, stronger brand recognition, or more effective local marketing efforts.
Monthly Sales Analysis
December stands out as the highest revenue month with approximately $4.5 million in sales, likely due to holiday shopping. This is followed by October and November, suggesting that the fourth quarter is particularly strong for sales.
This seasonal pattern provides valuable timing information for inventory planning and promotional campaigns. The significant increase in Q4 sales presents an opportunity to optimize resource allocation throughout the year.
Top Revenue Generating Products
While batteries sell in higher quantities, MacBook Pro Laptops, iPhones, and ThinkPad Laptops generate the most revenue. These high-ticket items contribute significantly to overall business performance despite lower sales volumes.
The stark difference between top-selling products and top revenue-generating products highlights the importance of maintaining a balanced product mix. High-value items are critical for revenue targets.
Hourly Sales Patterns
The data reveals two distinct peak shopping periods: mid-day (11 AM to 1 PM) and evening (6 PM to 8 PM). These times correspond to lunch breaks and after-work hours when customers are most active online.
The highest sales occur at 12 PM (noon) and at 7 PM, making these optimal times for running promotional activities. This pattern is consistent across weekdays, with slight variations on weekends.
Price-Volume
There’s a clear inverse relationship between price and order quantity. Lower-priced items like batteries sell in much higher volumes, while expensive items like laptops sell in smaller quantities.
This pattern is expected but provides quantitative evidence for pricing strategies and inventory management. Both categories serve important roles: high-volume items drive customer frequency while high-price items maximize revenue per transaction.
Top-Selling Products
AAA and AA Batteries lead in sales quantity, with USB-C and Lightning charging cables also showing strong performance. This indicates high demand for everyday consumable electronics accessories.
These high-volume items serve as entry points for customer acquisition and complementary cross-selling opportunities. They also drive repeat purchases as customers need to replace these consumable items regularly.
Product Purchase Patterns
The analysis reveals strong associations between complementary products. iPhones are frequently purchased with Lightning charging cables, Google phones with USB-C cables, and Bose headphones with AAA batteries.
These natural pairings present clear opportunities for product bundling and strategic cross-selling to increase average order value. Customers are already making these connections naturally.
Priscables Electronics Business Analytics
Turning 185,000 Transactions into Strategic Insights
The Challenge
Prisca’s online electronics store generates substantial data (185,000 transactions), but she needs to understand:
Who her customers are, when they shop, and what products drive revenue. Without these insights, she’s missing strategic growth opportunities.
Project Goal
Transform transaction data into actionable insights to understand customer behavior, optimize marketing timing, and refine product offerings for maximum growth.
Key Insights from the Data
Click on any chart to enlarge | Click “More Info” for detailed analysis
Which city generates the most revenue?
When do sales peak throughout the year?
What time of day do customers shop most?
Which products drive the most revenue?
What are our best-selling products by quantity?
How does price affect sales volume?
Which products are often bought together?
Summary of Key Findings
Geographic Focus
San Francisco generates $8M in revenue. Focus marketing efforts on this high-value city.
Seasonal Trends
December is the top month at $4.5M. Plan inventory and promotion strategy around Q4 strength.
Peak Hours
Sales spike at 11AM-1PM and 6PM-8PM. Schedule advertising to capture these prime shopping windows.
Product Mix
Batteries sell in volume; MacBooks generate revenue. Balance inventory across high-volume and high-margin items.
Product Pairings
iPhones sell with Lightning cables, Google phones with USB-C cables. Create bundles based on natural purchase patterns.
Price-Volume Relationship
Lower prices drive higher quantities sold. Strategically introduce more affordable options to boost transaction volume.
Recommended Actions
Technical Details
This section is for data analysts, data scientists, or anyone who wants to see the code behind our analysis. Click the links below to explore different parts of the project:
Detailed documentation of the data processing steps used in this analysis.
View NotebookIn-depth exploration of the data through guided questions and visualizations.
View NotebookAccess the original dataset used for this analysis for your own exploration.
Download Dataset