Tag
SQL
12 post(s) tagged with SQL.
Completing a SQL Sales Analytics Project
A practical review of an end-to-end SQL sales analytics project, its business findings, technical outcomes, remaining limitations, and next steps into Microsoft Fabric and Power BI.
Designing an Analytics-Friendly Data Model
A practical dimensional-modelling case study that transforms AdventureWorks OLTP sales data into a validated star schema for analytical reporting.
Optimising SQL for Analytical Workloads
A measured SQL performance-tuning case study using execution plans, logical reads, searchable date predicates, covering indexes, and grain-aware query design.
Using Advanced SQL to Generate Business Insights
A practical use of SQL ranking, Pareto analysis, value quartiles, and acquisition cohorts to investigate commercial concentration and repeat purchasing.
Time-Series Analysis with SQL
A practical SQL analysis of monthly sales using complete date series, running totals, moving averages, year-over-year comparisons, customer mix, and cautious seasonality checks.
Analysing Regional Sales Performance with SQL
A practical SQL analysis of sales territories, shipping geographies, customer and channel mix, product mix, geographic concentration, and recent regional direction.
Measuring Product Performance with SQL
A practical SQL analysis of product and category performance using sales value, quantity, customer reach, discounting, product families, and recent direction.
Analysing Customer Purchasing Behaviour with SQL
A practical SQL analysis of customer activity, repeat purchases, order frequency, average order value, recency, and purchase cadence using AdventureWorks2025.
Preparing Sales Data for Analysis with SQL
A practical approach to building reusable SQL views over AdventureWorks2025, with consistent customer, order, product, geography, date, and financial definitions.
Assessing Sales Data Quality with SQL
A practical assessment of AdventureWorks2025 sales data quality, covering missing values, duplicates, validity, reconciliation, referential integrity, and analytical limitations.
Understanding the Sales Data Landscape with SQL
A practical exploration of the AdventureWorks2025 sales schema, from customers and orders to products, territories, and the different grains that shape reliable analysis.
Building a Sales Analytics Solution with SQL: Project Overview
An introduction to a practical SQL portfolio project that turns operational sales data into useful analysis, business findings, and an analytics-ready foundation.