2. What was the limitation of Excel-based data analytics at Safeway? The limitation of the Excel based data analytics is a spreadsheet, with rows and columns. This spread sheet limited the amount of information that was represented in the company’s report. The …show more content…
What steps did Safeway and PepsiCo undertake to arrive at their data visualization solution? Safeway and PepsiCo collaborated to figure out how to limit the “number of days of supply”. The steps that were undertake included, how to feed the huge datasets into the visualization software, the best way to display the data visually and how to gather feedback (Turban & Volonino & Wood, 2015, pg 370).
5. What did Safeway learn from its data visualization dashboards? Safeway learned that several stores were experiencing an unequal number of stockouts and they were able to regulate their supply chain strategy in an attempt to even the demand. They also learned that they were sending contradictory prediction to their vendors (Turban & Volonino & Wood, 2015, pg 371).
6. What were the two operational improvements at Safeway? The two operational improvements at Safeway were the improved forecast accuracy by 35 percent, and the reduced on-hand warehouse inventory (Turban & Volonino & Wood, 2015, pg