Monday, January 5, 2015

Tableau Correlation and Regression

Trend Lines: A trend line can provide a statistical definition of the relationship between two numerical values


Graph: Profit over Sales. Where profit is a dependent measure based on Sales measure. Each circle represents a Store.
Rt. Click on Trend Lines > Describe Trend Model

Smaller the p-value, the more significant the model and higher the correlation.


Customized Trend Lines:  
Rt. Click trend Line > Edit Trend Lines


Correlation Coefficient:
The correlation coefficient is defined as:

Where ‘n’ measurements of X and Y are written as Xi and Yi (i = 1, 2 .... n) and X Tableau equivalent formula (Link:http://community.tableausoftware.com/thread/111548)

WINDOW_SUM((SUM([Sales])-WINDOW_AVG(SUM([Sales]))) * (SUM([Profit])-WINDOW_AVG(SUM([Profit])))) / SQRT(WINDOW_SUM(SQUARE(SUM([Sales])-WINDOW_AVG(SUM([Sales]))))*WINDOW_SUM(SQUARE(SUM([Profit])-WINDOW_AVG(SUM([Profit])))))

Multi-Regression: Graph below shows the linear regression of Profit over Sales for each of the Regions. Based on the Coefficient of Correlation we can analyse the following:

  • East is highly positively correlated (profit grows as sales grows)
  • West is highly negatively correlated (profit declines as sales grow)
  • Central, South and North are in order of correlation. With least correlation for North


References/Detailed Articles: 

Tuesday, December 16, 2014

My New Love: Tableau as a BI Solution

Let me introduce you to the latest love of my life, Tableau (Link). With my creativity at an all time high, it has met its perfect match in Tableau. This BI and Analytic tool claims to make data beautiful. So true! and its so easy. You could build visualizations, complex trend-charts, box-whisker plots, dual axis graphs, filled Geo-maps. This calls for the attention of the BI community. I agree with Gartner BI products 2014 evaluation. They have placed Tableau as a leader ahead of Cognos, Microstrategy for a good reason (click Link for more on the BI Gartner magic-quadrant).

Without much ado let me share a viz i created with Tableau for fun on dummy retail data.






If you are interested in hiring me to help you out with building awesome BI solutions, please reach out to my email: ojoswi@gmail.com or visit my LinkedIn profile and leave me a message (LinkedIn)

Saturday, November 15, 2014

"The Last Leaf"

This decorative plastic plant in the front yard of my neighbor reminded me of O'Henry's "The Last Leaf". For those of you who do not know who O'Henry is and whats this all about, here is the context.
O Henry was a famous American writer of the late 1880's (Wiki: http://en.wikipedia.org/wiki/O._Henry) known for his short stories, "The Last Leaf" being one of them. 
The story revolves around a young lady who was unwell and had her mind set on this wrong notion that as the last leaf of the ivy vine growing on the fence of her house (that she could see from the window, laying on her bed) would fall in autumn, her life would come to an end. An old painter used to rent the basement of the same house. He came to know of this silly association of the lady's well-being to the 'last leaf'. On a cold, rainy night went out there and drew an ivy leaf (the last leaf) on the fence as if it were part of the ivy vine. Finding the leaf never fell, this lady got inspired, got better with time and one day ventured out into her yard for a walk, only to find that the ivy leaf was a fake drawing. Soon she realized, went down to ask about the old painter. The chambermaid of the house informed that the old painter was found frozen to death the next morning of the night he was out painting his 'masterpiece'.
This decorative plant, with all fallen maple leaves around, standing proudly green out there in the cold, reminds me of this short story!

Monday, November 3, 2014

Selling Photos


Now that I realize Photography is an expensive hobby, i am open to make extra cash by selling the photos I have clicked. Need to put this towards my next full-frame camera.

If you like the photos and are interested in buying High Quality copies.
Please let me know (ojoswi@gmail.com) and I can email them to you.
            Price for Exclusive rights: 100$ per photo.
            Price for High-Quality copies: 15$ per photo


Sunday, July 21, 2013

Love - Life - Losses

It is Human nature that we do not treasure something or someone as long as we have that as ours. The value becomes ever so evident once we have lost it? We take it for granted that these loved ones and objects would be around for us for ever.
One recently learned lesson - the only constant thing about life is change. When you loose something that you have loved for so long, there comes this void and no matter what you try and what you do, this void remains. So make the most of your blessings, treasure the gifts you have and the people you love!

Sunday, November 6, 2011

My Love Story!

I was born into the Gen X of the 80's. Heavily influenced by the romantic-comedies in HBO I grew up watching. All the romance, kissing, steamy-raunchy rated scenes proliferant in Hollywood movies, had a deep impact on me during my making years. I grew up believing that boys were to woo girls and the fairer gender were to succumb to their charm eventually. As if destined, I grew up into a teenager who looked upon all beautiful girls around as potential date and a few among them as the heroine of my very own 'Love Story'.

Things were warming up as early as high school. Working on my love letter writing skills, heading for the movies, taking girls out for dates - had to wait till college tough. All thanks to the newly found freedom of movement that residential college brought with it. Private coaching a few local high school students towards competitive exams was a good source of income in my college days - so money was never a problem. Looking back, I had a lot of fun and very little luck. The dates ended in movies and dinner - things never matured into anything more interesting or rewarding. Having a steady girl-friend was hard to come by leave aside getting into a relationship.

Four years of college just whisked by and there I was - hopelessly single, virgin to the extent of never having touched a girl romantically. Professional life was no different and this time I could not be so explicit with my romantic advances - it was no longer college! All the pretty hotties I knew were either taken or married. Soon I was 30 and the situation was very grim. The sands of time had run out from the 'fun' side into the 'get serious' side of the hour-glass. I had to give in to my parents' wish of getting me married. I was then in Canada on an assignment and my parents believed technology could bridge the gap of distance.

What followed was torture. Every week-end I was glued to my laptop, sifting through profiles and photos of prospective alliances, short-listed by my parents over the week. It was nerve-wrenching to say the least. Nothing seemed to work - most of the profiles were lame. This went in for 8-9 weeks. I could not take it anymore. On the verge of a mental breakdown, I backed out from the bride hunting marathon which clearly was not going anywhere. Having given up the responsibility of finding an alliance to my parents entirely, I started parting even harder as I had realized that soon my fate would be written off with an 'average', 'down-market' girl - profiles of whose were swarming across all the matrimony sites.

Later I was told, when my parents realized the hopelessness of looking at profiles over the matrimonial sites online, they decided to post an advertisement in the local newspaper's matrimonial section. Alliances poured in and this time a few of them caught the imagination of my parents. Horoscopes were tallied with the short-listed candidates and lines of communication were established. One Sunday, during a Skype call with my parents, I was enlightened about the movements that had happened over the weeks. Photos along with the profiles of three short-listed girls were emailed to me soon after. And this time I found one of them worth taking a look at. Emails went out and numbers exchanged between guardians - eventually passed on to me with a Skype video-conferencing set up between the prospect and me.

It was an awkward mix of nervousness and excitement. I knew this was the real deal, decision taken now would change the course of my entire life. The week went by in a flash and it was Saturday, the day I was to Skype Piali and I had no clue of what I was supposed to ask her or even talk about! The call came in and I took it. What followed was a conversation unprecedented in my entire life. We were an hour into the conversation and it seemed like minutes. I was very comfortable talking to her - on my preferences, hobbies, profession, short and long term goals - pretty much everything under the sun was talked that day! After the call, parents were given the 'go codes' - things were moving at a crazy pace. I took an unlimited India calling plan. We Skyped every week-end, talked over the phone for hours. It seemed as if I were a call center employee - with the microphone ever attached and I talking away to glory.

 It was during these days that I stumbled upon a discovery - Piali was an amazing singer! One day she sang to me over the phone and it seemed as if I had transcended to another dimension of eternal peace and poise. I was mesmerized, swept off my feet and hooked on to her singing. Everyday she used to sing to me over the phone before hanging up. But the song she sang to me the first day ever remains close to my heart! And after our marriage (this post is a tribute to our 1st marriage anniversary) I have convinced her into recording that song - 'Main Tainu Samjhawa Ki'. So here is a toast to my 'Love Story', our marriage and her song!

Saturday, June 4, 2011

On Evolution

It was 13.5 billion years ago that chaos gave rise to the universe, 5 Billion years ago earth was born. 4 billion years back ours was literally a lonely planet without life! 6 million years back we lived on trees and looked much like Chimpanzees. 6 years before Christ, we believed Earth was flat. In mid 1500's man challenged the idea of Earth being center of the Universe. So less happened in so much time - few and far away grains of events in the hourglass of evolution. But winds of change ushered in with the Industrial revolution only a 100 years back - each day was pregnant with an invention that would change the way of life. 100 years of technology versus 13.5 years of evolution - so much in so less, imagine the road ahead!

Tuesday, May 3, 2011

Bengali Rasgullas in Toronto

I Looked for authentic, fresh, soft and fluffy Bengali Rasgullas in Toronto. But was very upset to only find the stale canned Rasgullas of Haldiram. 
Even the ones at the Indian sweets shop were extremely dry and tasteless. The fluffy, softness of Bengali Rasgullas were missing.
I am now open to share this Bengali treasure with folks in GTA. Price for 15 Rasgullas is 5 CAD

Thursday, July 22, 2010

Indy Honda – Formula One race comes to Toronto


Was one of the rare week-ends when I was in town, but not one where I was lazing away my time. It was my week-end at Exhibition Place, Toronto - for the much coveted Indy Honda Formula One racing! My first ever experience on the tracks and it sure did turn out to be much more trilling than I expected it to be. My seats were in the 9/10 turn stands. But the sun was so strong and the thirst so high – that I could not resist myself from taking myself to the Hooters Beer Camp.
Pretty girls, friendly and forthcoming, serving chilled beer with a warm smile, an amazing view of the hot wheels scorching the tracks – a combination too much for the young at heart to deny! The noise, the energy, the crowd, the weather and the babes at Hooters – all perfect. The event stacked up to be a very successful one and for me a memorable day out among hot wheels and high heels!

Joy of Jiving to Jovi

July 21st 2010 shall remain ever etched in my memory! For it was Bon Jovi's concert at Rogers Center, Toronto – the venue could not have been better. I had got tickets to this event online a month back and was eagerly waiting for the day. After all, since my early college days I have grown up listening to Rock and Pop – especially Floyd, Scorpions, Bryan and Jovi.
On d-day, I reached the venue much in advance and lined up to take the actual ticket by exchanging the e-receipt. Lucky me, my ticket had got upgraded to one of the prestiged seats in the VIP Lounge of Roger’s center!! Folks who have not been to Roger’s VIP lounge - let me try to give you an idea of how it is. It has a vista similar to the player’s enclosure/media room of a cricket stadium, upgraded with comfortable sofas and cushions (much like the VIP lounges at a multiplex).
The concert stage was straight ahead of me and the huge screen made it look as if Jovi was jiving just an arm’s distance from me. The concert packed in a lot of energy and excitement, with a mix of new and popular songs. People were dancing, cheering and the entire atmosphere was electric with not a single seat unclaimed! Putting it all together, with my fancy run with luck, it remains one the most remarkable live concerts I have been to.