ABC Supply delivers self-service analytics using Dremio to organize domain data and accelerate development

Increased independence for BI team by eliminating data bottlenecks

Optimized Snowflake performance while maintaining ~9,400 Dremio jobs/day

Provided easy and fast access to 70+ data sources for 1,200 daily BI users

ABC's of ABC Supply


The Customer:

ABC Supply is the largest wholesale distributor of roofing materials in North America and a key distributor of siding, windows, and other exterior and interior building products. Founded in 1982 and headquartered in Beloit, Wisconsin, the company is dedicated to serving professional contractors with a broad product range, excellent service, and strong values of respect and teamwork. ABC Supply operates over 800 locations nationwide and continues to grow, driven by a commitment to helping contractors build their businesses and achieve success.

The Challenge:

ABC Supply faced significant challenges with scalability and performance in their data management systems. The direct connection between Tableau and Snowflake resulted in slowness, timeouts, and lost connections, complicating the management of large multi-year data extracts and causing frequent failures. This situation led to a dependency on the data engineering team for any new or modified Tableau dashboards, creating bottlenecks and slowing down development.

Additionally, the lack of a consistent, efficient, and metadata-driven process for managing data pipelines made it difficult to ensure the creation and maintenance of enterprise data sets. There was also a need for better organization and accessibility of data, as well as a centralized repository for shareable code to avoid duplication and ensure consistency across various dashboards and reports. These challenges hindered ABC Supply's ability to effectively manage and utilize their data to support growth and decision-making.

The Solution:

To solve these challenges, ABC Supply implemented a more robust data architecture that included the introduction of Dremio. This platform improved data management by organizing data into domains and providing a centralized repository for shareable code, which enhanced consistency across dashboards and reports. By connecting Tableau to Dremio instead of directly to Snowflake, they addressed performance issues, eliminating slowness, timeouts, and lost connections.

Additionally, ABC Supply developed a metadata-driven process to manage their data pipelines, ensuring efficient and consistent creation of enterprise data sets. This approach reduced their dependency on the data engineering team, allowing BI deveopers and business analysts to access well-organized data more independently and efficiently. These solutions streamlined data management, improved performance, and supported ABC Supply's continued growth and data-driven decision-making.

"[with] Dremio performance and it being faster, and no longer depending on data engineering, that was an acceleration of our turnaround time...Dremio provides easily accessible and understandable data sets for their ad hoc analysis needs. Dremio also enables us to use active directory groups to govern who can access which spaces so that both our BI development and BA self-service users can only access what they need."

Stephen Brehm

Manager of Business Intelligence, ABC Supply

The Results:

The implementation of this solution led to several positive results for ABC Supply. Firstly, connecting Tableau to Dremio significantly improved performance, eliminating issues like slowness, timeouts, and lost connections. This allowed for more reliable and efficient data management, particularly with large multi-year data extracts.

Secondly, the metadata-driven process for managing data pipelines ensured the efficient and consistent creation of enterprise data sets. This reduced the dependency on the data engineering team, accelerating the development of new dashboards and modifications to existing ones. Consequently, BI developers and business analysts gained easier and more independent access to well-organized data, enhancing their ability to perform ad hoc queries and make data-driven decisions. Overall, these improvements streamlined data management processes and supported ABC Supply’s continued growth and operational efficiency.


ABC Supply created a centralized location to find all of the data needed for the various dashboards across data domains thanks to Dremio. They accomplished this with Dremio Spaces, allowing them to organize all of the domain-related data into virtual data sets by domain. Because of this, ABC Supply achieved their goal of creating a robust enterprise data set, which is analytics ready with all the business requirements that are in there and provide reporting across enterprise.

get started

Get Started Free

No time limit - totally free - just the way you like it.

Sign Up Now
demo on demand

See Dremio in Action

Not ready to get started today? See the platform in action.

Watch Demo
talk expert

Talk to an Expert

Not sure where to start? Get your questions answered fast.

Contact Us

Ready to Get Started?

Bring your users closer to the data with organization-wide self-service analytics and lakehouse flexibility, scalability, and performance at a fraction of the cost. Run Dremio anywhere with self-managed software or Dremio Cloud.