SolisMatica Logo
    SolisMatica
    Charles Elwood in Holland, Michigan, with Lake Michigan in the background

    Data Storytelling · Power BI · Frontier AI

    Turning data into better decisions.With AI and frontier models.

    Let’s Talk
    Microsoft AI MVP (Foundry)TEDx SpeakerHolland, Michigan

    Sometimes the problem isn’t where you think it is.

    That’s why I bring the data together. A useful visualization does more than show a number. It helps people see a relationship, question an assumption, or understand why work isn’t moving.

    Schedule variance report showing milestone delays by project and production stage
    See the use case
    Manufacturing / Power BI

    Long-lead materials weren’t the whole problem

    What people thought: Long-lead materials were causing the late shipments.

    What the report showed: Many smaller jobs had materials ready, then waited longer to start production.

    What it helped them review: Review how smaller jobs enter the schedule and set delivery dates from the production plan.

    Representative scenario with synthetic project names, dates, and figures.

    Purchasing model scorecard comparing supplier spend, contract compliance, and quality
    See the use case
    Purchasing / SQL Server + Power BI

    Three prices for the same part, and nobody could see it

    What people thought: Each supplier spreadsheet gave buyers a different view of the same parts.

    What the report showed: A single part master put contract price, paid price, delivery, and quality on one record.

    What it helped them review: Compare suppliers with the full history in view before deciding where to move volume.

    Illustrative supplier names, part numbers, and figures.

    Device fleet report drilling from company totals down to individual locations
    See the use case
    Multi-site enterprise / SQL Server + Power BI

    One clear picture of 120,000 devices across 70 locations

    A flat file of PC status data, rebuilt as a star schema. Leadership went from company wide trends down to a single location's top IT issue in seconds.

    Representative demonstration with synthetic data.

    Wastewater surveillance report with a site map and 14 day trend rankings
    See the use case
    Public health / SQL + Power BI

    Seeing an outbreak in the sewer before it hits the clinic

    Virus counts in wastewater move with the weather, not just with illness. Normalizing against PMMoV and adding a 14 day trend turned the file into a map people could act on.

    Representative demonstration with synthetic data.

    Guest return signals dashboard filtering 900 reviews by property and month
    See the use case
    Hospitality / Interactive demonstration

    Guest satisfaction is a score. Returning is a decision.

    A fictional hotel group, 900 invented reviews, and a working demo that separates a good rating from a guest actually saying they will come back.

    Fictional demonstration with synthetic data.

    How I help

    Start with the question.

    Business intelligence

    Power BI models and reports built around the decision you need to make.

    Learn more

    AI training and services

    Practical AI your team can use on real work and check with confidence.

    Learn more

    Speaking and workshops

    Talks for conferences, universities, Rotary, and teams on how AI changes work.

    Learn more

    Organizations I've worked with

    Meiji University
    Purdue Mitch Daniels School of Business
    Rotary International
    Mimaki
    Kids Food Basket
    Yanfeng
    Loyola University Chicago
    Bosch
    Blue Cross Blue Shield
    Hope College
    Aquora Research & Consulting
    MERC
    Cambia Health Solutions
    United Bank of Michigan
    Global Detroit
    Community Foundation of Holland/Zeeland
    Asian Pacific American Chamber of Commerce
    Michigan Economic Development Corporation
    Automation Alley
    West Michigan Works
    Holland Public Schools
    Holland Museum
    Electricity Generating Authority of Thailand
    International Trade Administration

    Questions people bring to the first conversation

    Yes. I use SQL, Power Query M, DAX, and Power BI to bring information together from systems, spreadsheets, and planning lists. The work starts with the question you need to answer, not a requirement to replace every tool you already use.

    That is common. Before building the visualization, I work through definitions, calculations, duplicate records, and the way information connects so the numbers mean what the team thinks they mean.

    Yes. The useful starting point is the decision the report needs to support. I can review the underlying data model, definitions, calculations, and visualizations to identify what is getting in the way of a clear answer.

    Yes. AI training can be a standalone need. I build hands-on training around the work people actually do so they can practice, ask better questions, and recognize when an answer needs checking.

    What do you wish your team could see more clearly?

    Tell me what’s getting in the way.

    Let’s Talk