Published in Geek Culture·Nov 2, 2022Why normalization is vital for Data integrity?To those who don’t understand normalization; Normalization is the process necessary to maintain data integrity and eliminates duplication. You implement RDBMS principles to ensure the quality of data is not compromised but upheld. There is a lot written on what is normalization and RDBMS principle, available on the net. …4 min read4 min read
Published in Geek Culture·Sep 25, 2022Show/Hide data in Rows/Columns/Grand Total in TableauHave you ever come across any requirement where one calculated field should appear in rows/columns but not appear in grand total or vice-versa? Let’s dive directly into 3 ways we can do this. Case: Requirement is to view the Profit and sales generated by Customers on each of the weekdays…4 min read4 min read
Published in Geek Culture·Jul 30, 2022How to if Grand Total calculation is different in Tableau?Have you come across a scenario where your calculation in grand total may be slightly different than that specified in the rows? Let me give you a context. And for that let’s consider our good ol’ Tableau Superstore dataset. With this dataset we will use a column ‘Product Name’ that…Grand Total Tableau4 min readGrand Total Tableau4 min read
Published in Geek Culture·May 30, 2022How to avoid Data Chaos?Even though you may be working in the capacity of a Tableau consultant, you should not be blindsided by the narrative that knowing just Tableau will be enough to succeed. Familiarize yourself with the whole data ecosystem, which is essential for success. Recently, I was a witness to a data…Data Chaos4 min readData Chaos4 min read
Published in Geek Culture·Apr 22, 2022Boosting Tableau Dashboard’s PerformanceDashboard performance should be paramount for corporates especially when processing millions of records, which can only be expected to increase with time. Fortunately, we have a solid starting point with Tableau’s online documentation. However, there are quite a few things you have to figure out on your own. In Tableau…Tableau Dashboard4 min readTableau Dashboard4 min read
Published in Geek Culture·Feb 19, 2022Thought-process behind the Michael Schumacher VizThere is a reason the viz is grey in color and not Ferrari red. After months of fretting and contemplating, my viz on Michael Schumacher was finally done in February this year. All because it was personal. …Tableau4 min readTableau4 min read
Published in Geek Culture·Jan 25, 2022Hierarchy Chart with Layers in TableauHave you ever thought of a hierarchy (organizational) chart with some spatial functions and layers in Tableau? Recently, one of the visuals for #vizforsocialgood required to project the benefits and the beneficiaries along with their values. And since the audience was general public, demonstrating the same in a hierarchy would…Hierarchy Chart Tableau5 min readHierarchy Chart Tableau5 min read
Jan 2, 2022Role of Tableau #Datafam in my life — 2021Now that we are in the year 2022, I had a chance to reminisce and assess what the year gone by brought to me. …Datafam6 min readDatafam6 min read
Published in Analytics Vidhya·Dec 7, 2021Showing KPI percent change in Tableau with Gauge ChartsI’m back — with another chart the working of which I could not find on the net. As before, I will detail the steps to make the chart. But first let’s understand the context. There are a plethora of Gauge charts available on the net. But the requirement was to…Gauge Chart5 min readGauge Chart5 min read
Published in Analytics Vidhya·Oct 22, 2021Highlighting a measure column from many in TableauRecently, I was asked to highlight one measure out of a few measure columns in a text table using Tableau. And the user should have the facility to select the measure that needs to be highlighted. A casual search on the Net and I discovered a solution which needed a…Tableau4 min readTableau4 min read
