Insight Consulting - Azure Data Platform Proof of Concept for Masco Corporation

As the sole consultant on this greenfield engagement, I delivered an end-to-end Azure data platform proof of concept (POC) that showcased ingestion, transformation, modeling, and visualization capabilities for Masco Corporation.

Architecture Overview

Azure Data Platform Architecture Diagram

End-to-end Azure data platform architecture provisioned via Terraform IaC

Infrastructure Provisioning

I customized and executed a Terraform script, my first client-facing IaC deployment, to stand up the core Azure resources:

Key responsibilities included naming conventions, resource grouping, and identity configuration (service principals, app registrations) to ensure best-practice security and manageability.

Data Modeling from Raw CSVs

The client provided five large CSV files with identical schemas but covering different date ranges. My goal was to design a Kimball-style dimensional model consisting of a sales fact table and dimension tables for products, customers, locations, and subsidiaries.

I conducted exploratory analysis to determine the appropriate grain and to identify potential dimensions by selecting distinct values from key attributes—such as company name, store ID, and region—and validating with stakeholders which entities represented subsidiaries or store-level operations.

I also cleaned and standardized user-input columns like addresses, mapping variations (e.g., "123 Main St." vs. "123 Main Street") to consistent values. These assumptions were validated through multiple review sessions with the client to ensure alignment between business understanding and technical implementation.

Enhancements & External Data Integration

Finishing core scope ahead of schedule, I integrated daily copper prices via a public API—critical for a manufacturer reliant on copper. A Databricks notebook ingested the feed into a Delta Lake table, enabling time-series joins with sales data and richer insight in downstream reports.

Power BI Demo Dashboard

I built a demonstration Power BI report featuring:

The dashboard served to illustrate platform potential; Masco stakeholders were extremely pleased with the technical execution and business value of the POC.