Power BI Consulting for Vancouver, Washington Clinics, Port Tenants and Businesses Working Both Sides of the River
A Clark County company often sells in Oregon, staffs from both states and files taxes in two systems. Its reports should show that split without a separate workbook for each side of the Columbia.
Lightray's Power BI consulting in Vancouver, WA is built for companies whose numbers do not stop at the state line. We model Washington and Oregon activity side by side, so revenue, payroll and tax exposure can be read for either state or both, and we do the same for clinic groups, healthcare vendors and the manufacturers and shippers working on port property.
It begins with a free 30-minute strategy call with Edward Pinela, MBA, who scopes the two-state model and then builds it himself. The work is entirely remote; Lightray's business address is in Fullerton, California, and there is no office or staff on either bank of the river. Once the call settles what you need, you either prepay Power BI Flex Support hours, starting at $2,500 for a 20-hour block billed at $100 to $125 an hour, or sign a fixed quote. If you don't like working with us within the first 4 hours, we return your money.
“Great firm, they understood our company needs really quickly… their approach was very hands on…”
— Jean-Michel C., Google review
How do you report a business that operates in both Washington and Oregon?
By tagging every transaction, employee and location with a state in the model rather than splitting files. One semantic model then answers both questions: how is the company doing, and how is each state doing. Filters, row-level security (rules restricting which rows a user may see) and separate report pages handle the rest.
This matters in Clark County because the two states tax very differently, and many firms here sell into Portland while hiring on both sides. Finance needs Washington B&O and sales-tax activity apart from Oregon payroll, while owners want one consolidated view. Building both from the same tables keeps those totals from drifting apart.
What do Vancouver healthcare providers and suppliers build first?
Usually visit volume, collections and referral sources by clinic. Vancouver's two hospital systems, PeaceHealth Southwest and Legacy Salmon Creek, sit at the center of a large network of independent practices, therapy and imaging groups, home-health agencies and supply vendors, each with its own practice-management or billing system.
A first model joins those systems to accounting, so a practice manager sees which referral sources produce paid visits and which locations lag on collections. Patient-level detail stays out of shared reports; dashboards show counts and amounts, and anything identifiable remains in the source system.
- Visits, no-shows and provider utilization by clinic and week
- Claims submitted, denied and paid by payer
- Referral source to paid visit, by month
- For vendors: orders, fill rate and margin by facility customer
What about manufacturers and shippers at the port?
The Port of Vancouver USA, created by public vote in 1912, reports 50 industrial tenant businesses and nearly 4,000 people working on port property, moving more than 7 million tons of cargo a year: wheat, bulk minerals and liquids, vehicles and project cargo. Its tenants include packaging, heater, steel-fabrication and malting companies.
Those firms tend to need production and shipment reporting that ties to cost. The table below lists the first build we suggest for each kind of Vancouver business, including the two-state view where it applies.
| Vancouver business | Data it already has | First build |
|---|---|---|
| Independent clinic or therapy group | Practice-management system, billing, QuickBooks | Visits, collections and referral yield by location |
| Healthcare supply or service vendor | ERP or order system, CRM | Orders, fill rate and margin by facility |
| Port tenant manufacturer | ERP, production logs, freight invoices | Cost per ton or unit and on-time shipments |
| Contractor working in WA and OR | Job costing, payroll for two states | Job margin with labor and tax split by state |
| Retailer or service firm selling into Portland | POS or invoicing, accounting | Sales by customer state, with a consolidated total |
What does a Vancouver Power BI project cost?
Consulting hours are sold in prepaid Flex Support blocks of 20, 40 or 80 at $100 to $125 an hour; the hours never expire, and the 20-hour block is $2,500. A clinic dashboard or a two-state finance model from clean data often fits the first block. Larger work receives a fixed quote after the call.
Power BI licensing is paid to Microsoft. The Power BI pricing page shows Pro at $14 and Premium Per User at $24 per user per month on annual billing. For a practice with six managers who view and share reports, that is roughly $84 a month in Pro licenses.
Which other Pacific Northwest pages fit a Clark County business?
See how the same service fits Power BI work for Seattle companies and Spokane healthcare and manufacturing, or, across the river, Power BI consulting in Portland, Oregon. The Power BI consulting services page has the full offer, and the locations hub lists every city served.
Edward has 20+ years in data and web work and 200+ projects delivered, and Lightray carries a 4.9 Google rating. The consultant on your first call is the one who builds and supports the model.
Further reading: Microsoft Learn — row-level security.
One model for both sides of the river?
Book a free 30-minute call with Edward Pinela, MBA. You get an honest read on what to fix first — and if we are not the right fit, you will hear that on the call.
Frequently asked questions
Do you have consultants in Vancouver or Portland?
No. Lightray has no office or staff in either city; the business address is in Fullerton, California. Every session runs over video and screen share during Pacific business hours, and the model lives in your own Microsoft tenant, so nothing depends on travel.
Can a clinic use Power BI without exposing patient information?
Yes, if the model is designed for it. We report aggregates such as counts, amounts and rates, keep identifiable fields out of shared datasets, and limit access with row-level security and workspace roles. Your compliance lead approves the field list before anything is published.
What do you need from us to start?
Read access to the systems that hold the numbers, the reports or spreadsheets you rely on today, and a person who can answer questions about how the business counts things. For two-state reporting, a short note from your accountant on how each state's activity is tracked helps.
How long does a first build take?
Two to four weeks for one model from one or two systems, including a check against figures you already trust. Adding a second state or several clinics extends that, and the fixed quote states the schedule before you commit.
You Won’t Get Handed Off to Junior Staff.
At most consulting firms, the senior person who sold you shows up for the kickoff — then you get handed to a team of juniors learning on your dime. That’s not how we work.
When you hire Lightray Solutions, you work directly with Edward Pinela, MBA — a principal consultant with 20+ years of experience across Power BI, web development, SEO, and CRM systems. Edward architects every engagement personally, stays involved through delivery, and answers his own phone.
Read Edward’s Full Bio“Mid-market companies deserve senior-level expertise without paying enterprise-agency prices. That’s the gap Lightray fills.”
Simple. Transparent. Proven.
No black-box processes. No endless discovery phases. A straightforward three-step approach designed to deliver measurable results fast.
Discovery Call
Free 30-minute strategy session where we assess your data landscape, website, marketing — and where AI would genuinely pay off versus where it's hype.
Free · No ObligationCustom Roadmap
You receive a tailored plan with clear deliverables, realistic timelines, and expected ROI. You approve every detail before we start.
Fixed Scope · Clear PricingMeasurable Results
We execute, measure, and optimize. You get dashboards, regular check-ins, and full visibility — so you always know the impact.
Data-Driven · TransparentGet a clear plan in one free call.
Tell us what you are trying to fix. Your request goes to Edward Pinela, MBA — the principal consultant who would do the work — and you hear back within 4 business hours.
Prefer to call? +1 (714) 872-9606