Analytics use cases

A list of interesting analytics use cases

Precision sales
Drivetime optimisation
Embark trucks
Snowflake Disney plus
Coopers brewery Tableau
Brook Weing Machine learning
Finra regulatory
Dollar shave club

Databricks Europe data and AI summit Productionising machine learning models

Data and AI summit 2020- Productionizing Real-time Serving With MLflow

Notes for continuous delivering and deployment

Simple classification model

Cov19 and the importance of Spatial analytics with Alteryx

There has never been an event like COV19 that has impacted so many people, companies and organisations round the world.

Revenue and operational efficiency impacts

COV19 has impacted many companies from a revenue perspective as customers held off purchases and only spent money on food and essentials. In addition, COV19 has desrupted supply chains and operations for many companies.

Enterprise Agility enabled with analytics

The ability for companies to be agile and responsive during COV19 is critical for profitability as more people work from home and customers’ buying patterns have become increasingly localised.

Understanding  customers’ purchase preferences across all channels has never been more important as companies need to rapidly adapt to service their customers new needs.

Spatial analytics key to financial analysis and profitability

Take me for example, I do my grocery shopping from my neighbourhood Woolworths supermarket less than 2km from where I live. While picking up my groceries, I often also pick up a bottle of wine and some beer from my nearest BWS (Bottleshop) compared to pre-COV19 where I would have travelled to the city to drink at a pub with some friends.

To illustrate this, I have used Alteryx and Tableau

  1. Alteryx to scrape data from Woolworths URLhere –
  2. Alteryx to parse JSON into a yxdb
  3. Alteryx to calculate nearest BWS (alcohol) shop from Woolworths store
  4. Visualise grocery and Alcohol bottleshops here.

Alteryx to scrape data from Woolworths URL:


Alteryx to parse JSON into yxdb and then calculate distance from nearest shop


Visualise in Tableau nearest bottle shop from my neighbourhood supermarket


Previously my shopping habits include picking up groceries while taking the train on my way home but now I drive to work and order groceries online.

Using Alteryx,  companies can easily see the changes in buying patterns of their customers at a street level using trade area analysis and so optimise their operations for a rapidly changing world.

Identification of high risk COV19 areas in Australia

The Australian government provides public available COV19 data however unfortunately it is all in different format. NSW provides daily cases by postcode while other states like WA and TAS only provide detail at LGA zone.

With Alteryx, any analyst can combine data from multiple areas at different granularity into a cohesive dashboard to see the impact of COV19 on people and risk areas.

COV19 workflow1


My workflow is here

Spatial analytics fun

So for those of you new to spatial analytics, remember to check out Alteryx and learn from the weekly challenges here.

I highly recommend the following challenges

  • Challenge #6 Spatial Route
  • Challenge #27 Spatial Telco Coverage Smoothing
  • Challenge #48 Calculating Distribution Priority
  • Challenge #77 Extending Spatial Lines
  • Challenge #184 Closest Pubs to Tobacco Dock
  • Challenge #149 Market Overlap



Highlights from Snowflake partner summit Sydney 2019

I had the opportunity to attend Snowflake partner summit in Oct 2019 and there were heaps of learnings.

Australia is embracing Snowflake as a cloud database and it’s great to see consulting partners help land the technology into corporates. A tribute for the various partners as nearly 50% of business is through partners.

Companies adopting snowflake

Altius consulting

  • origin energy
  • Domain

Servian ( Brisbane)

  • Qantas

Inter works( Perth)

  • Fortscue metal


  • NIB
  • HCF


  • RMS

Trends in analytics market

  • Data migration is ongoing exercise and it is getting closer and closer to core systems.
  • Trend towards augmenting SAP for data warehousing
  • Customers start slowly but jump quickly once POCs are successful – mass migration SAP, Terafata, Netezza
  • Snowflake increasingly being used for data science workloads, predictive. Sweetly ( India) using for food delivery
  • Exponential take up for data science.
  • It is often transformative once data is in 1 place.
  • A shift toward moving towards marketing specific use case and patterns in vertical
  • Snowflake handles nearly 300m queries per day. They are evolving into a data platform.
  • 9 out of 10 conversations about migration.
  • Role based dynamic data masking in next 3-6 months ( admin, user). Start with column then move to row, targeting for Jun2020
  • Opportunity to Sell through multi cloud as a starting point. Bringing flexibility to enterprises.
  • Most organisations still struggling with bringing data together

Snowflake product roadmap

Photos part iii

Alteryx Inspire 2019 – Part I

I was excited and happy to attend Alteryx Inspire 2019 and wanted to share and reflect on the experience.

What a blast it has been with Dean opening the keynote followed by the many iconic customers like Coca Cola, CBRE and Horizon power and more shared their journeys.

It is incredible to see the amount of energy and excitement in over 4500 customers , partners and delegates in the room.

Analytics is most definitely a social experience and not just limited to the data scientist.

Users of all levels have the opportunity to upskill themselves from simple to complex use cases with the Alteryx platform

Fantastic new features like assisted modelling and maturing of enterprise platform

It is always amazing to see and hear customers stories and their personal journeys reflected on stage, presenting a huge learning opportunity.

Alteryx is becoming key to digital transformation in so many new and iconic brands.

I attended the session with Alan Jacobson who is Alteryx new chief data officer and shared with us some of the tips on how to leverage data science and analytics in the most effective way.

Interestingly he was one of the global directors for data science and analytics and shared some of the successes and gotchas during the journey. I will be posting a video of this session shortly as there is tremendous value and insight.

Open and embracing culture – sharing of ideas across industries sectors and customers. As the world is becoming increasingly flat, it is important to adopt ideas from other fellow customers and implement in your industry. In today’s world it is no longer about the big eating the small, rather it is the fast eating the slow.

Honkey tong – ACEs going down town!it’s not just all work and no play! The guys and gals attending the event also spent the night partying at broadway !

Alteryx is becoming a tool of choice for Finance users.

I attended the presentation by finance professionals at Honeywell and it was great to see the adoption by finance professionals driving efficiency by automating month end processes , improving financial forecasts using ARIMA and other techniques. To top it off they started their Alteryx journey with just 1 spare laptop! There is no longer any excuse to not leverage automation to enable finance leaders to focus on insights rather than just cranking the month end handle.

We also heard stories of customers young and old embracing the platform. There was an elderly Gentlemen who literally postponed his retirement after he learnt about the Alteryx platform as he started to enjoy his job again and gained lots of satisfaction.

Continued focus on Alteryx community

Alteryx as a company also has a deep focus on the community and this includes customers as well as Alteryx ACEs. Together the community forms a platform that embraces new users to the platform as well as upskill existing customers on how to get value out of the platform by enhancing their skills into higher value analytics like spatial and predictive.

It’s amazing to see how 4500 people can be in 1 location and even just walking from the entrance to our seats you can see how it has grown.

It was great to see Libby recognise all the users and people in the audience both young and old who had used the product, lead user groups as well as contributed to the shared success of the platform.

One of the most compelling stories was that of a older gentlemen who wanted to retire but after his company brought alteryx in found a renewed passion for his job and decided to stay in the workforce longer.

Pink hat power!!

Great to see everyone having an absolute blast! Perhaps I need to consider getting a pink hat too for the next Alteryx conference!

Journey from the accountant to the data scientist – An interview with Nicole Johnson, Senior consultant T mobile


I am always inspired by fellow Alteryx users and embarked on my journey to interview and learn from fellow Alteryx customers.

Here is my interview with Nicole Johnson, Senior consultant T-Mobile, Alteryx ACE and Winner of Alteryx grand prix 2018.

The journey from the accountant to the data scientist

  • Degree in Accounting & finance, worked in construction for 12 years
  • Explored the world of data with VBA, SQL. Came across Alteryx which opened many doors and opportunities.

Driving an accounting revolution at T-mobile with Alteryx – identifying which processes which can be automated in the accounting area. Examples of this include: Reconciliation, detailed data for journal entries, monthly reporting.

Alteryx gives accountants the power to combine and get the data themselves from multiple areas driving efficiency in month end processes. Examples of this include:

  • Using Alteryx to building a framework for US GAAP and run business rules to ensure accuracy for international reporting.
  • External reporting – both US GAAP and IFRS – Extraction and combining data from Legacy systems- Getting data and make in accordance with external accounting standards.

Passion – Fell in love with the Alteryx product and kept learning and teaching others how to use Alteryx to deliver results in the business.

Future focus will include:

  • Leveraging predictive analytics in new projects.
  • Evangelising Alteryx to other areas of the business beyond the finance department

Come join me at the Alteryx Inspire Sydney conference on 20th March to hear and learn from fellow customers.

#cpaaustralia #alteryx