Digital transformation is a company-wide process but C-suite leaders, particularly the CEO, have a critical role to play in its adoption being a success