# Business analysis · experience and example brief

Richie Lin · Experience and work samples

I connect a business question with checked data, a clear finding, and a practical recommendation. My experience spans product reporting, regional research, and customer analysis.

## Relevant experience

### SQL reporting & validation

Structured reusable SQLite reporting for 99 products and validated joins for revenue and inventory analysis.

Working principle: Consistent metric definitions make product comparisons reliable.

Case: https://richielin.com/pages/breaking-games

### Opportunity assessment

Analyzed 2,857 stakeholder records in Excel and combined the findings with regional research to recommend two pilot markets.

Working principle: A market comparison needs both numerical evidence and local context.

Case: https://richielin.com/pages/nyuc

### Analytical communication

Reconciled customer and category totals in SQLite and visualized spending concentration across 440 records.

Working principle: Reconciled totals make the path from records to a finding easier to check.

Case: https://richielin.com/pages/customer-segmentation

## Illustrative brief · proposed approach

Which product categories deserve closer attention before the next planning cycle?

Inputs: Product, order, inventory, and campaign records. The team’s reporting definitions.

1. Agree on the decision, reporting period, unit of analysis, and revenue definition.
2. Check missing records and join cardinality, then compare revenue, units, inventory, and recorded campaign results.
3. Summarize the strongest finding, competing explanations, and one next action for each priority.

Proposed deliverable: A validated SQL report and a one page recommendation with assumptions and owners.

Evaluation: Reconcile totals to the source and define how the team will evaluate any resulting action.

## Related methods and exercises

- SQL report reconciliation (Illustrative sample · Synthetic data): https://richielin.com/pages/samples/sql-quality-check
- Customer purchasing mix memo (Public data analysis · Portfolio companion): https://richielin.com/pages/samples/customer-insight-memo

## Context

The projects here cover product reporting, regional research, and customer data analysis.

The proposed brief is a planning exercise. Each linked method includes its data or assumptions.

Role titles: Business Analyst Intern · Business Analytics Intern

Contact: richielin02@gmail.com
Online: https://richielin.com/pages/roles/business-analysis