Report ยท Chapter 9

Power BI data

The star schema exported for drawing, and the counts each visual will show.

Source: data/processed/powerbi 107 RFIs 6 October 2026
A construction site at dusk, with the structure lit against the sky.

Section 1Files to load

09_export_powerbi.py reads data/processed/rfi.duckdb and does not change it. It writes data/processed/powerbi/rfi_star_schema.xlsx, with one sheet per table, and one CSV beside that workbook. A later run replaces those files.

Every chart is a count, a filter, or a text lookup of these 107 RFIs. fact_rfi is one row per RFI, RFI-001 through RFI-107. No fact key is missing from a dimension, and every dimension row is used at least once.

TableRowsWhat a visual shows
dim_date9Received date
dim_party16Submitter or tasked party
dim_discipline10Derived discipline
dim_issue_type10Derived issue type
fact_rfi107The RFI itself

dim_party is one list. from_party_key and tasked_party_key are two relationships to that list. In this extract the roles do not share a name.

Discipline, issue type, status, and the document flags come from 06_build_rfi_features.py. They are the labels to draw. The workbook Status column is blank on every source row.

Section 2Dates

All nine received dates fall in September 2026. calendar_year is 2026 on every row and calendar_month is 9 on every row, so a month chart is one bar. A day chart is the date visual. date_received is a real date. date_key is the integer form, such as 20260901.

DateRFIs
2026-09-011
2026-09-026
2026-09-0467
2026-09-1011
2026-09-142
2026-09-151
2026-09-168
2026-09-173
2026-09-218

Section 3Parties

Six contractors submit the RFIs. Ten government or design parties are tasked to answer. A submitter chart and a tasked-party chart need both relationships to dim_party.

SubmitterRFIs
DAVID BOLAND, INC71
Carbon Recall Chattanooga11
Willdan8
Dobco, Inc.8
Richard Group LCC8
Schweitzer Engineering Laboratories, Inc.1
Tasked partyRFIs
AE66
CT15
PM9
JBMDL8
AE/JBMDL4
CT/PM1
USACE DB1
AE/PM1
AE/JBMDL/PM1
JBMDL/AE1

Section 4Discipline and issue type

Electrical is 40 of 107 RFIs, so a discipline bar chart will be led by that one category. Other and General are labels from the feature rules.

DisciplineRFIs
Electrical40
Other24
General15
Civil9
Structural5
Mechanical4
Architectural3
Quality / Inspection3
Controls / SCADA2
Cybersecurity2

Specification Clarification is 62 of 107. Constructability is RFI-023. Scope Gap is RFI-096.

Issue typeRFIs
Specification Clarification62
Compliance Requirement11
Missing Information11
Design Clarification6
Inspection / Quality6
Material Requirement4
Interface Coordination3
Drawing Conflict2
Constructability1
Scope Gap1

Section 5Status, length, and documents

Status is Answered when the response has text, and Open when it is blank. response_available repeats that split as the text values true and false. The eight open IDs are RFI-086, RFI-092, RFI-093, RFI-095, RFI-096, RFI-100, RFI-106, and RFI-107.

StatusRFIsresponse_availableResponse text
Answered99truePresent
Open8falseBlank, word count 0

Every question has text. Question length runs from 9 to 335 words, with a median of 69. Response length runs from 0 to 109 words, with a median of 16. The eight zeros are the open RFIs. Use the word-count columns for a length visual. Question and response text belong in a table or a tooltip.

The document flags are Yes, No, or Unknown, read from notes. Unknown means the note is blank or only says an attachment was sent. Document update is Yes when either drawing or spec is Yes. Those 19 Yes rows are 16 that update both, 2 that update a drawing only, and 1 that updates a specification only. The 51 No rows say no specification or drawing update is required.

FlagYesNoUnknown
Drawing update required185138
Spec update required175139
Document update required195137

notes has seven distinct phrases, so it is a label for a chart, not a long narrative. Fifty-one notes say no update is required, 35 are blank, and 15 say an updated specification or drawing was included. The other four notes record an attachment, a drawing update tied to RFI-47, a redundant update with RFI-08, or a specification-only update.

Section 6Fields for each visual

VisualFields
RFI countCount of fact_rfi.rfi_id
Received by daydim_date.date_received
Submitterdim_party.party_name through from_party_key
Tasked partydim_party.party_name through tasked_party_key
Discipline mixdim_discipline.discipline_name
Issue-type mixdim_issue_type.issue_type_name
Open against answeredfact_rfi.status
Document impactdocument_update_required, with Unknown kept as its own category
Question and response lengthquestion_word_count, response_word_count
RFI detailrfi_id, question, response, notes