Download PDF
Micron's Rapid Data Warehouse Solutions Through IoT
Technology Category
- Functional Applications - Enterprise Resource Planning Systems (ERP)
- Functional Applications - Warehouse Management Systems (WMS)
Applicable Industries
- Cement
Applicable Functions
- Warehouse & Inventory Management
Use Cases
- Additive Manufacturing
- Picking, Sorting & Positioning
Services
- Data Science Services
The Challenge
Micron Technology, a leading innovator in memory and semiconductor technologies, faced a significant challenge in managing and extracting manufacturing big data from 12 separate sites. The company was unable to deliver data within the requested timeframes, leading to many sites attempting to access OLTP data directly. This resulted in redundant processes, resource inefficiency, and data integration and performance issues. The data warehousing and analytics solutions developed were not able to keep up with the needs of the business. Projects that did occur were isolated, with no ability to build onto or modify when needed.
The Customer
Micron Technology
About The Customer
Micron Technology is a global leader in the semiconductor industry, with over 35 years of experience in innovation. The company's teams of dreamers, visionaries, and scientists have redefined innovation by designing and building some of the world's most advanced memory and semiconductor technologies. Micron holds more than 20,000 patents and offers the broadest portfolio of memory solutions in the industry. The company continues to transform how the world uses information, but faced challenges in managing and extracting big data from its multiple manufacturing sites.
The Solution
To overcome these challenges, Micron Technology turned to WhereScape® automation to design and build an enterprise Data Vault using Data Vault 2.0 methodology on Teradata. This automation was built specifically to leverage the native capabilities of Teradata, allowing Micron to implement the foundation for its new enterprise data vault within 90 days. Furthermore, the Micron team can now produce a new prototype within an hour that can be used to evaluate effectiveness with business users before moving a solution into production. This has given Micron 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.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.
Case Study
Digital Transformation of Atlanta Grout & Tile: An IoT Case Study
Atlanta Grout & Tile, a Tile, Stone & Grout restoration company based in Woodstock, Georgia, was facing challenges with its traditional business model. Despite steady growth over the years, the company was falling behind the web revolution and missing out on the opportunity to tap into a new consumer base. They were using independent software from different vendors for each of their department information and workforce management. This resulted in a lot of manual work on excel and the need to export/import data between different systems. This not only increased overhead costs but also slowed down their response to clients. The company also had to prepare numerous reports manually and lacked access to customer trends for effective business decision-making.
Case Study
Revolutionizing Construction Equipment Rental: A Case Study on ProsRent and ENO8
ProsRent, a startup that won the 'Best Financial Opportunity' and 'Best Pitch' at CodeLaunch 2016, aimed to revolutionize the way construction professionals source and rent heavy equipment. In the construction industry, project managers and contractors typically rent heavy equipment from supply companies. However, predicting inventory can be challenging, and finding the required equipment at the right time and place can be a hassle. If the preferred vendor doesn't have the required equipment, it results in wasted time and money in searching for it, often leading to higher costs due to non-preferred rates and increased delivery costs if the vendor is located far from the job site. Suppliers, on the other hand, desired access to a wider base of trusted renters that they didn't have to vet themselves and wanted to offer dynamic rental pricing based on demand and availability in their market. ProsRent's challenge was to produce a minimum viable product that was fast and first to market but also strong enough to engender loyalty and repeat business from the target market.
Case Study
IoT Solution Enhances Comfort and Energy Efficiency at Apple Valley Commons Office
Apple Valley Commons, a mixed-use office complex built in 1986, was facing significant comfort and energy efficiency challenges. The building, which houses a variety of businesses, was experiencing extreme temperature imbalances, causing discomfort to employees and clients. Despite outdoor temperatures being consistently high during summers, occupants had to use space heaters to keep warm. The electricity bills from the constant operation of the heat pump were exorbitant. The building's elevator room on the roof was also overheating, reaching temperatures of 130 to 140 degrees, causing the elevator equipment to shut down. The building's existing controls solution did not provide a front end for diagnostics or remote control. The building management was seeking a solution that could address these temperature issues, improve occupant comfort, reduce operational costs, and increase building visibility.
Case Study
Revamping EE's Legacy ERP: A Case Study on BT's Strategic Transformation
EE, even after its merger with BT, was operating its ERP estate on legacy infrastructure, hosted on the premises of a third-party supplier. This outdated system resulted in a volume-based operational model, higher time to market, longer delivery cycles, and unsatisfactory customer experience. BT recognized the need for a strategic transformation of these aging ERP systems and sought a partner who could proactively manage application services. The partner was also expected to handle development requirements associated with application management services, drive accountability, and ownership with a time and target-driven transformation of these services. BT's primary goals were to improve customer experience, reduce cycle time, and measure these improvements with precision.
