Close this search box.
Close this search box.

Data Analytics: The Ugly, But Crucial Step CEOs Can’t Ignore

© AdobeStock
The part of the process that involves cleansing, categorizing and standardizing data lacks the excitement and obvious returns of other investments, but it's the only way to ensure your data collection isn't a waste of time and money.

Today’s C-Suite leaders have high expectations of data. They want to be able to whip out their smartphones and bring up beautiful visualizations of trends that give them actionable insights into the business at a granular level.

That’s the dream anyway. In reality, many businesses are failing to get the most out of their data even though they’re collecting a lot of it.

What’s usually missing is the part in the middle that connects the raw data with those fancy presentations. It’s an ugly part of the process that involves cleansing, categorizing and standardizing data, and one that often flies under the radar because it lacks the excitement and obvious returns of other investments.

But any company that doesn’t take this seriously is missing out on the crucial insights that high quality, relevant data provides, and which increasingly mark the difference between success and failure.

Leaders only need to look around to see that the best CEOs are making data central to their business. This has become even more important as companies grapple with rising costs. Good data analytics allow companies to stay on top of their purchases and to roll costs over to their customers, a capability that is proving highly valuable these days in the manufacturing and automotive industries.

Companies with low data maturity tend to keep data siloed, using different criteria across departments to collect and interpret it. This leads to missed opportunities from not integrating data to generate information at a granular level. They may know if they just had a good month but are not able to see how that breaks down on a per-item level or how it compares to other periods to give them a better understanding of “why” they had a good month and how they might be able to proactively make decisions to repeat or even further improve results.

One manufacturing firm we know recently employed analytics to clean up its data and for the first time obtain a SKU-level visualization of the profitability of each item it sold. This enabled it to cut items that were performing poorly and improve its bottom line substantially.

The best data results come from a combination of solid leadership, investing in the right technology, and incentivizing the right people to make it all work. It sounds simple, but following these key principles are critical to success.

• Good data management starts at the top. Company leaders first need to define how they measure success—whether that is sales growth, SKU-level costs savings, profitability or any other metric—before considering how to harness data to support their goals. One of the most common, and frustrating, missteps that leaders make on technology is spending big on all-encompassing ERP systems and expecting that to solve their data problem. While these systems may have a data management component, they are not built specifically for that task.

• Purchase dedicated analytics software. The two pillars of a good data technology stack are governance tools, such as Alteryx or Informatica, and visualization tools such as Tableau or Power BI, to name a few. They are affordable and allow organizations to build up capabilities and expertise. Data governance tools enable companies to validate their data, catalog it and ensure that is cleansed and reliable before it gets piped into other software. Visualization tools then present that data in a way that is both granular and broad on key business trends, giving executives the insights they crave.

• Investing in the right people. Senior data specialists should be incentivized for good performance, with rewards triggered when their analytics work leads to company success. They should be involved in all decision-making processes and provide regular updates to leaders, becoming true stakeholders. Investing in people like this is never cheap and can meet resistance. But the expense becomes much easier to stomach if you run an opportunity-cost analysis to understand how much is being lost through bad data practices.

Having strong data systems and SKU-level rationalizations in place make businesses more efficient. But companies also need to remember the crucial human element by investing in IT and data leaders—and making sure they are truly valued.

When it all comes together, there’s nothing like seeing a CEO or CFO light up the first time they open a revamped data dashboard on their screen.  But getting to that point doesn’t happen overnight. If you haven’t started on that journey, you’re already behind most companies, but there is still time to catch up.


  • Get the CEO Briefing

    Sign up today to get weekly access to the latest issues affecting CEOs in every industry
  • upcoming events


    Strategic Planning Workshop

    1:00 - 5:00 pm

    Over 70% of Executives Surveyed Agree: Many Strategic Planning Efforts Lack Systematic Approach Tips for Enhancing Your Strategic Planning Process

    Executives expressed frustration with their current strategic planning process. Issues include:

    1. Lack of systematic approach (70%)
    2. Laundry lists without prioritization (68%)
    3. Decisions based on personalities rather than facts and information (65%)


    Steve Rutan and Denise Harrison have put together an afternoon workshop that will provide the tools you need to address these concerns.  They have worked with hundreds of executives to develop a systematic approach that will enable your team to make better decisions during strategic planning.  Steve and Denise will walk you through exercises for prioritizing your lists and steps that will reset and reinvigorate your process.  This will be a hands-on workshop that will enable you to think about your business as you use the tools that are being presented.  If you are ready for a Strategic Planning tune-up, select this workshop in your registration form.  The additional fee of $695 will be added to your total.

    To sign up, select this option in your registration form. Additional fee of $695 will be added to your total.

    New York, NY: ​​​Chief Executive's Corporate Citizenship Awards 2017

    Women in Leadership Seminar and Peer Discussion

    2:00 - 5:00 pm

    Female leaders face the same issues all leaders do, but they often face additional challenges too. In this peer session, we will facilitate a discussion of best practices and how to overcome common barriers to help women leaders be more effective within and outside their organizations. 

    Limited space available.

    To sign up, select this option in your registration form. Additional fee of $495 will be added to your total.

    Golf Outing

    10:30 - 5:00 pm
    General’s Retreat at Hermitage Golf Course
    Sponsored by UBS

    General’s Retreat, built in 1986 with architect Gary Roger Baird, has been voted the “Best Golf Course in Nashville” and is a “must play” when visiting the Nashville, Tennessee area. With the beautiful setting along the Cumberland River, golfers of all capabilities will thoroughly enjoy the golf, scenery and hospitality.

    The golf outing fee includes transportation to and from the hotel, greens/cart fees, use of practice facilities, and boxed lunch. The bus will leave the hotel at 10:30 am for a noon shotgun start and return to the hotel after the cocktail reception following the completion of the round.

    To sign up, select this option in your registration form. Additional fee of $295 will be added to your total.