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?”

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”

How do I display incidence frequency in tableau

So, you are interested in displaying the frequency of a specific type of event over time.

For example, what if each of my orders isn’t making a profit for me and I would like to show the frequency of each of these orders rather than showing the sum total of profit for each week

If I were to show the total of the profit over time, I might show something like this

Profit Chart.png

But, the issue is that this shows the total of the week but doesn’t show the frequency of the loss making orders.

Continue reading “How do I display incidence frequency in tableau”