| Month | Target | Actual | Variance |
|---|---|---|---|
| January | 1,000 | 1,080 | +80 |
| February | 1,100 | 1,160 | +60 |
| March | 1,200 | 1,140 | −60 |
Monthly KPI Scorecard
Turn monthly targets and actuals into a clear performance conversation.
Practical starting points for the work behind the dashboard. Built for Excel, SQL, Power BI, and everything in between.
| Month | Target | Actual | Variance |
|---|---|---|---|
| January | 1,000 | 1,080 | +80 |
| February | 1,100 | 1,160 | +60 |
| March | 1,200 | 1,140 | −60 |
Pick a template. Make it yours. Get to the interesting part.
Showing all 6 templates
| Month | Target | Actual | Variance |
|---|---|---|---|
| January | 1,000 | 1,080 | +80 |
| February | 1,100 | 1,160 | +60 |
| March | 1,200 | 1,140 | −60 |
Turn monthly targets and actuals into a clear performance conversation.
| Field | Type | Nullable |
|---|---|---|
| order_id | INTEGER | No |
| order_date | DATE | No |
| net_amount | DECIMAL | No |
| customer_id | INTEGER | Yes |
Give every field a definition, an owner, and a source your team can trust.
Get the audience, business questions, metrics, and acceptance criteria aligned.
-- 01. Find duplicate keysSELECT order_id, COUNT(*)FROM ordersGROUP BY order_idHAVING COUNT(*) > 1;Find null keys, duplicates, invalid amounts, and broken relationships.
A restrained navy and blue palette for consistent report styling.
| Case | Scenario | Status |
|---|---|---|
| UAT-001 | Total reconciliation | Pass |
| UAT-002 | Date filter | Fail |
| UAT-003 | Empty state | Not run |
Keep test scenarios, expected results, evidence, and retests in one place.
Try a different keyword or explore all six templates.
Workbooks, presentation templates and practical SQL cases, sold individually.

Compare two exports by record ID, reconcile amounts, and work through a clearly classified exception list.

Turn weekly volumes and handling times into demand hours, then compare them with productive team capacity.

Review an operational backlog at a chosen reporting date and model a simple clearance scenario.

Present monthly results with an editable scorecard, trend chart, backlog bridge, decisions and action plan.
Practice a timed support-operations case with event cleanup, reporting-cutoff logic and independently checked solutions.

Start with an editable analyst resume and compare examples for three different career stages.
Also in Data Analyst Career PackOne-time purchases. Editable files, examples and instructions. Prices in USD.
Focused toolkits for the way analysts actually work.
Scope it. Build it. Hand it over.
A practical foundation for your next report.
Put your experience into a stronger story.
One collection for projects, reporting, and career growth.
The Ultimate Bundle contains the three toolkits shown here. The ten new individual products are sold separately. The resume and Project Delivery Workbook components are already included in their respective toolkits.
What’s included, how it works,
and what’s coming next.
Yes. The six starter templates download directly, with no account or email required. Use and adapt them in personal projects, internal business work, or client deliverables. See About the downloads for the included CC0 dedication.
The catalog labels every format. XLSX files are designed for Excel. Markdown opens in any text editor. The SQL pack includes a SQLite example, and the Power BI theme requires Power BI Desktop. Product pages explain the scope and compatibility of each download.
The current free Power BI download is a report theme, not a dashboard or data model. There are no PBIX or PBIT files in this catalog. Each product page lists exactly what is included.
The individual products, Project Toolkit and Career Pack are available as one-time purchases through Stripe. After successful payment, you return here to download your ZIP. Save your files immediately; the same browser can reopen the order page for 30 days. Save your recovery key to restore access on another device at /order/. For another copy or an order issue, use the contact form with your receipt reference. The Power BI Toolkit and Ultimate Bundle are still in final review.