SQL Business Analysis Query Pack for PostgreSQL

# SQL Business Analysis Query Pack

Practical PostgreSQL templates for revenue, customer, retention, cohort, and RFM analysis.

This pack is designed for analysts, founders, operators, and freelancers who need reliable business SQL patterns without starting from a blank editor.

## What's Included

- `sql/business_analysis_queries_postgresql.sql`  

  50 PostgreSQL query templates grouped by business use case.

- `sample_data/customers.csv`  

  Example customer master data.

- `sample_data/orders.csv`  

  Example transaction data.

- `sample_data/order_items.csv`  

  Example line-item data.

- `docs/query_index.md`  

  Plain-English index of all included queries.

- `docs/how_to_use.md`  

  Setup notes and adaptation guide.

- `docs/schema_reference.md`  

  Table and column assumptions.

- `LICENSE.txt`  

  Personal and commercial use license.

## Query Categories

- Revenue analysis

- Customer analysis

- Product analysis

- Retention analysis

- Cohort analysis

- RFM segmentation

- Funnel and conversion analysis

- Data quality checks

- Executive reporting

## Assumed Tables

The templates use three common business tables:

- `customers`

- `orders`

- `order_items`

You can rename tables and columns to match your own database. See `docs/schema_reference.md`.

## Requirements

- PostgreSQL 12 or later recommended

- Basic SQL knowledge

- Optional: spreadsheet tool for inspecting the sample CSV files

## Quick Start

1. Review `docs/schema_reference.md`.

2. Load the sample CSV files into PostgreSQL, or map the query templates to your own database.

3. Open `sql/business_analysis_queries_postgresql.sql`.

4. Copy the query that matches your analysis need.

5. Replace table names, date ranges, and column names where needed.

## Support Scope

This is a digital template product. It does not include custom implementation, database debugging, or private consulting.

For best results, test queries on a small dataset before running them on production data.