Power BI IT Dashboard Development
Budget: $250 – $750 USD
Project Title: Power BI IT Dashboard Development – Enterprise Endpoint Security & Patch Compliance
Project Description:
I need an experienced Power BI developer to build an automated IT operations dashboard for an enterprise environment managing approximately 80,000 endpoints. This is a focused on security patch compliance and endpoint health monitoring. The dashboard will pull from Excel VBA-generated output tables and display:
Software update/patch compliance status (aligned to BOD 22-01 CISA requirements)
Endpoint health status (active, stale, quarantined)
Pending reboot tracking by machine count and aging
Quarantine queue metrics — machines blocked vs. remediated vs. stale entries
Hardware/software inventory visibility
Trend tracking over time (weekly/monthly patch cycles)
Data Source: Structured Excel workbook with VBA macros that generate clean output tables — developer will connect Power BI to these tables and build the visual layer.
Timeline:
First release target: ASAP Can discuss timeline.
candidates must be available to start immediately
Ideal Skills:
Power BI (Desktop + Service)
Excel/VBA data source integration
IT operations or cybersecurity dashboard experience
Ability to work iteratively with a SME (me) to refine visuals
Enterprise IT background a plus
Deliverable: A fully functional .pbix file with documented data connections, ready for recurring refresh from updated Excel inputs.
Project Description:
I need an experienced Power BI developer to build an automated IT operations dashboard for an enterprise environment managing approximately 80,000 endpoints. This is a focused on security patch compliance and endpoint health monitoring. The dashboard will pull from Excel VBA-generated output tables and display:
Software update/patch compliance status (aligned to BOD 22-01 CISA requirements)
Endpoint health status (active, stale, quarantined)
Pending reboot tracking by machine count and aging
Quarantine queue metrics — machines blocked vs. remediated vs. stale entries
Hardware/software inventory visibility
Trend tracking over time (weekly/monthly patch cycles)
Data Source: Structured Excel workbook with VBA macros that generate clean output tables — developer will connect Power BI to these tables and build the visual layer.
Timeline:
First release target: ASAP Can discuss timeline.
candidates must be available to start immediately
Ideal Skills:
Power BI (Desktop + Service)
Excel/VBA data source integration
IT operations or cybersecurity dashboard experience
Ability to work iteratively with a SME (me) to refine visuals
Enterprise IT background a plus
Deliverable: A fully functional .pbix file with documented data connections, ready for recurring refresh from updated Excel inputs.