For more than 35 years, Micron Technology’s teams of dreamers, visionaries, and scientists have redefined innovation—designing and building some of the world’s most advanced memory and semiconductor technologies. Holding more than 20,000 patents and offering the broadest portfolio of memory solutions in the industry, Micron continues to transform how the world uses information.

The challenge

Micron struggled to prepare and extract manufacturing big data from 12 separate sites in quickly enough time to produce meaningful, timely, and company-wide business intelligence. Given the inability to deliver data within the requested timeframes, many sites were self-serving and trying to access OLTP data directly, resulting in redundant processes, resource inefficiency, and data integration and performance issues. Projects that did occur were “one-offs”, with no ability to build onto or modify when needed. In short, the data warehousing and analytics solutions developed were not able to keep up with the needs of the business.

The solution

To address these challenges, the company used WhereScape® automation to design and build an enterprise Data Vault utilizing Data Vault 2.0 methodology on Teradata. With automation built specifically to leverage the native capabilities of Teradata, Micron implemented the foundation for its new enterprise data vault within 90 days.

Additionally, the Micron team is now able to produce a new prototype within an hour that can be used to evaluate effectiveness with business users before moving a solution into production. Micron now has rapid access to an enterprise-wide view of manufacturing big data, and the ability to respond to end-user queries and supply the data requested within the same day.

The results

• Implemented global enterprise data warehouse within 90 days
• Can deliver new data warehouse prototypes within an hour