Power BI Consulting for Grand Rapids Manufacturers Getting Their Data Ready for AI
West Michigan plants are being pitched AI from every direction. Ask Copilot a question about scrap or margin, though, and the answer is only as good as the data model underneath it, which in most companies does not exist yet.
Lightray's Power BI consulting in Grand Rapids, MI starts where most AI projects should: with a clean, documented data model. For West Michigan manufacturers, food processors and health-science suppliers, we build the Power BI semantic model and reports first, then prepare that model so Copilot and other AI tools can answer questions about production, quality and margin accurately.
Start with a free 30-minute strategy call with Edward Pinela, MBA, who does all the building himself. Lightray works remotely from a business address in Fullerton, California, with no Michigan office. Work after the call draws on Power BI Flex Support (20 hours for $2,500, with hours priced $100 to $125) or a fixed quote. If you don't like working with us within the first 4 hours, you get your money back.
“Great firm, they understood our company needs really quickly… their approach was very hands on…”
— Jean-Michel C., Google review
What does West Michigan's economy run on?
The Right Place, the region's economic development organization, describes Greater Grand Rapids as home to one of the nation's largest and most extensive manufacturing sectors, alongside health sciences on the Medical Mile, a fast-growing information-technology sector, and food processing and agribusiness supported by one of the country's most productive farming regions.
Office furniture, castings, automotive parts, packaged foods and medical devices all come out of the same few counties. Those companies generate a great deal of operational data and, increasingly, field questions from owners about what AI could do with it.
Can Copilot in Power BI answer questions about our plant?
It can, under two conditions. First, licensing: Microsoft's Copilot for Power BI overview requires a paid Fabric capacity of F2 or higher, or Premium P1 or higher, and states that a Pro or Premium Per User license alone is not sufficient. Second, the model: Microsoft warns that without preparation, Copilot can misinterpret data and return generic or inaccurate answers.
Preparation means clear table and column names, measures with plain-English descriptions, relationships that reflect how the business works, and synonyms for the words your team actually uses. That is ordinary good modeling, and it is most of the work.
- Rename cryptic ERP fields into business terms
- Write a description for every measure Copilot may use
- Hide technical columns users should never query
- Test the twenty questions managers ask most and fix wrong answers
What should a Grand Rapids company build before turning on AI?
The same reports it would want anyway: production against plan, scrap and first-pass yield, on-time delivery and margin by customer and product. Building those first proves the numbers are right; adding Copilot afterward lets managers ask follow-up questions in plain language. The table shows the order we recommend for each type of West Michigan business.
For a broader look at where AI fits beyond reporting, see Lightray's AI consulting page.
| Grand Rapids business | Build first | Ask Copilot afterward |
|---|---|---|
| Office-furniture or fixtures maker | Orders, lead time and margin by product line | Which product lines lost margin this quarter, and why? |
| Foundry or metal-parts supplier | Scrap, yield and on-time delivery by part | Which parts drove most of last month's scrap cost? |
| Food processor | Yield, waste and cost per case by line | How did yield on line two compare with last season? |
| Medical-device or health-science supplier | Lot release time and complaints by product | Which products had the longest release times? |
| Distributor or wholesaler | Sales, margin and stock turns by customer | Which customers' margins fell below target? |
What does this cost a Grand Rapids company?
Flex Support time costs $100 to $125 an hour in prepaid blocks of 20, 40 or 80 hours that never expire; the 20-hour block is $2,500. A first production and margin model from one ERP often fits that block, and AI preparation usually adds a second. Larger scopes are quoted as a fixed price after the call.
Microsoft bills licensing. Microsoft's Power BI price list shows Pro at $14 and Premium Per User at $24 per user per month, paid yearly; Fabric capacity for Copilot is listed there as variable. We size the smallest capacity that fits before you buy.
Which other Michigan pages help a plant preparing for Copilot?
Across the state, see Power BI consulting for Detroit suppliers and service firms. The Power BI consulting services page describes everything included, and the Power BI consulting city index lists other locations.
Every model is built by Edward himself, drawing on 20+ years of data and web work and 200+ delivered projects; Lightray's 4.9 Google rating comes from clients who worked with him directly.
Further reading: Microsoft Learn — Copilot for Power BI.
Build the model AI will rely on
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 work on site in Grand Rapids?
No. Lightray is fully remote, with no Michigan office or staff. We meet over video in Eastern business hours, and the model, reports and any Copilot setup live in your Microsoft tenant under your administrator's control.
Do we need Copilot to get value from this?
No. The reports are useful on their own, and many clients stay on Pro licenses without Copilot. Building the model so it is AI-ready simply means the option is there later without rework.
Is our data sent to an outside AI service?
Copilot runs inside Microsoft's service under your tenant's settings, and your administrator controls whether it is enabled. Microsoft publishes its privacy and security terms for Copilot in Power BI, which your IT lead should review before switching it on.
What if our first AI-readiness sessions are disappointing?
Then you stop. Under the Power BI guarantee, a West Michigan plant that doesn't like working with us within the first 4 hours gets its money back; those hours usually cover reviewing the ERP data and naming the first scrap and yield measures.
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