Colin was proactive in researching and incorporating best practice data visualisation techniques and applying them to his dashboard designs.  He was keen to engage with business stakeholders, communicating the art of the possible and listening to their feedback.  Furthermore he was diligent in documenting any technical issues encountered in visualising the client’s data.  This approach ensured that the client’s business intelligence requirements were captured and key lessons were learnt to inform the rollout of a future business intelligence function.

Jason Foster

CEO and Founder, Cynozure

Situation:

Working at Cynozure, an industry leading data and analytics consultancy, Datawoj supported a global manufacturing corporation with a proof of concept using Tableau Desktop to show what is possible in terms of data visualisation.

Task:

To prove the value of management information dashboards built within a data visualisation platform such as Tableau. This would secure buy-in from the senior management team to invest in dash-boarding capabilities as well as inform the strategic direction for a future business intelligence function.  In particular there was a need to:

  • Validate the connection of Tableau to the existing cube based data architecture
  • Actively engage with business users to understand their business intelligence requirements
  • Investigate the ease and speed of use to produce different views of sales data, translated into information and insight

Actions:

Test data visualisations were produced in Tableau Desktop of a daily sales dashboard using the existing data architecture.  Throughout an issues log was maintained to outline any technical hurdles discovered through visualising data from the existing data architecture as well as potential solutions to overcome them.

There was engagement with operational and strategic business users to provide initial illustrations, gather feedback and document requirements.  This informed the development of a senior executive level sales dashboard with interactive drill-down capabilities across brand, customer and product, comparing actual to forecast sales.

Created a sales and quantity dashboard, allowing drill down from brand to show the level of discount across individual product lines.  The ease and speed of building the dashboard was tested and demonstrated back to senior stakeholders.

Results:

There was a proof of concept that daily sales data could be visualized using a business intelligence tool like Tableau. The issues log has informed the technical requirements for configuring the existing data architecture to maximise the performance of sales dashboards produced in Tableau Desktop.

Stakeholder engagement feedback will inform the business user requirements for a future business intelligence function going forward.  In particular this will inform the development of a business intelligence tool selection process.

The sales and quantity dashboard demonstrated the value of a ‘drag and drop’ to discover key insights quickly and easily.  This visual analytics approach would help answer critical business questions such as which products were offering high discounts within each brand.