Excel
Avoiding Misleading Axes in Excel Charts Built From Data
Avoid misleading axes in Excel charts: start bars at zero, set scales on purpose, avoid dual axes, use consistent scales across charts and label the units.
7 min read
Tag
analysis
92 posts
Excel
Exporting Excel Charts as Images From a Script or Server
Export charts as PNG or SVG from a script: draw with matplotlib from the same data, render headless with LibreOffice, or use Windows COM.
6 min read
Excel
Building Dashboards in Excel From SQL Output Step by Step
Build an Excel dashboard from SQL output: one data sheet per query, a presentation sheet of tiles and charts, scheduled refresh and tie-out checks.
7 min read
Excel
Sparklines and Conditional Formatting for Quick Scans
Add sparklines, data bars, color scales and icon sets to a table so readers can scan 40 rows in seconds, written from XlsxWriter with accessible choices.
7 min read
Excel
Refreshing Charts From a Changing Data Range in Excel
Fix charts that miss new rows or show blank gaps when data size changes: Excel tables, dynamic named ranges, generated ranges and refresh settings.
7 min read
XML
Joining XML Derived Tables to Your Own Data Safely
A join between parsed XML orders and a customer CSV silently dropped 1,280 lines and 3.2 million in revenue. Find the unmatched keys and normalize them.
6 min read
JSON
Handling Properties That Change Type in JSON Event Data
Fix invalid input syntax for type numeric on a JSON property that became a string, null or object, with jsonb_typeof, pg_input_is_valid and a function.
7 min read
JSON
Designing JSON Event Properties for Analysis From Day One
Four designs for the same 500,000 purchase events compared on size and query time: verbose nesting, short flat keys, hybrid columns and key/value arrays.
6 min read
Excel
Choosing Excel Chart Types for Query Results That Read
Choose an Excel chart type from the shape of your query result: line, column, bar, stacked, scatter, histogram or table, with rules and the mistakes to avoid.
7 min read
ExcelGuide
Charts From Data Pulled Out of Databases Start to Finish
Build clear Excel charts from database data: shape the query, pick the chart, keep ranges live, avoid misleading axes, add sparklines, export images.
17 min read
JSON
Analyzing a GitHub Events Dump With DuckDB and SQL
Query a GitHub style events dump of 300,000 JSON lines in DuckDB: one struct for ten event types, truncated commit lists and three-state booleans.
7 min read
CSV
Reconciling a Bank Statement CSV With Your Ledger in SQL
Match a bank statement CSV against a ledger in SQL with a date tolerance, pair duplicate amounts correctly, and explain the difference in totals row by row.
7 min read