Ask
Start with the decision
Before any data work, we agree what the report is for, who uses it, and what they will do differently because of it.
Answers: "What do we actually need to know?"
Data and analytics consultant
Clear answers from your data, not just more dashboards.
- Reports your team trusts, because the numbers reconcile.
- Answers in one place instead of spread across spreadsheets.
- Every page built around a decision someone has to make.
5+ years in business intelligence: Power BI, data modelling, analytics, and forecasting. Based in San Diego, CA.
How I work
From a question to a decision you can defend.
Every project moves through the same four layers. Each one answers a question your team is already asking.
Model
Build numbers you can trust
Sources are cleaned and joined into one data model, with checks so the same figure means the same thing on every page.
Answers: "Can I rely on this number?"
Show
Put answers in front of people
Power BI reports that lead with what changed and why, in the language your team already uses.
Answers: "What changed, and what should I do about it?"
Forecast
See what is likely to happen next
Where there is enough history, models that put an honest range around what comes next, built into the same reports.
Answers: "Where are we heading if nothing changes?"
Services
Three ways to work together.
Each is scoped and priced before anything starts.
Dashboard build
A new Power BI report built from your spreadsheets or systems: scoped around the decisions it has to support, modelled properly, and handed over with documentation.
Recent proofReal estate portfolio dashboard
Report rescue
An existing report that is slow, wrong, or nobody trusts. I find what is broken in the model or the measures, fix it, and explain what changed.
Recent proofUrgent Power BI support
Ongoing support
A set block of hours each month for new pages, changes, and questions, so your reporting keeps up with the business.
Recent proofWell characterization, repeat client
Client work
Where this has paid off.
Client dashboards stay private, so these describe the work rather than showing screens.
35 hours, repeat client
Well characterization dashboard
Complex Excel workbooks for an oil and gas consultancy turned into a star-schema model and an interactive report for comparing wells.
Delivered within 2 days
Real estate portfolio dashboard
Occupancy, revenue, expenses, and ROI across a property portfolio in one documented report, with drill-through to each property.
Personal builds
Built end to end, on my own.
From problem framing to a working tool, with no team behind me.
QuickBooks OnlineDrive spreadsheetsPython extractPostgresSQL star schemaPower BI report
$722K of stuck cash surfaced
Cash flow and job profitability
An end-to-end case study for a commercial interiors contractor: where cash is stuck, who pays late, and which jobs lose money, in one Power BI report.
Read the case studyIn TestFlight beta
repIQ
An iOS workout tracking app with an analytics focus, designed, built, and taken to beta solo.
Reviews
What clients say.
★★★★★
"Alfonso exceeded my expectations with both the quality and speed of his work. He developed a well-structured Power BI data model, handled complex Excel data integration, and adapted quickly as the project evolved. He was proactive, easy to communicate with, and consistently delivered on time. I highly recommend him and look forward to working with him again on future projects."
Well characterization dashboard
★★★★★
"Alfonso delivered an excellent Power BI dashboard that clearly visualized property occupancy, revenue, expenses, and ROI across my real estate portfolio. He was professional, communicative, and provided a well-documented, easy-to-use dashboard that exceeded expectations."
Real estate portfolio dashboard
★★★★★
"I can't recommend Alfonso enough! He came through with a last-minute project that required a very late evening. His work was excellent, and [he] would be an asset to any person or team."
Urgent Power BI support
About
An analyst who explains the why.
I'm a senior business intelligence analyst in utility-scale solar construction, where I build reporting across finance, operations, project controls, engineering, and estimating. I also run an internal training program that teaches non-analysts to work with their own data, so I am used to explaining technical decisions in plain language.
I hold an M.S. in Data Science with a focus on machine learning and AI. Most of my client work today is Power BI: data modelling, DAX, and reports that end in a clear next action. Forecasting and AI work is where I am heading next.
FAQ
Common questions.
What kinds of projects do you take on?
Mostly Power BI: new dashboards, fixing or speeding up existing reports, data modelling, and DAX. I also take on SQL and Python analysis work, and I am open to forecasting projects where there is enough history to model.
My data is in spreadsheets. Is that a problem?
No. Several of my projects started from Excel files. Part of the work is turning those into a clean model that refreshes reliably.
How do you price work?
Where the scope is clear I quote a fixed price for a defined deliverable. For open-ended or ongoing work I use a monthly block of hours. Either way you see the number before anything starts.
How do you handle confidential data?
I am happy to sign an NDA before seeing anything, and I work inside your environment where possible. I do not publish client dashboards or data.
What happens after you hand over?
You get documentation covering the data model, the measures, and how to refresh and extend the report. If you want me to stay involved, we can set up ongoing support.
Not sure what you need yet? That is what the call is for.
Book a free 30-minute intro call. Tell me what you are trying to answer with your data, and I will tell you honestly whether I can help and what it would take.
Book a free intro call