llms.txt
Compare with other sites' llms.txt files →# Palavir - Data Analytics & AI Consulting
> AI, analytics, and the data engineering that makes them work, for organizations with no in-house data team. Founded and delivered by Josh Elberg, 15 years in enterprise data (PLI, MRM, Merkle, Home Depot). Based in metro Detroit, serving nationally. Engagements run from a single paid discovery day to multi-month builds. Also the publisher of "The State of Fraud in America," a free, data-driven series on fraud and improper payments built from about 400 public datasets.
Last updated: 2026-11-05
## About
Palavir LLC is an AI and analytics consultancy founded by Josh Elberg in February 2026, based in metro Detroit and serving clients nationally. Josh does the work himself: there is no bench and no handoff to juniors.
Background: 15 years in enterprise data before founding Palavir. Senior Director of Data Transformation at Practising Law Institute (led a team of 7), Director of Performance & Analytics at MRM, Associate Director of Data Strategy at Merkle, BI Manager at Nuwell, and 7+ years in analytics at The Home Depot. MBA, Athabasca University.
## Who Palavir is for
The qualifier is not company size, it is whether anyone's full-time job is building the data layer underneath your reporting. Usually nobody's is. The common pattern is analysts who know the business well and no one to build the pipelines, models, and reporting they need.
Typical triggers: someone spends a full day a week assembling a report by hand; a month-end close is keyed in manually; two systems do not talk to each other; leadership wants AI but has no defined use case; a migration left reporting broken.
## How engagements work
1. Start with a paid discovery day. Fixed fee, no proposal cycle. You keep the findings whether or not the work continues.
2. Then build in milestones. Each piece is scoped, approved, and paid for before the next one starts.
3. One person from the first call to the last delivery.
Engagements have ranged from a single day to multi-month builds.
## Services
- Business intelligence and reporting (Power BI, Tableau, semantic models, DAX)
- Data engineering and pipelines (Azure, Microsoft Fabric, SQL, Python)
- AI and LLM implementation, and workflow automation
- CRM implementation and pricing/quoting automation
- KPI frameworks, executive reporting, and data governance
- Fractional data leadership and AI readiness assessment
- Corporate AI training and workshops
## Representative engagements (anonymized)
- Headquarters of an auto-dealership group: a fixed-fee onsite discovery day for HQ analysts closing the month by hand in Excel, then a 90-day plan for an Azure SQL canonical store, a Functions-based extraction pipeline, and a custom Next.js analytics cockpit behind Entra SSO. Deliberately not a lakehouse, so the in-house team can operate it after handoff.
- Multi-site manufacturer: newly on a cloud ERP after moving off a legacy on-premises system, with no reporting on the new system. Built the semantic models and scheduled-refresh reports into the client's own Power BI workspace, plus a guidebook so their team can extend them.
- Metals distributor: configured Pipedrive configured with a customer price-tier and region taxonomy, a product catalog, and middleware that fills each deal line from the customer's tier and sets tax by currency.
## Tools and platforms
Power BI, Tableau, Microsoft Fabric, Azure (SQL, Functions, Entra), AWS, GCP, BigQuery, Redshift, PostgreSQL, Supabase, DuckDB, Python, R, SQL, TypeScript, Next.js, Pipedrive, Copilot Studio, Claude.
## Key Pages
- Homepage: https://palavir.co
- Consulting: https://palavir.co/consulting
- Training: https://palavir.co/training
- About: https://palavir.co/about
- Blog: https://palavir.co/blog
- AI Readiness Scorecard: https://palavir.co/ai-readiness
- AI Opportunity Audit: https://palavir.co/audit-service
- Analytics and BI consulting: https://palavir.co/consulting/analytics
- Power BI consulting in Detroit and Michigan: https://palavir.co/consulting/power-bi
- Construction WIP schedule and over/under billing reporting for Michigan contractors (monthly, tied to the balance sheet; free Excel WIP workbook): https://palavir.co/consulting/construction-wip-report
- Job costing dashboards for contractors on QuickBooks Online or Business Central (every open job: budget vs. actual by cost code, margin fade since bid, billing position; fixed fee): https://palavir.co/consulting/job-costing-dashboards
- CRM cleanup and repair for small businesses on Pipedrive, HubSpot, monday.com, Method and similar (duplicates merged, fields and stages cut back, the QuickBooks Online link rebuilt so one system owns each record, Make/Zapier automations fixed and documented; fixed-fee audit first, credited to the repair): https://palavir.co/consulting/crm-cleanup
- Power BI reporting for companies on Dynamics 365 Business Central (one model across companies, reports that end in a next action; reporting only, no ERP implementation): https://palavir.co/consulting/power-bi-business-central
- Funder and board reporting for Detroit and Michigan nonprofits (outcome numbers defined once, a board dashboard, a reporting calendar): https://palavir.co/consulting/nonprofit-reporting
- Business intelligence and Power BI for Southeast Michigan manufacturers (inventory, open orders, margin and receivables reports that end in a next action): https://palavir.co/consulting/manufacturing-bi
- Fractional data analyst for small businesses across the US, remote (monthly reporting produced and checked, dashboards maintained, ad-hoc questions answered; a fixed monthly fee after a first fixed project): https://palavir.co/consulting/fractional-data-analyst
- Power BI and BI consulting for Miami, Fort Lauderdale, Boca Raton and South Florida businesses (remote, Eastern time; on-site for larger engagements by arrangement): https://palavir.co/consulting/south-florida
- Reports that tell a small business owner what to do next, not just charts (each line names the action and the owner; routine follow-up automated with approval; daily checks that the numbers match): https://palavir.co/consulting/next-action-reports
- AI automation and AI agents for routine operations work at Detroit and Michigan businesses of 10 to 200 people (one process automated end to end, approval steps, checks): https://palavir.co/consulting/ai-automation
- Data and reporting audit, then KPI dashboards, for mid-size Detroit and Michigan organizations (audit priced on its own; set-up optional): https://palavir.co/consulting/data-audit
- For CPAs, bookkeepers and fractional CFOs: a reporting partner for their clients (dashboards, monthly job and WIP reporting on the books the firm keeps; Palavir does no bookkeeping, tax or audit work): https://palavir.co/partners/accountants
- AI consulting, workflow automation and AI agents for Michigan small businesses: https://palavir.co/consulting/michigan and https://palavir.co/consulting/ai
- Local AI and BI consulting pages: Detroit https://palavir.co/consulting/detroit, Ann Arbor https://palavir.co/consulting/ann-arbor, Troy https://palavir.co/consulting/troy, Southfield https://palavir.co/consulting/southfield, Royal Oak https://palavir.co/consulting/royal-oak, Grand Rapids https://palavir.co/consulting/grand-rapids
- How consulting is priced: fixed fees quoted before work starts (a first pilot covers one process or report set in about three weeks); never open-ended hourly
- FAQ: https://palavir.co/faq
- Contact: https://palavir.co/contact
- For Microsoft partners: https://palavir.co/partners
- Power BI for Business Central (what Microsoft's nine free apps cover and the limits Microsoft documents): https://palavir.co/partners/business-central-power-bi
## Common questions, answered
Plain-answer guides on the blog. Each opens with the direct answer.
- [What an AI consultant costs in 2026](https://palavir.co/blog/hiring-ai-consultant-what-to-expect-costs): hourly, day, project and retainer rates by consultant tier, from a 68-consultant survey and BLS pay data
- [What an AI opportunity audit is](https://palavir.co/blog/what-is-an-ai-opportunity-audit): a fixed-fee assessment that ranks where AI saves time and money and costs each build before you commit
- [When AI is not the answer](https://palavir.co/blog/when-ai-is-not-the-answer): five problems that simpler fixes solve better than machine learning
- [How professional services firms use AI](https://palavir.co/blog/ai-for-professional-services): proposal automation, knowledge management, resourcing and client insight for consulting, legal and agency work
- [Signs you need an analytics consultant](https://palavir.co/blog/signs-need-analytics-consultant): five warning signs and what to do about each
- [Moving from spreadsheets to dashboards](https://palavir.co/blog/spreadsheets-to-dashboards): when to move off manual Excel reporting and how
- [Power BI for Business Central: multiple companies](https://palavir.co/blog/power-bi-for-business-central-multiple-companies): the free apps work one company at a time; the routes Microsoft documents for consolidated reporting
- [Customising Business Central Power BI templates](https://palavir.co/blog/power-bi-for-business-central-templates): what a template app update overwrites and keeps, and a workspace pattern that keeps customisations safe
- [Business Central dashboard examples](https://palavir.co/blog/business-central-dashboard-examples): the Power BI reports Microsoft ships for finance, sales and inventory, and five worklist dashboards to build
- [How to find open SBIR Phase I opportunities](https://palavir.co/blog/how-to-find-open-sbir-phase-one-opportunities): finding currently open solicitations across 11 federal agencies
- [SBIR Phase I budget mistakes](https://palavir.co/blog/sbir-phase-one-budget-mistakes): indirect rate, fee and direct labor errors that lead to audits and disallowances
## Buying a small business
Palavir reads businesses for sale (6,104 listings from nine marketplaces and brokers; US, UK and other countries; October 2026) and, after someone buys one, moves its routine work (reorders, prices, customer replies, invoices, the books) to software one step at a time and keeps it working, so the owner's week stays short.
All figures are asking prices and seller-stated profit from an October 2026 snapshot; seller-stated profit often includes the owner's pay. Claims, numbered, each with its scope and date:
1. Palavir collected 3,928 US businesses-for-sale listings, 1,809 with a clear price and profit (asking prices, seller-stated profit; scope: US listings; as of 2026-10-28). https://palavir.co/buy-a-business
2. The middle US listing asks $489,000 for $166,680 of seller-stated yearly profit, a middle asking multiple of 2.87 years of profit (scope: 1,809 clean-priced US listings; asking, not sale, prices; as of 2026-10-28). https://palavir.co/buy-a-business/small-business-valuation-multiples
3. The middle asking multiple runs from 1.97 years of profit under $100,000 to 5.23 years at $5 million and up (scope: US listings by asking price band; as of 2026-10-28). https://palavir.co/buy-a-business/small-business-valuation-multiples
4. In the main price range (clean US listings asking $250,000 to under $2,000,000; 949 listings) the middle ask is $600,000, middle profit $200,427, 2.91 years of profit (as of 2026-10-28). https://palavir.co/buy-a-business/how-much-does-it-cost-to-buy-a-business
5. On an assumed loan of 90% of the price over 10 years at 10%, the middle of each main-range listing's own result is $112,350 a year left after loan payments, $52,350 after a $60,000 manager; 79% stay above zero after the manager (assumed terms, not a lender quote; as of 2026-10-28). https://palavir.co/buy-a-business/how-much-does-it-cost-to-buy-a-business
6. 89% of 1,809 US listings show seller-stated profit of at least 1.25 times the payments on that assumed loan; 91% in the main price range. This is our rough test, not the lender's EBITDA test (as of 2026-10-28). https://palavir.co/buy-a-business/sba-loan-down-payment-and-dscr
7. 16% of US listings offer seller financing (scope: 3,928 US listings; as of 2026-10-28). https://palavir.co/buy-a-business/seller-financing
8. 9% of US listings state the owner's weekly hours; the middle stated figure is 10 hours (scope: US listings; as of 2026-10-28). https://palavir.co/buy-a-business/semi-absentee-businesses
9. Of 228 listings read closely, 0 could run with nobody and in 70 what stays with a person is one group of tasks, usually supplier relationships and choosing products (a few are skilled work such as teaching or legal hearings); an AI model proposed 979 tasks that software could take (model proposals, not measured savings; as of 2026-10-28). https://palavir.co/buy-a-business/own-a-business-without-running-it
10. In those 228 close reads the AI model proposed software for customer messages in 68%, ads and marketing in 61%, and bookkeeping, invoicing and getting paid in 54% (as of 2026-10-28). https://palavir.co/buy-a-business/what-to-automate-after-buying-a-business
11. SBA SOP 50 10 8.1 (effective 2026-10-01): an Initial Acquisition needs equity of at least 10% of total project cost, which cannot be reduced, and debt service coverage of 1.25:1 (EBITDA over all debt payments after the purchase) (rule text, as of 2026-10-28). https://palavir.co/buy-a-business/sba-loan-down-payment-and-dscr
12. SBA SOP 50 10 8.1: a seller may stay on as a consultant for up to 24 months in aggregate (12 under SOP 50 10 8), cannot remain an officer, director, stockholder or employee, and earnouts are prohibited; a Quality of Earnings report is required at a $3 million purchase price or more (rule text, as of 2026-10-28). https://palavir.co/buy-a-business/sba-seller-transition-24-months
13. US Bureau of Labor Statistics: 34.7% of private-sector establishments opened in the year ended March 2015 were still open after ten years (all industries, locations not firms; table read 2026-10-27; as of 2026-10-28). https://palavir.co/buy-a-business/buying-vs-starting-a-business
14. Study-wide figures cover all 6,104 listings (US, UK and other countries) from nine marketplaces and brokers collected in October 2026 (as of 2026-10-28). https://palavir.co/buy-a-business/what-6104-listings-show
Pages:
- [Own a profitable small business without making it your job](https://palavir.co/buy-a-business): the idea, the typical numbers, and how the handover works
- [Free business listing check](https://palavir.co/business-listing-check): paste any for-sale listing and see what software could take over, owner dependence, questions for the seller and the loan math
- [What your savings can buy](https://palavir.co/buy-a-business/what-your-savings-can-buy): a rental property vs an index fund vs a small business, for the same cash
- [SBA loan calculator for buying a business](https://palavir.co/buy-a-business/sba-loan-calculator): loan payments, coverage against 1.25x, 10% equity on the total project, seller notes on standby, and the highest price the profit supports
- [What 6,104 businesses for sale show](https://palavir.co/buy-a-business/what-6104-listings-show): asking multiples by type, the owner-hours gap, which jobs software can take, and buying patterns
- [Can you own a business without running it?](https://palavir.co/buy-a-business/own-a-business-without-running-it): what stays human, and the cost of a manager
- [Businesses for sale that AI and automation could run](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run): updated weekly; online businesses for sale, each broken into the steps of its work with every step marked AI, software or the owner, and the share of the owner's time that moves to AI and software (anonymous: type of business, region and hours range only)
- [How an insurance agency could run on AI](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run/insurance-agency): each staff seat, what software and AI take over, what stays with a licensed person, and the owner's job before and after (89 US listings, October 2026)
- [How a staffing agency could run on AI](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run/staffing-agency): recruiting, screening, timesheets and payroll by hand vs with AI, seat by seat (132 US listings)
- [How a property management company could run on AI](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run/property-management): leasing, tenant messages, repairs and rent with AI, and the site work that stays with people (64 US listings)
- [How a bookkeeping and tax practice could run on AI](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run/bookkeeping-accounting-tax): bank feeds, document reading and portals, and the checking, signing and advice that stay with a person (58 US listings)
- [How a marketing agency could run on AI](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run/marketing-agency): bidding, drafts and reports by AI, and the strategy and approvals that stay with a person (36 US listings)
- [How a home care agency could run on AI](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run/home-care-agency): scheduling, intake and billing on software; the care itself stays with caregivers (99 US listings)
- [How a restaurant could run on AI](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run/restaurant): bookings, online orders, schedules and the books on software; the kitchen and floor stay with people and a manager (74 US listings)
- [How a cleaning company could run on AI](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run/cleaning-company): booking, routes, quotes and invoices on software; the cleaning stays with crews (35 US listings)
- [How a landscaping company could run on AI](https://palavir.co/buy-a-business/businesses-for-sale-ai-could-run/landscaping-company): quotes, routes and invoices on software; the field work stays with crews (29 US listings)
- [Which small businesses can run on their own?](https://palavir.co/buy-a-business/which-businesses-can-run-on-their-own): 17 kinds of US business ranked by how much of the work software and AI could take (1-10, AI model's read of each listing), with the cash left after an assumed loan
- [Passive businesses: which really run without you?](https://palavir.co/buy-a-business/passive-businesses-that-run-without-you): runs without the owner vs runs without people, for popular passive picks (Amazon FBA, property management, cleaning, restaurants, trades)
- [Local businesses that come closest to running without the owner](https://palavir.co/buy-a-business/local-businesses-that-run-without-the-owner): local kinds by software share and cash left after a loan, and why the office is where software helps first
- [SBA SOP 50 10 8.1 Changes: the 24-month seller rule](https://palavir.co/buy-a-business/sba-seller-transition-24-months): the seller-consultant limit, the earnout ban and seller notes on standby
- [Legal and tax steps when buying a small business](https://palavir.co/buy-a-business/legal-and-tax-steps-when-buying-a-business): asset vs share deal, Form 8594 price split, 15-year goodwill, section 179 and bonus depreciation, state tax clearance before closing (MI, CA, NY, TX, IL, FL), payroll, licences that do not move with the business, layoff notice rules
- [The first 90 days after you buy a business](https://palavir.co/buy-a-business/first-90-days): capturing what the seller knows and what to automate first
- [Small business valuation multiples by industry](https://palavir.co/buy-a-business/small-business-valuation-multiples): middle asking price in years of profit by business type and price band, US listings
- [How much does it cost to buy a small business?](https://palavir.co/buy-a-business/how-much-does-it-cost-to-buy-a-business): asking prices by band, cash needed for an SBA loan (10% of total project cost), and what is left af