This page contains a Flash digital edition of a book.
Scorecard dashboards aggregate technical data to illustrate performance of machines, departments and personnel.


are able to view the same dashboard on their desktops. Atlantic States aggregates techni-


cal data into the digital dashboards to view plant performance via “scorecards.” Each scorecard tells users how the plant is doing for that hour, day and week. The technical engineering team at Atlantic States developed simple SQL programs to query the Enterprise database and used existing production Excel spreadsheets to populate the dash- board components. “Te nice thing about our dash-


boards is that we can drill down,” said Jason Trimmer, plant operations man- ager. “If we want to know the number of plant work orders by department, we can drill down to see the detail of each work order. Our dashboards will show you key data at a glance.” The programs in Enterprise run


automatically on a regular update cycle far in excess of the frequency provided by paperbound alterna- tives, keeping the information in the dashboards current.


Employer and Employee Buy-In


For a successful knowledge manage- ment tool deployment, Atlantic States needed support from leadership and in-house employees with the know-


42 | MODERN CASTING September 2014


how to work with technology and the willingness to spend time on it. Key to Atlantic States’ success was Schmelzle’s ability to create an atmosphere that


empowered staff to produce high value content. Sharing production informa- tion can be a major change in a com- pany’s culture. It is not uncommon for


SETTING UP THE DASHBOARDS


As the IT manager at Atlantic States Cast Iron Pipe, Norman Rankis was the architect of the plant’s knowledge management system. Prior to joining Atlantic States, he had been respon- sible for a case study with Microsoft Corporation on Digital Dashboards that is in the book “Knowledge Manage- ment” published through Microsoft Press by Jerry Honeycutt.


Atlantic States required a webserver running Apache and an SQL Server database back-end server to create and implement its digital dashboards. The plant already had available servers running other applications and had the extra space. Hardware costs were for large monitors to display the digital dashboards and the third party software cost was slightly more than $12,000. Atlantic State’s first dashboard took less than a week to put into production. The IT department uses Rapid Appli- cation design and has delivered new dashboards within two hours. The first step in delivering a


practical knowledge based system is identifying what “vital” signs managers and plant workers need to do their job. Atlantic States uses the Agile method- ology’s Story Book or Story Card tech- nique. The dashboard designer asks managers, “If you were in a hotel on a business trip, what information would you need to see to know how well plant operations are? What information would you need to make good business decisions?”


Once those questions have been answered, the IT department searches the systems to find that data. It then takes the data and puts it into a picture card or dashboard. The programming is not difficult, and a working dashboard can be ready to go into production within hours or days. A dashboard is consid- ered “in production” when it is working in real time and available on iPhones, iPads, laptops, desktops and kiosks. To learn more about dashboards, Rankis suggests review topics about Knowledge Management through Microsoft.


Page 1  |  Page 2  |  Page 3  |  Page 4  |  Page 5  |  Page 6  |  Page 7  |  Page 8  |  Page 9  |  Page 10  |  Page 11  |  Page 12  |  Page 13  |  Page 14  |  Page 15  |  Page 16  |  Page 17  |  Page 18  |  Page 19  |  Page 20  |  Page 21  |  Page 22  |  Page 23  |  Page 24  |  Page 25  |  Page 26  |  Page 27  |  Page 28  |  Page 29  |  Page 30  |  Page 31  |  Page 32  |  Page 33  |  Page 34  |  Page 35  |  Page 36  |  Page 37  |  Page 38  |  Page 39  |  Page 40  |  Page 41  |  Page 42  |  Page 43  |  Page 44  |  Page 45  |  Page 46  |  Page 47  |  Page 48  |  Page 49  |  Page 50  |  Page 51  |  Page 52  |  Page 53  |  Page 54  |  Page 55  |  Page 56  |  Page 57  |  Page 58  |  Page 59  |  Page 60  |  Page 61  |  Page 62  |  Page 63  |  Page 64  |  Page 65  |  Page 66  |  Page 67  |  Page 68  |  Page 69  |  Page 70