Business-oriented SQL analytics project focused on commercial performance and strategic decision-making across regions, industries, and product categories.
This project delivers business performance analysis using SQL over a commercial sales database, simulating real-world BI scenarios found in enterprise environments.
The objective is to extract actionable business insights related to revenue, profitability, customer behavior, regional performance, and sales forecasting — supporting strategic decision-making at the commercial and financial leadership level.
- Which customer accounts generate the highest revenue and margin by product category?
- Which regions and countries drive the strongest commercial performance?
- Which industries are closest to closing high-value deals, and where does profitability stand?
- Are sales forecasts for 2022 aligned with 2021 actual performance?
- Which region–industry combinations yield the highest and lowest profit margins?
- Where should the company prioritize future investment and resource allocation?
- SQL (aggregations, window functions, conditional logic, multi-table joins)
- Relational Databases
- KPI Analysis & Profitability Metrics
- Business Intelligence & Data Visualization
- Sales Forecasting & Variance Analysis
Business Context: The commercial leadership team requires a detailed performance breakdown of account Adabs Entertainment for FY2020, covering all revenue streams (maintenance, product, parts, and support), units sold, and total profit.
Business Insight
Chairs and Electronics both delivered profit margins of approximately 33% and 36% respectively — a notably similar performance despite the structural differences between product lines. This consistency may reflect standardized pricing or cost structures across categories.
Recommended action: Benchmark these margins against comparable accounts to assess whether current profitability levels are competitive or represent an optimization opportunity.
Business Context: The international expansion team requires a cross-country performance comparison across the APAC and EMEA regions to identify high-potential markets and establish regional benchmarks for strategic investment decisions.
Business Insight
APAC markets demonstrate significantly stronger revenue and profitability compared to EMEA, with Australia and Singapore as the top-performing countries. This suggests higher market maturity, stronger pricing dynamics, or greater operational efficiency in those markets.
Despite fewer countries, APAC's combined average profit contribution reaches parity with EMEA — both regions converge around $3,390,000 in total average profit, as confirmed below.
SQL QUERY — Total Average Profit: EMEA + APAC → Query02b.sql
Data quality flag: The EMEA region holds 9 registered countries in the ACCOUNTS table, but only 8 appear in the sales analysis. United Kingdom (UK) has 4 registered accounts with zero recorded sales — a gap that warrants investigation before any go-to-market strategy for that market.
Business Context: The strategic sales team needs to identify which industries generate the highest profit among accounts in the Commit stage (near-close deals) with a forecast exceeding $500,000. Industries are classified as High (profit > $1M) or Normal.
Business Insight
The Financial sector is not meeting the $500K forecast threshold in the Commit pipeline — a critical flag for the sales team. This underperformance may reflect deal slippage, longer-than-expected sales cycles, or misaligned forecasting at the account level.
Recommended action: Prioritize pipeline review for Financial sector accounts in Commit stage to assess deal health and adjust revenue projections accordingly.
Business Context: The finance leadership requires a consolidated view comparing FY2021 actual profits against FY2022 forecasted profits by product category, along with sales cycle velocity indicators (oldest and most recent open opportunities per category).
Business Insight
Across all 4 product categories, the minimum opportunity age is 2–3 days, indicating healthy short-cycle deal activity. However, 3 out of 4 categories contain opportunities open for over 365 days — a significant operational risk.
Recommended action: Conduct a pipeline audit on all opportunities exceeding 12 months. Long-stalled deals distort revenue forecasts and create planning inefficiencies in inventory, spare parts, and technical support resourcing. Each open deal should be either moved to close or formally disqualified.
Identify which region–industry combinations yield the highest and lowest profit margins, enabling the commercial leadership team to optimize resource allocation, replicate high-performance strategies, and address underperforming segments.
Regions and industries with the strongest margin profiles should be used as benchmarks. Underperforming combinations may reflect pricing inefficiencies, cost structure issues, or underdeveloped market presence — all correctable with the right strategic lever.
The following query extracts total, minimum, maximum, and average profit alongside margin averages and standard deviation across all 4 regions:
Key Finding: NAM and EMEA generate the highest absolute profit, while LATAM significantly underperforms in volume. Notably, average profit margins are relatively homogeneous across regions — suggesting the profitability gap is driven by deal volume and market size, not by pricing or cost efficiency differences.
Industries are classified by margin performance using the following thresholds:
| Margin | Classification |
|---|---|
| > 38% | 🟢 High |
| 33% – 38% | 🟡 Medium |
| < 33% | 🔴 Low |
a) Scale high-margin industries into emerging regions (LATAM & APAC) Replicating the operational model of sectors with consistently high margins (e.g. Technology, Financial Services) in lower-volume regions can accelerate overall profitability without proportional cost increases.
b) Optimize underperforming industry–region combinations For segments with margins below 33%, a structured review of pricing policies, cost structures, and deal qualification criteria is recommended to improve contribution to total profit.
c) Investment prioritization Sustain commercial momentum in NAM and EMEA while designing phased expansion strategies for LATAM — focusing on high-margin industries with demonstrated demand signals in adjacent markets.
Analysis conducted on enterprise commercial sales data covering FY2020–2022 across 4 global regions (NAM, EMEA, APAC, LATAM).