234 BUILDING A PRODUCTION MONITORING DASHBOARD 3.2.1.2 Monitoring Production Raul Ichine, VP of Operations, has identified a significant concern regarding his ability for oversight of multiple production locations. Mr. Ichine fears he will no longer have a consistent overview of production operations as he cannot be at two different sites at the same time and is seeking a meaningful solution. In order to support Mr. Ichine in the execution of his responsibilities, Research & Development Analyst Billy Bob has been tasked with drafting a dashboard design that will address Mr. Ichine's concerns: 0 CBR has identified a few areas of focus that need to be addressed and monitored through the construction of a Business Intelligence (BI) visualization system that CBR has named Control Awareness Reporting Engine, or CARE: B2C Sales and production levels Logistics and Shipping Forecasting and Analytics Through elicitation efforts with Mr. Raul Ichine, the following items have been identified as primary concerns: o Looking to measure daily production rates, seeing 30-days of production at any time. o Month-to-month comparison of production with trend lines o Tracking of inventory levels and sales rate to ensure only in-demand products are restocked Secondary: CBR Executive team Wants to see sale projections and forecasts Wants to see OPEX as a live metric Sources of Data: Each production employee will be required to manually log their activities through Excel on Microsoft Office 365. This process will occur every time a 'batch' order has been completed. Sales data is automated by the eCommerce system, which will automatically record all sales records to a SQL Server Database. The TPS backend will seamlessly update the Sales Database as needed and will not require any direct interaction from any employee. All data files accessed by CARE are located centrally on the organization's SharePoint Data Server which is a separate system from Microsoft's Office 365 Server system. All data will be stored on the SharePoint Data Server, and all Managers will utilize an application called Microsoft Teams available from the Office 365 Server to access Production Logs and Sales Records. Excel (available on the Microsoft Office 365 Server system) is used to open the spreadsheets. Managers will have access to productivity output records per employee, through Microsoft Teams, and will maintain the following rights: Add new data records Update, modify and append existing data (time logged) Delete records (logged) Share Excel spreadsheet access with authorized personnel 235