Can I use Tableau join culling instead of referential keys on the database?

Ok, I have been meaning to run a few tests with actual data to see if Tableau join culling feature

 

  • Whatever you can do in DB, do it in DB including performance optimizations. Tableau is great being able to overcome some of the DBA laziness (with features like Join culling) but it still won’t overcome everything
  • You must know Join Culling doesn’t always work such as in scenarios like outer joins, etc. (if you need a list of those, there are other blogs that cover that)
    • Now, also keep in mind that depending on how you build the Tableau model, you might get confused why it doesn’t always work even if it is all inner joins and even we have checked the “Assume Referential Integrity” dialog box
    • You should also understand that the SQL generation is also affected by the the order in which you bring the tables into the Tableau model

Continue reading Can I use Tableau join culling instead of referential keys on the database?

Here’s what you need to survive the brutal tech industry in Silicon Valley

Are you in the tech industry, over 40 and worried about hot having the skills to be the tech industry 10 years from now?

Well, that was a topic of discussion that I was in with one of my friends recently. He and I are both in tech industry and live in the area and are both 40. So, maybe this discussion was a result of us living a mid-life crisis. 😉

Regardless, we were discussing what skills do we need to acquire now to be marketable a few years from now. Would we lose our marketability in the workplace, given the ever evolving nature of the tech industry?

Continue reading Here’s what you need to survive the brutal tech industry in Silicon Valley

How to add corporate branding to your Tableau dashboard

Wouldn’t it be great if you could add some corporate backgrounds to your Tableau viz just like you do in powerpoint?

Well, you can and here’s how

Once you have created the Tableau Viz, just add an image to the dashboard, make it floating and add to the your dashboard and cover the entire space.

Step 1.

Continue reading How to add corporate branding to your Tableau dashboard

US Election Results – with Tableau

Enjoy a Tableau visual showing results of all US elections till 2012

Using AngularJS to build your visualization

Recently, someone asked me how I would compare AngularJS as a platform to create visualization vs. Tableau and I mentioned a few things.

Here are some of my documented thoughts

Continue reading Using AngularJS to build your visualization