The Aim of this blog:
The aim of this blog is to showcase what I have achieved on the Third day of the dashboard week.
What did I build:
The dashboard I build is designed to find the Cryptocurrency that is the talk of the town.
It is aimed to help people who knows nothing about Cryptocurrency to quickly find one that’s the most popular and least likely to be come obsolete.
The data set that we used for day 3 of dashboard week is comes from the Coinpaprika API.
To prepare the data for virtualization.
Firstly, I built an Alteryx Batch Macro to query multiple times from Coinpaprika using it’s API automatically.
Then, I parse and cross tab all the columns to generate the data set I will be using for visualization.
https://public.tableau.com/views/Coinpaprika-CryptocurrencyAPI/WhichCryptocurrencyShouldIInvestigate?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link
The Batch Macro:
The screen shot above is the batch macro I build.
Firstly, it takes the Cryptocurrency ID as an input then build the URL for Coinpaprika API.
The URL is then passed to the Alteryx Download tool to query from the Coinpaprika website.
Lastly it is parsed using the Jason parsing Tool.
The resulting data set is then further processed before been outputted.
Data Cleaning:
The screen shot above is my Alteryx Workflow, it’s rather straight forward.
I started from Importing the output of my batch macros
Then I find the columns that I need, used Regex Tool to get parts of the information that I need.
Lastly, I used the Cross Tab Tool to create the actual data set I will be using for virtualization.
Once I Cross Tabbed the data set, it’s simply a matter of outputting the result.
However, one thing I would like to mention, is the Sentiment Analysis tool.
It is find in the Text Mining Pallet, which comes with Alteryx Intelligence Suit Licenses.
The purpose of the Sentiment Analysis tool is to determine how positive or negative the text responses or comments are.
I decided to use it to find the Sentiment within the Tweets people have written about Cryptocurrency and to identify the ones with most number of positive tweets.
Conclusion:
There you have it.
A simple dashboard to find the most talked about Cryptocurrency.
