Power BI Dashboards & Reporting
Interactive dashboards, automated reports, and KPI tracking that turn complex data into clear, decision-ready insights.
Blink BI
Data Insights at a Glance
Transforming raw data into actionable insights that drive smarter business decisions.
What We Do
Business Intelligence Solutions
SQL, ETL & Azure Data Pipelines
Database design, performance tuning, and automated pipeline solutions built on Azure — clean, reliable data flowing in from every source, on schedule.
Power Platform Solutions
Canvas apps, Power Automate flows (web and RPA automation), and Power Pages portals that extend your data into real, day-to-day business tools.
Custom API Integrations
Sourcing, vetting, and connecting the APIs your reports and apps actually need — plus the ongoing care to keep those connections working.
Why Blink BI
Enterprise rigor, small-firm speed
Client-facing report types we build
Common, high-demand Power BI reports — and exactly what gets connected to build each one.
| Report | Connects Power BI to |
|---|---|
| Cash flow & financial health | QuickBooks Online / Xero connector, or GL export (Chart of Accounts, AR, AP, bank transactions) |
| Sales pipeline & conversion | Salesforce / HubSpot / Dynamics 365 connector, or CRM export (deals, stage, amount, close date, owner) |
| Billable hours & utilization | Harvest / Toggl / QuickBooks Time export (employee, project, client, hours, billable flag) |
| HR headcount & turnover | BambooHR / Gusto / ADP export (roster, hire/term dates, department, comp) |
| E-commerce operations | Shopify / WooCommerce / Square connector (orders, line items, customers, products) |
| IT helpdesk metrics | Zendesk / Freshdesk / Jira Service Management export (tickets, resolution time, category) |
Verified Credential
Microsoft Certified: Power BI Data Analyst Associate
An official Microsoft certification (PL-300), earned through Microsoft Learn — not a self-issued claim.
Credential ID
8D18A34C314436A0
Portfolio
Dashboards that get used, not just admired
Every card below is pulling real, live data on page load — not a mockup, not a static screenshot. The Philadelphia property tax report is a genuine published Power BI embed; the rest are live widgets built directly from public APIs. Client work available on request under NDA.
Live Example · Power BI
Philadelphia Legacy Property Tax Balances by Year
A real, published Power BI report — explore how outstanding property tax balances have trended across Philadelphia going back to the 1970s. This is a live embed, not a mockup.
Integrative Capability
Real-Time & Live Data Integrations
Beyond static reports, Blink BI builds dashboards wired directly to live public data feeds — no stale exports, no manual refresh. See it in action in the cards below, where the World Cup scoreboard and market snapshot are pulling real data right now, live in your browser.
Live Sports Scoreboard
Automatically shows today's live/upcoming games from whichever major league is in season — soccer, MLB, NFL, NBA, or NHL — pulled directly from ESPN's public scoreboard feed.
Data: ESPN ↗Live Market Snapshot
Real-time index and equity pricing via the Finnhub API, refreshing live in your browser.
Data: Finnhub ↗Live Crypto Ticker
Bitcoin, Ethereum, and more, priced live via CoinGecko's public keyless API — no signup required.
Data: CoinGecko ↗Live Philadelphia Weather
Current conditions for Philadelphia via Open-Meteo's free forecast API, updated straight from national weather models.
Data: Open-Meteo ↗Live Air Quality Index
PM2.5, PM10, and overall air quality for Philadelphia, sourced live from Open-Meteo's air quality models.
Data: Open-Meteo ↗Live USD Exchange Rates
USD against EUR, GBP, JPY, and CAD, priced live from European Central Bank reference rates via Frankfurter.
Data: Frankfurter ↗
Data Catalog
Public data available for ad hoc reporting
Every dataset below is a confirmed, currently-published entry from OpenDataPhilly's official registry — no search queries, no guesses. Where available, each entry links to its specific API interface and its page on the Philadelphia Metadata Catalog, in addition to its OpenDataPhilly listing. Search or filter below — every entry can become a custom Power BI report, dashboard, or ad hoc analysis.
About
Years turning raw data into decisions people actually trust
Blink BI has years of hands-on experience designing, developing, and tuning SQL Server environments, SSIS/SSRS pipelines, Dataverse, Azure Resources and Power BI reporting for organizations ranging from federal health agencies to private retail and healthcare companies.
Recent work includes building Power BI and Power Platform solutions for the CDC — including row-level and object-level security for sensitive data, dimensional modeling for complex drill-through reporting, and automated data pipelines using Power Automate and Azure. The approach is hands-on and consultative: every engagement starts with how your team actually works, not a generic template.
Power BI Certified
Federal-Level Data Security Clearance
Power PlatformSQL ServersAzure Resources
SSIS / SSRS / SSASDAX / Power MFabric
Dynamics 365PythonC#Tableau
SharePointMDXDataverse
Testimonials
Real engagements — client quotes coming soon as projects wrap
“Currently building delinquent property tax tracking for a Philadelphia-area property developer — the same live Power BI report featured above in the Portfolio section started as work for this client. Not yet publicly announced by the client, so no name here, but the report itself is real and running live.
In Progress “Currently requesting public records from the City of Wilmington, DE via FOIA to extend the delinquent-property-tax report model to that market — same approach as the Philadelphia report, new jurisdiction.
Blog
Notes on BI, data, and dashboards
Practical notes on Power BI, SQL, and Philadelphia's public data — written from real project work.
Power BI & Public Data
How to Find Delinquent Tax Properties in Philadelphia
Where the data actually comes from, how to read overdue vs. delinquent correctly, and what happens after a property goes delinquent.
Read the full post → Power BI & Public DataReading a Philadelphia OPA Property Record
How to make sense of assessed value, exemptions, abatements, and the fields on every parcel's OPA record.
Read the full post → APIs & Data IntegrationWhat Is an API, and Why Does Connecting One Take a Professional?
A plain-English explanation of what APIs are, what actually goes into connecting one properly, and why it's rarely as simple as it sounds.
Read the full post → Weather & Public DataPhiladelphia's Air Quality Right Now, and the API Behind It
Philadelphia issued a Code Red Air Quality Alert today from Canadian wildfire smoke — how to read an AQI number, and the free API tracking it live on this site.
Read the full post →Get new posts by email
No spam, no schedule — just an email whenever a new post like the ones above goes up.
No spam. Unsubscribe anytime.
Contact
Let's talk about your data
Tell me a bit about the project and I'll follow up within one business day.