Semantic model
What it is
One structured model so every report reads the same tables and relationships.
The pain
Two dashboards, two numbers for the same KPI.
You get
A star schema, clean relationships, and a short dictionary of tables.
Home / Power BI
Power BI consulting
Power BI consulting & dashboard development
One model. One number. A view leadership trusts.
PeekGraph builds the Power BI semantic model, the DAX measures, and the executive dashboards around them — so Monday’s report matches Friday’s, and nobody is defending a spreadsheet.
Work covers Power BI Desktop, Power BI Service, Power Query, row-level security, and paginated reports. Excel, SQL, and existing .pbix files are starting points — not the finished view.
Workstreams
What a Power BI engagement includes
Power BI data modeling, DAX, dashboards, paginated reports, workspace access, and refresh. Scope is named on the call — nothing is billed from this page.
DAX & KPI layer
What it is
Measures live in one place. Visuals consume them.
The pain
Five people calculate “margin” five ways.
You get
A measure table and DAX that still works when the grain changes.
Executive dashboards
What it is
A Monday view leadership can open without a walkthrough.
The pain
Forty pages and a meeting only to explain the report.
You get
One to three pages and drill-through where it matters.
Paginated reports
What it is
Pixel-true printable output for finance and ops.
The pain
Dashboard export that clips totals.
You get
Parameterized layouts and repeating headers.
Workspace & RLS
What it is
Who can publish, who can view, which rows each person sees.
The pain
A regional manager saw another region’s numbers.
You get
Workspace roles and row-level security rules.
Power Query & refresh
What it is
Dirty inputs cleaned once, then refreshed on a schedule.
The pain
Someone pastes a CSV every Friday.
You get
Stable queries and a failure you hear about before the meeting.
Fit
Who this is for
Operators
A weekly ops meeting that still starts with three Excel files.
Finance & FP&A
Numbers that survive an audit question, not a dashboard only the builder understands.
Leadership
Power BI is already paid for. One view is missing.
Sample
A Power BI view, not a template
View sample dashboard
Sample · Power BI
Revenue operating view
Three Excel files for the same KPI → one semantic model, one revenue number. Demonstration data, not a client file.
FAQ
Power BI questions before a call
Can PeekGraph start from an existing .pbix?
Yes. Most Power BI work starts with the file already in the meeting.
Can Power BI connect to Excel, SQL, or Salesforce?
Yes. Power Query can land Excel, SQL, and common SaaS exports into one model.
How much does a Power BI project cost?
A written range comes after the call. Nothing is billed from this page.
How long is a first Power BI dashboard?
A focused executive view is usually weeks, not months — after the metrics are locked.
Is confidential company data used as a case study?
No. The sample on this page is a demonstration.
Does Power BI work run remotely with a US team?
Yes. The files stay with you at handoff.