Analytics & BI · FTTG Solutions LLC

Data that
drives decisions.

Senior BI Engineer with 8+ years in the Microsoft data ecosystem. I build reporting systems that turn complex operational data into clear, actionable intelligence for stakeholders at every level.

Scroll

Selected Work

Selected Outcomes

Featured

Behavioral Health Performance Platform

County-wide provider network

Problem

Operational and financial reporting was fragmented across 20 providers, making cross-provider performance difficult to monitor.

Solution

Built a 15-page Power BI reporting system with a Python ETL pipeline and SharePoint ingestion through Microsoft Graph API.

Impact

Delivered a single performance view for staffing, census, finance, CPO, and SE metrics to support faster county-level decisions.

Power BIDAXPythonMicrosoft FabricSharePoint APIDeneb/Vega-Lite

Hospital Operations Intelligence Layer

Multi-department clinical operations

Problem

Leaders lacked a consistent way to compare operational and clinical performance across departments.

Solution

Designed dimensional models and semantic reporting layers, then shipped executive dashboards for shared KPI visibility.

Impact

Improved executive reporting consistency and reduced decision latency across departmental stakeholders.

Power BISQL ServerDAXAzure

Insurance Portfolio Analytics Hub

Underwriting and claims performance

Problem

Business teams relied on ad hoc requests for visibility into policy and claims behavior.

Solution

Built a self-service analytics layer for underwriting and claims, backed by modeled data and reusable metrics.

Impact

Enabled business users to explore portfolio performance independently and reduced reporting dependence on IT.

Power BISnowflakedbtDAX

Logistics KPI Command Center

Warehouse and fulfillment workflows

Problem

Core supply chain metrics were distributed across separate reports and difficult to track in one flow.

Solution

Created consolidated KPI dashboards for warehouse operations, order fulfillment, and carrier performance tracking.

Impact

Provided operations teams with a unified view of logistics health and clearer bottleneck detection.

Power BISQLPythonExcel

Retail Performance Reporting Suite

Regional and departmental retail analytics

Problem

Teams needed clearer visibility into membership and inventory performance across locations.

Solution

Built dashboard suites for department and regional analysis with focused membership and inventory reporting.

Impact

Improved planning conversations by standardizing retail performance insights across business units.

Power BISQLPower Query

Technical Depth

Stack

Visualization

Power BIDeneb / Vega-LitePower Pages

Data Platform

Microsoft FabricAzure SynapseSnowflakeSQL Server

Languages

DAXPythonSQLM (Power Query)TypeScript

ETL / Integration

Azure Data FactoryMicrosoft Graph APIdbtPandas

Modeling

Dimensional ModelingStar SchemaSemantic LayerRLS/OLS

Tools

DAX StudioTabular EditorVS CodeGit

Background

About

I deliver full-stack web engineering services with a strong focus on TypeScript, clean API design, and maintainable product architecture.

I combine application engineering with BI consulting capability to deliver data-informed platforms that improve reporting, operations, and business decision-making.

Available for Engagements

Let's build something.

adefemi@kolawoles.com