1. Project Title & Company Review
FusionPoint Industries: Consumer Electronics Sales Trends and Profitability Analysis.
INDUSTRY: Retail Industry.
Business Introduction: FusionPoint Industries is a dynamic consumer electronics retailer serving customers across multiple U.S. states through a well established omnichannel network. With a product portfolio that ranges from electronic games to office electronics, such as printers, FusionPoint aims to deliver high-quality, affordable, and innovative technology solutions. By leveraging modern payment systems and efficient order fulfilment processes, the company strives to meet evolving consumer demands while maintaining profitability and market share.
ROLE: Sales Analyst.
2. Business Problem
Despite strong sales across diverse product categories, FusionPoint Industries faces challenges in understanding the drivers of profitability and regional sales performance within its consumer electronics division. Inconsistent demand patterns, varying discount practices, and differences in payment modes make it difficult to identify which products, regions, and customer segments most contribute to sustained revenue growth. Additionally, the business struggles to predict future sales and to personalize customer offerings accurately.
By leveraging artificial intelligence and advanced analytics, FusionPoint Industries can uncover actionable insights from its sales data, forecast demand, optimize pricing strategies, and drive targeted marketing initiatives to support data-driven, profitable growth.
3. Business Objectives
- Analyze sales performance across products, sub-categories, and regions to identify high and low performing segments.
- Measure profitability trends by product category, sub-category, and sales channel to support profit-driven decision-making.
- Evaluate customer purchasing behaviour and payment preferences to inform customer-centric strategies.
- Identify patterns in demand over time and across geographics to optimize inventory and supply chain planning.
4. My Approach
- Data loading of MS Excel dataset.
- Data Cleaning in Power Query.
- Data Modeling.
- M Language & DAX Language.
- Business insights.
- Dashboard building.
- Recommendations.
TOOL USED: Tableau
5. Key Deliverables
Delivered a Power BI dashboard to improve data-driven decision-making
6. Insights
- Monthly Analysis: Revenue peaks in October (€633K) and December (€655K). The lowest profit months are September and November (~€100K each), and the strong seasonality indicates sales spikes during year-end (holiday demand).
- Category Analysis: Revenue is evenly distributed among Office Supplies (€2.09M), Electronics (€2.05M), and Furniture (€2.03M). Profit is strongest in Office Supplies (€551K) and Furniture (€540K). The Electronics lag in profit (€518K), suggesting high costs or discounting.
- Customer Performance: The Debit Card & Credit Card dominated with 43.28% of revenue. UPI (20.23%) and COD (18.47%) represent strong alternative channels. Encouraging EMI (18.02%) can support higher-value purchases, and lastly, Debit Card (23.3%) contributes the highest profit share.
- Location Analysis: New York and Florida are the strongest revenue-generating regions: €1,130,048 & €1,091,174, respectively. California and Texas showed moderate contributions in revenue: €1,086,436 & €1,011,475, respectively. Revenue generated in Illinois (€978,738) and Ohio (€884,768) suggests regional growth opportunities in other states.
7. Recommendations
- Focus on improving profit margins in Electronics via supplier negotiations or reduced discounting.
- Capitalize on high-performing subcategories (Mattresses, Tables) with targeted promotions.
- Introduce loyalty rewards during high-demand months (Oct till Dec) to increase repeat purchases.
- Encourage digital payment adoption (UPI/EMI) with cashback offers to reduce COD dependency.
- Invest in marketing campaigns promoting Office Supplies & Furniture to sustain profitability.
- Strengthen promotions on high-margin categories (Books, Paper, Chairs) to boost profitability.
- Introduce bundle deals or upsell opportunities in low-margin categories (Phones, Pens).
- Expand regional campaigns in mid-performing states (Ohio, Illinois) to balance growth.
- Reward Debit and Credit Card users with loyalty programs since they drive most profits.
- Focus on improving the delivery duration of the shipments to the bare minimum to secure customer satisfaction and continual patronage.