Will the Hearts Go on?

How many of us went to see Titanic when it came out in 1997? As for me, I instantly fell in love with its characters, the story-line and of course, the theme song the first time I watched the movie.

Before long, everyone was talking about how handsome Leonardo DiCaprio was or how adorable Kate Winslet was and the like. Even a handful of my guy friends started wearing DiCaprio hairstyle. I admit I started having a crush on the actress as well. This was happening in Burma, a country that recently had just opened up to the outside world!

Putting the sentiments aside, it was a tragic event that took away many lives, families ruined and loved ones lost. In the end, the victims just became statistics for testing various predictive models using the Titanic data set.

I am no data scientist (a statistician who lives in San Francisco? 😁) myself but just someone who loves to visualize anything with whatever I can get my hands on, so here it goes. Using Tableau software, I am sharing how to create the Sankey diagram analyzing survivors and victims based on ports of embarkation. Link to the input file is included in the video description.

Data is beautiful.

Link to video:

 

Good luck and Best Regards,

Jaiwa Wunpawng

Game Night and Chill?

During my university years, it was a favorite pastime for both boys and girls, especially on weekends. The most popular games were Uno, Apples to Apples, Snakes and Ladders and Monopoly just to name a few.

But may would spend hours playing popular console/video games such as Call of Duty, Guitar Hero or Super Mario on Xbox, Sony PlayStation or Nintendo. Some preferred playing PC games.

That was several years ago and back then I didn’t know many people who were playing mobile games. So, what has changed over the years for people playing games on one of these platforms: Console, PC and Mobile?

Well, data don’t lie. In below Tableau tutorial, I will show you the historical trend and forecast for the three gaming platforms using two different charts.

Data is beautiful.

 

Here is the link to the tutorial:

 

Good luck and Best Regards,

Jaiwa Wunpawng

Wealthier Countries: Smaller Families and Higher Life Expectancy

Do citizens of wealthier nations live happier lives compared to those living in poor countries? I don’t think I am qualified to answer this question since happiness is defined differently by various cultures.

But one thing I can tell you is that by looking at the data made available to public by the United Nations, we can see families in rich countries tend to be smaller and their life expectancy is much higher.

While anyone curious enough can download the data and observe/compare the trends using Excel or other tools, I have opted for Tableau to create an animated chart combining multiple data sets. In the below tutorial, I am showing you how you can compare fertility rates and life expectancy at birth for over 200 countries dividing them into multiple regions.

You can also single out countries of interest to analyze the trends across several decades. The input Excel files can be downloaded using the link provided in video description.

 

Data is beautiful.

Here is the link to the tutorial:

 

Good luck and Best Regards,

Jaiwa Wunpawng

Creating a QoQ Sales Analysis Dashboard in Tableau

What if you own a business/are working for someone and there is a need to quickly analyze sales and profit trends over the years by regions, segments, products, etc? How do you find out if current quarter sales/profits are getting better/worse compared to historical performance? What do you do to isolate and identify under-performing/unprofitable products?

These are just a few crucial questions business owners and managers alike want answered on a daily basis. While there are many available tools in the market that can perform such analyses, Tableau stands out when it comes to answering such questions at the speed of thought.

“Rubbish! Go tell it to the marines!” Some of you might want to yell at me.

Well, I am not here to argue or tell tall tales but show you how you can create a dynamic dashboard in Tableau to answer such questions in the blink of an eye. Yes, it takes a while to build the dashboard from scratch but once it is done and automated, it is just a matter of refreshing/updating the input data to reflect the latest results.

Data is beautiful.

Here is the link to the tutorial:

The input file used in the tutorial can be found in the video description.

Good luck and Best Regards,

Jaiwa Wunpawng

Data Visualization with Tableau Public

In this digital age, companies big and small and various other organizations have been accumulating gargantuan amounts of data. Data is also believed to be worth more than oil, which translates to boundless business opportunities and a vast array of job openings for those who are in the business of data. Knowing how to analyze and make sense of this giant stack of data to draw meaningful insights has never been more crucial for business/career success.

Data visualization, a major component of business intelligence, is one of the data analytics fields one can pursue. In below tutorial using Tableau Public software, I will walk you through the basic steps to create a sales interactive dashboard. The input Excel file can also be downloaded using the link provided in video description.

Data is beautiful.

Link to the Youtube tutorial:

 

Good luck and Best Regards,

Jaiwa Wunpawng