Blog
Personal and technical writing on small-business analytics, Grain First data modeling, operations, and building CareerTalkLab with AI.
Blank or Zero? Why Missing Values Change Your Average
See how blanks, zeros and empty-string formulas change spreadsheet averages, and report missing sales without treating unknown values as zero.
Duplicate Sales Rows or Legitimate Order Lines?
Repeated order IDs can be legitimate line items. Use a line-level key, confirm duplicates against the source, and reconcile every row before deleting.
A Repeatable Workflow for Cleaning Business Spreadsheet Data
Keep an untouched export, log cleaning changes and exclusions, and use totals plus source-row checks to prove that no business records disappeared.
Import a CSV into Excel Without Losing Leading Zeros
Import CSV identifiers into Excel as text, preserve leading zeros and long account numbers, and verify the result with nine exact checks.
What Does One Row Represent in Your Sales Spreadsheet?
Learn what one row represents in a sales export, avoid double-counting order totals, and check order-line grain before calculating sales or averages.
Data Studio (Formerly Looker Studio) vs Power BI vs Tableau for Small Business
A plain comparison of Data Studio (formerly Looker Studio), Power BI, and Tableau: what each costs for a small team, where the viewer fees land, and how to choose.
Is Data Studio (Formerly Looker Studio) Free for Small Business?
Google's reporting tool is free to build and share. Here is what Pro, outside connectors, and BigQuery can add, and how to run a useful dashboard at $0.
Is Power BI Worth It for a Small Business?
Power BI is inexpensive to build with, but sharing takes paid licenses for viewers. Here is what it costs, where it fits a Microsoft shop, and when to skip it.
When to Move From Spreadsheets to a BI Tool
Five specific signs that it's time to move from spreadsheets to a BI tool, what to try first for each, and what a new tool won't fix.
Business Data You Should Never Give an AI Tool
Four kinds of business data to keep out of unapproved AI tools, safer ways to ask for help, and a short policy your team can adapt.
Is It Safe to Upload Business Data to ChatGPT?
Whether it's safe depends on the account, the settings, and the data. A plain-English guide to personal vs. business plans, turning off training, redacting first, and three rules for a small team.
How to Track Inventory in Google Sheets
Build an inventory tracker in Google Sheets with three tabs: an item list, a log of every stock movement, and a stock tab that calculates balances and flags what to reorder.
How to Get Alerted When Your Numbers Change
Decide which numbers deserve an alert, how to set the line for each, what every alert should say, and how to prune the list without hiding real risks.
How to Set Up Automatic Alerts in Google Sheets
Four ways to get Google Sheets to warn you: notification settings, conditional notifications, color rules, and a short Apps Script that emails you once when a number crosses your minimum.
How to Build a Cash Flow Tracker in Google Sheets
Build a 13-week cash flow tracker in Google Sheets: the row layout, the formulas, a minimum-cash warning, and a 15-minute weekly update.
Revenue Per Available Parking Space, Explained
Calculate revenue per available parking space, handle capacity changes, and separate occupancy and realized yield when interpreting a change.
How to Measure Parking Facility Occupancy
Calculate parking occupancy with a defined space count, validate the inputs, and build enough observation history to report measured peaks responsibly.
The KPIs Every Parking Lot Operator Should Track
Six parking KPIs and the data each requires: peak occupancy, hours near capacity, revenue per available space, rate mix, cost per space, and payment capture.
Data Analytics for Property Management Companies
Use five property metrics to spot occupancy, collections, work order, vacancy, and controllable expense issues before deciding what to change.
How to Track Where Customers Came From for Free
Use tagged campaign links, analytics referrers, a “how did you hear” question, and one spreadsheet to make a practical judgment about where leads came from.
Google Analytics 4 Explained for Business Owners
Learn the GA4 reports a small business owner needs: Traffic acquisition and Pages and screens, plus a check that valuable actions are recorded as key events.
Which Website Metrics Matter for a Small Business
Choose four to seven website metrics based on what your site does. Inquiry sites should measure conversions, traffic source, landing pages, engagement, cost per inquiry, and speed. Product sites need activation and retention.
How Much Should a Small Business Spend on Data Tools
Start with the data tools your business already has. Learn when sharing licenses, connectors, or a larger platform justify their full cost.
A Monthly Reporting Pack Template for Small Business
A five-page monthly reporting pack: summary and core metrics, financials against budget, operations and team, pipeline, and decisions. Copy the page outlines and update them each month.
What to Include in a Monthly Business Report
A monthly business report needs six things: core metrics, financials against budget, operations, pipeline, team capacity, and decisions. Here's the checklist, and what to leave out.
How Many Charts Should a Dashboard Have?
There’s no fixed number of charts for a dashboard. Use the one-screen test, give every chart a question, and lay the screen out in three parts: cards, trends, and breakdowns.
Why Your Business Numbers Don’t Match Across Systems
Why your payment processor, bank, and accounting software show different totals, and a monthly reconciliation bridge that shows how the numbers connect.
How to Build a Monthly KPI Scorecard
Build a monthly KPI scorecard in Google Sheets or Excel: a four-layer workbook, formulas for current and year-to-date results, targets from your own history, and a repeatable month-end routine.
How Much Does a Small Business Dashboard Cost?
Why there is no single price for a business dashboard, and what drives it: how clean your data is, how many systems feed it, whether it updates itself, and how many metrics you ask for. Plus what a comparable quote should contain.
KPIs for a Small Professional Services Firm
Five KPIs for a small professional services firm: utilization, realization, project margin, DSO, and pipeline—plus plain formulas and the warning each one gives you.
How to Get Your Team to Actually Use Your Reports
Reports get used when they end in decisions. Use a one-page summary, a short off-track note, a weekly meeting, and an action log that checks whether anything happened.
Why Nobody Looks at Your Dashboard (and How to Fix It)
When a team stops opening the dashboard, the cause is usually trust, relevance, missing actions, friction, or leadership. How to tell which one you have and where to start.
7 Dashboard Mistakes Small Businesses Make
Seven common dashboard mistakes that make small business dashboards hard to use, how to recognize each one, and a quick check for your own.
How to Improve a Business Dashboard You Already Have
Before you rebuild a cluttered dashboard, check whether it can be fixed. Use this three-question check and four-step renovation plan.
How Many KPIs Should a Small Business Track?
Most small businesses should track four to seven KPIs. Here is a three-question test for which metrics earn a place, what to do with the rest, and starting scorecards for services, manufacturing, and restaurants.
The Business Data You Already Have (No New Tools)
Unlock the hidden value in your small business data without buying expensive new software. Learn how to extract and analyze existing records from your accounting, POS, banking, and scheduling tools using just a simple spreadsheet.
What to Expect From a Small Business Analytics Project
What happens after you hire analytics help: scope, data, drafts, timeline, testing, and handoff, plus what you need to do at each stage.
12 Questions to Ask Before Hiring a Data Consultant
Don't hire a data consultant without asking these 12 critical questions. Protect your business by clarifying deliverables, data security, IP ownership, and fixed-price scoping from day one.
The Small Business Data Audit Checklist
A step-by-step checklist to help small businesses map their data sources, test usability, and fix critical errors so their records are decision-ready.
Do You Need a Data Analyst or Better Spreadsheets?
Small businesses experiencing reporting failures should identify the root cause before investing in new software or full-time data analysts. Determining whether issues stem from untrustworthy data, fragile spreadsheet workflows, or a lack of analytical judgment allows companies to target the smallest, most effective solution first.
When Should a Small Business Hire a Data Analyst?
Learn when a small business should hire a data analyst—and when spreadsheet cleanup, freelance help, or fractional support is the better choice.
The Architect’s Leap: Orchestrating Agency in a Multi-Track World
Agency isn't about working harder — it's about shrinking the distance between intention and execution. How I built an orchestration layer to run two demanding roles and a startup in parallel.
Hello, World
A brief introduction to why I'm starting this blog and what you can expect from it.
Building This Site
The technical decisions behind johnserra.com — Next.js, Tailwind, MDX, and a bento grid layout.