Lovekesh Babbar

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