Welcome to LeanExecution!

Welcome! If you are a first time visitor interested in getting started with Overall Equipment Effectiveness (OEE), click here to access our very first post “OEE – Overall Equipment Effectiveness“.

We have presented many articles featuring OEE (Overall Equipment Effectiveness), Lean Thinking, and related topics.  Our latest posts appear immediately following this welcome message.  You can also use the sidebar widgets to select from our top posts or posts by category.

Free Downloads

All downloads mentioned in our articles and feature posts are available from the FREE Downloads page and from the orange “FREE Downloads” box on the sidebar.  You are free to use and modify these files as required for your application.  We trust that our free templates will serve their intended purpose and be of value to your operation.

Visit our EXCEL Page for immediate access to websites offering answers and solutions for a wide variety of questions and problems.  Click here to access the top ranking Excel Dashboards.  Convert your raw data into intelligent data to drive intelligent metrics that will help you to analyze and manage your business effectively.

Questions, Comments, Future Topics

Your comments and suggestions are appreciated.  Feel free to leave a comment or send us your feedback by e-mail to LeanExecution@gmail.com or VergenceAnalytics@gmail.com.  We respect your privacy and will not distribute, sell, or share your contact information to any third parties.  What you send to us stays with us.

Subscribe to our blog and receive notifications of our latest posts and updates.  Simply complete the e-mail subscription in the sidebar.  Thank you for visiting.

Until Next Time – STAY lean!

Vergence Analytics

Camtasia 9 – Screen Recording and Video Editing

I upgraded to TechSmith’s Camtasia version 9 today and note some very nice improvements that make producing videos with Camtasia so much faster and easier.  Recording, editing, and creating your video is a simple process, even for novice users.  You can save or share your videos by uploading them to Screencast.com, Vimeo, YouTube, Facebook, and more.

camtasia-9-installed

It is so much easier and more effective to create a quick video to demonstrate how to perform a task than it is to describe it in writing.  I couldn’t imagine having to write instructions explaining how to tie shoe laces especially when we consider that our student probably can’t read or write yet!

In this same regard, a video makes for a better coach than a set of written instructions and videos often capture unanticipated experiences or nuances in the process that you may fail to note in your written narrative.

Editing videos doesn’t get any easier or more versatile than with Camtasia.  Simply drag & drop features and effects into Camtasia’s multi-track timeline to place them precisely where you want them.  All of the video editing technologies you need are available using simple mouse clicks.

The tutorials for using Camtasia are professional, easy to follow, and explain how to use each of the features available.  The added benefit of course is to see how powerful videos can be for providing helpful instructions for teaching or using a new software product!

Camtasia can also be integrated into your Microsoft Office applications (Excel and PowerPoint).  Apps are available for both PC and Apple products.

TechSmith Fuse:  Flexibility and versatility are possible when you install this add on that can capture content where ever you are.  Adding content to Camtasia, SnagIt, or TechSmith Relay is simple as you can see from the picture below:

techsmith-fuse

If you’re looking for a screen capture recording and editing package for your computer, Camtasia by TechSmith is worthy of your consideration and the price is very affordable.

For an additional nominal fee, you can purchase a maintenance agreement that will ensure you receive the latest updates free of charge during the subscription period.

What does this have to do with lean?  Written instructions are great and often necessary.  However, there are times when videos are much better suited to explain a given concept or task and usually require less time to view than reading and understanding an equivalent set of written instructions.

If a picture is worth a thousand words, a video is at least that many and more.

Until Next Time – STAY lean!

Versalytics

 

Advertisements

Pro SQL Server Relational Database Design and Implementation

My copy of the book “ProSQL Server Relational Database Design and Implementation , 5th Edition” by Louis Davidson with Jessica Moss arrived this week.  I’m excited to work my way through it.

A well designed database will significantly increase the performance of your database and greatly improve your ability to write efficient and effective SQL queries.  From a lean perspective, an effective database design is equivalent to “quality at the source”.  Your ability to work with your data is inextricably intertwined with the design of the database itself.

Improving a car’s performance begins with the very engine that drives it.  The same is true for your database.  At 14 chapters and 791 pages, the content of the book is thorough and logical, covering the latest features and enhancements to SQL Server 2016.

Although many developers are inclined to control database activities from the client side “front end”, greater performance can be achieved on the server side.  SQL Server 2016 is a powerful relational database management system where the greatest benefits are reaped by implementing a well designed relational database.

For more information or to purchase your copy, just click on the link below!

Pro SQL Server Relational Database Design and Implementation – Fifth Edition – Louis Davidson with Jessica Moss, Apress

OEE in Isolation

OEE or Overall Equipment Effectiveness continues to pervade the world of manufacturing as evidenced by the number of OEE templates that are downloaded each and every day from our downloads page.  In this regard, it is interesting to note the number of OEE solutions that operate in complete isolation.

A medium to large sized company typically deploys some form of ERP (Enterprise Resource Planning) system to manage almost all facets of day to day operations.  Ideally, an integrated OEE solution could take advantage of the existing data streams.

The argument against integration is the lack of “granularity” in the current ERP database system.  Some databases simply do not accommodate the detailed reporting of downtime events such as set up, material changes, process faults, or other lost time events.  Another related factor is whether these data elements can be reported in real time.

In reality, the requirements to support OEE data collection were simply not considered in the original database design and, as a result, two independent systems co-exist.  An opportunity exists for software developers to expand the capabilities of their ERP solutions.

At a minimum, it is possible to bridge two or more independent databases to create a single report using a third party software provider such as Crystal Reports.  Unfortunately, true integration requires more than simply generating a report to better manage and improve your enterprise.

This is a topic that warrants further review.  If we’re writing about it, someone is either working on it or has already done it.

Questions, Comments, Future Topics

Your comments and suggestions are appreciated.  Feel free to leave a comment or send us your feedback by e-mail to LeanExecution@gmail.com or VergenceAnalytics@gmail.com.  We respect your privacy and will not distribute, sell, or share your contact information to any third parties.  What you send to us stays with us.

Subscribe to our blog and receive notifications of our latest posts and updates.  Simply complete the e-mail subscription in the sidebar.  Thank you for visiting.

Until Next Time – STAY lean!

Versalytics

 

The Problem with Solutions

The value of a solution is a problem not worth repeating.

~Versalytics.org

The 5 Why process is one of the many tools that serve to help us to state a given problem, identify a root cause, and ultimately derive a solution to resolve the concern.

One of the caveats that potentially undermines the effectiveness of the 5 Why process is repeatability.  The probability of arriving at a given solution is as varied as the participants in the 5 Why process itself.

The scope and description of the problem become the framework on which the solution is formed.  The questions that evolve through the 5 WHY process depend on the skills and expertise of the participants.  An effective means of deriving an effective solution is explained in our post “How to use the 5-Why approach.”

The problem with the solutions that evolve from the 5-Why process is the limited scope from which they were derived.  In other words, the application of a given solution is constrained by the very problem it is intended to solve.

We can’t solve problems by using the same kind of thinking we used when we created them.

~ Albert Einstein

The ideal solution will resolve the immediate problem and will also yield broader “best practices” at the system and process levels to prevent recurrence in other/different applications.

The knowledge and lessons learned throughout the problem-solving process should also cascade into the systems, processes, and methods that affect future successes and outcomes.  A problem solved is not repeated.

TRIZ is another creative problem-solving technique used to view problems and solutions from different perspectives.  TIPS, the Theory of Inventive Problem Solving,  is another acronym that may be used to describe TRIZ.  The following websites offer more insight into TRIZ:

The above sites offer insights into TRIZ and how it can influence our thinking to solve problems from new and different perspectives.  Learn more about “Resolving Contradictions” at opensourcetriz.com.

Until Next Time – STAY lean!

Versalytics

 

 

 

 

SQL Queries For Mere Mortals

Databases are capable of storing incredible volumes of data.  However, their true value is found when we learn to mine and manipulate that data.  Structured Query Language or SQL is the language of databases and is common – with some exceptions – to all of the major databases on the market today.

A custom front end is typical of most database solutions where we are immune from having to work with the raw data directly.  Unfortunately, the front end solutions typically provide “prepared” or “canned” reports with limited capabilities to tailor them.

SQL gives you the ability to unlock your data.  Customized queries can provide new insights into your data that would otherwise never be tapped.  Of the many books available to teach you SQL, SQL Queries For Mere Mortals – Third Edition is one of our top recommendations.

SQL Queries For Mere Mortals – Third Edition, John L. Viescas and Michael J. Hernandez.  760 pages.  ISBN-13:  978-0-321-99247-5 / ISBN-10:  0-321-99247-4.  Addison-Wesley

Tap into the power SQL to get the most out of your relational database.  SQL is not a difficult language to learn and you can become dangerously knowledgable in a matter of a few hours or even minutes.  On the other hand, to use it effectively requires more than a basic understanding of a handful of commands.

Learning how to use SQL to it’s greatest advantage begins with a solid foundation in SQL.  This book walks you through the evolution of SQL before commencing with any serious teaching of the language itself.  Numerous examples demonstrate how to use the skills discussed in the text and all of the examples and databases are available for download from the book’s website.  Five unique databases – Sales Orders, Entertainment Agency, School Scheduling, Bowling League, and Recipes – demonstrate the importance of understanding the underlying schema to formulate effective and efficient queries.

//ws-na.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=US&source=ac&ref=tf_til&ad_type=product_link&tracking_id=leanexec-20&marketplace=amazon&region=US&placement=0321992474&asins=0321992474&linkId=35d7f3462188f06e6359519431840253&show_border=true&link_opens_in_new_window=true&price_color=333333&title_color=0066c0&bg_color=ffffff

At 710 pages of chapter content alone, this book is for those who want an in depth guide to learn how to write effective SQL queries.  While the pace of the book may seem a little slow through the first 5 or 6 chapters, you will appreciate the foundation they set for the materials presented in chapter 7 and beyond where joins, unions, and subqueries are presented.  Of particular importance is the initial overview of database design.  You will quickly discover that a well designed database is essential for writing effective and efficient queries.
Become the wizard! SQL – you’ll wonder how you ever did without it.  You’ll also discover that SQL is more common than you may be aware of.

SQL and Excel

Microsoft’s SQL Server is the database solution of choice for our company.  However, like many of the database solutions available, additional data mining tools are required to provide the top level reports needed to manage the business itself.

Not surprisingly, one of those tools is Excel 2016.  The correlation between a database table and a spreadsheet is intuitively clear.  While it is easy to conceive how they may be related, connecting the two may be a daunting experience the first time around.

For someone looking to make a quick connection, we recommend visiting the datapig technologies blog (http://datapigtechnologies.com/blog/).  In a matter of minutes, you can establish a connection to your database and dynamically refresh the data on your spreadsheet.

We have also added a link to the datapig technologies blog from our Excel Websites Page.  We trust that you too will find the information presented to be of value to you and your organization.

Until Next Time, STAY lean!

Versalytics-Logo

 

 

Lean UX – Intriguing

The application of lean  evolved well beyond it’s application in the world of manufacturing.  Certainly, the medical field and hospitals have reaped significant rewards not only to the benefit of their own efficiency and effectiveness but also to the patients who are under their care.

It is a testament to lean practitioners who apply their knowledge of lean to create new paradigms for business and industry around the world.  The book, Lean UX: Applying Lean Principles to Improve User Experience, published by O’REILLY is another example of this.

I have discussed the application of Lean Principles in the context of software development over the past few years and is perhaps one of the reasons that this book caught my attention.  We’ve mentioned many times before that lean principles and practices can be extended to other facets of business beyond the manufacturing floor.  Enhancing or improving the user experience – especially for web applications – is surprisingly specific, yet well developed.

With regard to the design process itself, I can appreciate an iterative design and release process whereby a preliminary release is followed by frequent updates based on user feedback and / or additional features that were reserved for later release cycles.

The release and development of Windows 10 serves as an excellent example of this process.  As a participant in the Windows “Insider Preview Build” Program, I continue to receive the latest Windows 10 builds and provide frequent feedback to Microsoft accordingly.

Lean UX: Applying Lean Principles to Improve User Experience provides an interesting perspective and may just change the way you view web applications in the future.

The KINDLE advantage

Download the free Kindle app to save money and the environment when you purchase the Kindle version of Lean UX: Applying Lean Principles to Improve User Experience.

I have the KINDLE app installed on all of my key devices including my Blackberry, iPhone, iPad, MacBook, and Windows PC’s and a lot of books in my Kindle library. Books are available to you anywhere at anytime as long you have your device with the Kindle app with you.

It’s also easy to move from one device to another without having to remember the last page you read because KINDLE knows the last page read on each device.

Aside from not having try your complete library of books around with you, consider the shelf space you’ll be saving too!

Also consider how easy it is to follow along with an open book on the screen while learning to do something new on your computer.

I highly recommend the Kindle app though I still have a certain appreciation for hardcopy books too.

Until Next Time – STAY lean!

Versalytics (64x64)

 

 

//ws-na.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=US&source=ac&ref=tf_til&ad_type=product_link&tracking_id=leanexec-20&marketplace=amazon&region=US&placement=1449311652&asins=1449311652&linkId=fc56ca5fc8f1b6ab235cbcfa772d3f6d&show_border=true&link_opens_in_new_window=true&price_color=&title_color=&bg_color=FFFFFF