When should I stop analysing supermarket data in Excel?

Never?!

Excel remains a great tool for many reporting and analysis purposes – such as building summary reports or conducting a simple ‘what-if’ analysis of two or more scenarios. There are, however, many cases where regular Excel use may not meet all of your needs, including when:

• Your data volume exceeds what you can reasonably handle on your personal computer
• You want to analyse mixed data grain
• You need to combine data from multiple sources
• You want to provide applications to casual users

In these cases, other tools and techniques may offer more powerful, speedy and insightful analysis, including:

• Business Intelligence tools like Looker, PowerBI, Qlik, Tableau, ThoughtSpot, Sigma etc.
• Data platforms like BigQuery, Databricks, Snowflake etc.
• Specialist grocery analysis tools like Elm, Perfect Supplier, SKUtrak, Ultralysis etc.

To explore some of these scenarios, please read our full article here.