DataWindows app
Daily Data Report Builder
Drop in today's Excel files (GMV, orders, traffic). Merge with saved mappings. Generate a "today at a glance" image or PDF in minutes.
The problem
Every morning, business asks "what was yesterday's GMV?". Data team runs SQL, pulls tables, stitches charts, posts to chat — a daily hour wasted.
The solution approach
A local app. Drop in today's Excels, pick field mappings (remembered for next time), click "Generate Report", get an image or PDF with headline metrics, trend lines, and day-over-day changes.
What you will end up with
- Home has three panes: Import / Template / Generate.
- Drag multiple Excels at once; auto-detect GMV / Orders / Traffic type (manual override available).
- Template is configurable: title, KPIs, chart types (line / bar).
- One-click branded report as PNG or PDF, named "daily-YYYY-MM-DD".
- Save templates; subsequent days are drag + click.
Ready-to-use prompt
You are a senior engineer experienced with Windows desktop apps. Build a local Windows tool for a data / ops-analytics colleague. User is a non-developer.
[Goal]
Merge multiple daily Excel files (GMV, orders, traffic) into a "today at a glance" image or PDF — no more manual daily stitching.
[Platform & Stack]
- Windows 10/11 desktop app
- Electron + React + TypeScript
- SheetJS for Excel
- html-to-image or offline puppeteer-core for PNG/PDF rendering
- Local SQLite for templates + mappings
- Fully offline; ship a Windows .exe installer
[Core Features]
1. Home has three panes: Import, Template, Generate.
2. Smart detection: infer data kind (GMV / Orders / Traffic) from header keywords; allow manual override. Remember field mapping for future.
3. Report contents:
- Top: date + logo placeholder (user uploads local PNG).
- KPI cards with day-over-day arrows.
- 7-day trend line chart (drawn from stored past data).
- Bottom: top channels / top categories bar chart.
4. Export:
- PNG (1200x1800, easy to share).
- PDF (A4 portrait).
5. Keep last 30 daily reports locally.
[Visual Style]
- Clean business: white background, large cards, soft dividers.
- User-picked brand color; no hard-coded palette.
- Minimal charts.
- System fonts; follows dark mode.
[Robustness]
- Friendly message on non-Excel drops.
- Resolve mapping conflicts via a confirmation dialog.
- On render failure, report which block failed.
- Handle mixed CJK + Latin without glyph issues.
[Delivery]
1. Structure + wireframe with three panes.
2. Phase 1: import + preview. Phase 2: template edit. Phase 3: PNG/PDF export.
3. Package .exe; 500-word user guide.
Start with structure and wireframe.After copying
1
Open Codex Desktop and create a new project
2
Paste the prompt and send
3
Wait for Codex to finish; tweak company names, column names, button text as needed