Report Types
- Tabular — order list
- Summary — monthly totals
- Matrix/Crosstab — Region × Product
- Chart-based, Drill-down, Aging
Anatomy
Header (logo, title, filters) Group: Region Dhaka Order rows Subtotal: 1500 Grand Total: 5000 Footer (page, date)
Grouping
Group by Region → Dhaka: rows + subtotal
→ Ctg: rows + subtotal
Grand Total
Layout
- Important top-left (F-pattern)
- Right-align numbers, left-align text
- ISO 8601 date, currency symbol
- Negative red
Color & Typography
Limited palette (2-3 + gray), sans-serif screen, 11-12pt body, zebra striping।
Dashboard বনাম Report
| Dashboard | Report |
|---|---|
| Real-time KPI | Historical detail |
| Visual | Tabular |
| Interactive | Static, printable |
Chart Choice
- Trend → Line
- Comparison → Bar
- Composition → Stacked (NOT Pie if >5)
- Geography → Map
- Avoid 3D, dual-axis
BI Tools
Power BI, Tableau, Looker, Metabase, Superset, Grafana।
Common Mistakes
Too many metrics (focus 5-7), 3D pie, Y-axis not from 0, missing context।