How an organisation can transform to embrace data?

I kind of have the feeling that many companies are not ready for generating intelligence out of data.

The former company I work on talks a lot about digital transformation and data but many data collects are still stored in excels. And different people create slightly different excels. This is one of the challenges in embracing data: unstructured data.

Do you have any idea about other challenges? And your suggestions on how to tackle them?