Make Your Data FLow – Alteryx IT!


This is a part 1 of many blog posts coming up on Alteryx workflows, weekly challenges and walk-through – as I learn it. Beginning with a brief overview of Alteryx and it’s use cases, I will conclude with a workflow walk-through.

After spending enough time on data visualization tools and mediums like Tableau, RShiny, Dash and PowerBI I found an ardent need to explore ways through which I could connect only relevant data to my visualization media. Through my internship I came to terms with the fact that data can be voluminous and way more messier than you can imagine.

With data lakes storing large volume of data dumps the process of value creation from this resource begins with creation of defined pipelines to analyze that data – a process some call the Extract Transform Load (ETL) process.

I could go out on a limb and call myself an Alteryx fanboy – I have reasons though.

Continue reading Make Your Data FLow – Alteryx IT!


Discovery Dashboard

Workout Wednesday – Archive

In pursuit of digging deeper into the world of data visualization I follow a simple self devised philosophy – Proficiency on any tool is a result of one’s technical know-how coupled with hands on experience with the tool.

To that end I’ve started following Workout Wednesday. Just like Makeover Monday this is yet another platform to squeeze out Tableau functionalities that facilitate a sophisticated and comprehensive solution to modern day data centric business problems.

In contrast to Makeover Monday – this exercise tests your experience with tableau instead of focussing on the visual cues. I have been following Tableau Zen Masters to pick pointers that help me solve these weekly vizzes. To get my hands dirty I began with visualizations from Workout Wednesday archives.

Lets get to the visualization. Requirements:

  • Dashboard size: 1100 x 900; 4 sheets tiled
  • Create a scatterplot of Sales vs. Profit with Segment on color
  • Create BAN of total marks, total sales, total profit
    • Include supporting information (min, max, slicing information)
  • Create controls that allow the user to
    • Change how the data is sliced (scattered)
    • Separate out segments to different rows
    • Separate out years to different columns
    • Add or remove reference lines
  • Match titles of each axis
  • Match tooltips
  • BANs should respond to selection inside of the scatterplot
  • Don’t forget the color legend & line formatting!

The data for this exercise can be downloaded from here.

This has been the toughest Tableau Viz challenge for me so far. This literally was brain wrecking!

Click here to view the visualization on Tableau Public – Recommended

This dashboard focusses on condensing important KPI’s into ‘Discovery Dashboard’ of sorts. It can help end users/clients get an insight into the performance and trend or seasonality of a company’s data.

Onwards to exploring and creating solutions with DATA!