Data Visualization | Stock Analysis | Tableau

Stock Analysis using Tableau – LOD Function

Being an avid follower of stock markets and thought of creating an area graph of stocks and highlighting the lows and high of the stock for the duration selected something similar to what we see on moneycontrol.com.

My output dashboard here:

Here I will show how to use LOD (Level of Detail) expression in Tableau (More information available here)

Step 1: Downloaded stock price data using getbhavcopy app, which gives an option to extract data of all the stocks at NSE or BSE with their open, close, high, low and volume. I downloaded data from 1st Jan’17 till 22nd Feb’18 data from the app. It looked liked this:

I used command prompt commands to combine all files into one file.

Step 2: Import the data into Tableau and create area graph for the date range and applied company name and actual date as filters. For this example, I applied context filter to actual date field (using add to context filter option in Filters)

Then I created 3 calculated fields to identify High and Low price for selected duration of stock company using LOD expression named Fixed using following Nested Fixed formula:

 

Step 3: Create the worksheet with dual axis as shown below:

 

Then, I integrated the worksheet into dashboard to create output dashboard where user can select any stock with date range user wants to get output with high and lows of that duration.

Thanks!

Do subscribe to my blog to keep receiving updates on new posts

Data Visualization | Tableau

Twitter API & WDC for Tableau

Recently, I had an requirement from my team if we can retrieve twitter data and do some visualization out of it to make some analysis. After going to through several blogs I pounced on blog from TableauJunkie on WDC on twitter and extract the data for analysis. Please look at the below dashboard I created for #TrudeauInIndia from Twitter

Following are the steps:

Step 1: Create your own Twitter API key to return the results

https://apps.twitter.com

once you create your API, twitter will provide access keys which will be used to provide search results.

For Tableau, we will need Web data connector for Twitter. I have used the web data connector shared by Alex ross on this blog Tableau Junkie:

http://tableaujunkie.com/post/119681578798/creating-a-twitter-web-data-connector

one can download the code and set up your own website or localhost to host the connector. There is also an option to modify the number of tweets count one needs.

Step 2: I used XAMP on my machine and pasted the files onto htdocs folder to host the connector on localhost.

Step 3: Start Tableau –> more –> web data connector –> enter the URL where you are hosting the files. Most probably it will be:

http://localhost/TwitterSearch/twitterwebconnect.html

Enter the hashtag or twitter account you want to search

Step 4: Go to Sheet and start creating your data visualization

Hope this will help you in future to generate twitter trends using Tableau

Data Visualization | Tableau

Use Points and Polygon in Tableau – Maps

Today we are going see use of polygon and points in Tableau to create an map showing an geographical details. Tableau has out of the box visualization of geographic regions such as countries, zip code, states and it is pretty much simple by simple drag and drop into sheet with geocoding fields in data source.

Now, what if we need to see customize location in the map or geographical boundaries across across different suburbs or need to see municipal map of particular city with different sub-wards. Tableau for that purpose has polygons which can be used for drawing an particular spot but this required a bit of work before we start using it. This collecting of data with all the points might be time consuming process.

Lets get started with this:

Custom polygon has 2 requirements:

1 – Latitude and longitude coordinates for each point of polygon

2 – An point order in which points are connected with each other

For this dashboard, we will create Mumbai map on basis of municipality wards and I found that data from json file here and converted that into an excel spreadsheet. Once you have data arranged in below format, Tableau will connect the points with the help of longitude and latitude information:

once your data is ready with wards,points, longitude and latitude then import the data into Tableau then do following steps:

  • Place longitude and latitude on rows and columns respectively
  • change mark type to polygon
  • Convert points into dimension then place points column into path under mark
  • Final step is to place ward column into colours under mark

Your polygon map is ready for Mumbai with different Ward with its boundaries as shown below:

Next I did was to get 2011 census data of Mumbai population and create different sheets to create dashboard which shows population, literacy and working class for each ward.

Here is the final dashboard that I designed and published:

Do let me know your feedback or if you have any queries on the same.