| Greetings!
We would like to share with you some exciting news of how we have jump started the new year. Details below about our new partnership, a new employee, results of a speaking engagement and data managmenet tips & tricks.
We wish you a healthy and prosperous 2010.
Sincerely,
Efficiency Engineers |
 |
New LVEDC Partnership |
 We would like to officially announce our partnership with the Lehigh Valley Economic Development Corporation. As of January 2010, Efficiency Engineers have become investors.
We are aligning ourselves with the LVEDC to help the Lehigh Valley grow and prosper. Our engineers have the skills and tools businesses need to adopt the latest technologies in order to streamline processes. Whether businesses are relocating or expanding, our experts manage the transition process to meet deadlines within budget and on-time. |
|
Impacts of the Bioterrorism Act |
Michele Stuart, President of Efficiency Engineers, spoke about the impact of the Bioterrorism Act with Jake Greth, Production Manager of Sealstrip Corporation at the January 12th CSCMP Roundtable. They discussed the consequences of not having full traceability through supply chains. It was quite an eye opening experience for many. |
|
Welcome Mike Stabinski |
Please help us welcome Senior Industrial Engineer, Mike Stabinski, to the Efficiency Engineers' team.
Mike brings 10 years experience of industrial engineering in the pharmaceutical, electronics assembly and textile industries. He holds an M.S. in Engineering Management, Project Management Graduate Certificate and a Lean Six Sigma Black Belt.
|
|
January Efficiency Tips & Tricks |
Basics of Data Management
1. Eliminate repeating data - this is the same data stored in separate columns of a table. For instance, fields named Item1, Item2, Item3, etc. This makes retrieving data much more difficult and is just plain unnecessary now that relational database structures have replaced flat-file processing.
2. Avoid redundant data - don't store the same piece of information in multiple places. This could be as obvious as storing an item description in multiple places, or more subtle like storing calculated values like an Invoice Total when that data can and should be calculated from the line items when it is needed.
3. Use consistent formatting - beware of differences in formatted data like phone numbers, zip codes and dates. Inconsistencies can be confusing and affect the sorting and matching of data.
4. Use naming conventions - this helps to make table and field names more predictable and more easily interpreted. Consistency is the key here more so than the actual convention chosen.
5. Be aware of the difference between a null value and a blank value - null should be used for values that are unknown, whereas blank or empty values are for information that is known to be nothing. These values may look the same at a glance, but behave differently in queries and searches.
Become a fan today: visit Efficiency Engineers on Facebook to interactively comment on our Efficiency Tips & Tricks! |
