Relevance Found

For this month I thought that I would try my hand at a selected MakeoverMonday challenge. For this one I picked Week 4, the data set is available here . I actually did this using the Tableau 2020.2 Beta (I have early access!) and my viz utilised Tableau's new #DataModel Do you ever have to blend data at varying levels of detail (LoD)? This is a frequent challenge faced by analysts working in the field: you might get a transactional sales analysis of each and every sale across the organisation, but you might get a year-end debtors analysis that aggregates to major customer accounts. Reconciling between the two can get very time consuming, and a lot of the typical analyst's time is spent (nay, wasted?) in detailed reconciling of different records and manually transforming data sets in Excel. Tableau's latest release tries to do away with this by introducing the " Data Model " (also known by us affectionately in the community as the "Data Noodle...

If all you know how to use is a hammer, everything looks like a nail! I frequently get asked, "Izam, can you use Tableau to create a chart that looks like this ..." or "Izam, can you use Tableau to calculate this ..." Lately, I've been thinking about how the tools we use shape the way that we go about solving problems. And the above adage comes to mind: if all you know how to use is a hammer, everything looks like a nail! Excel and PowerPoint are great for writing documents and reports. Reports which go about answering the: "WHAT"  are we planning to do?  "HOW MUCH"  are profits? or "WHEN"  does it need to be done by? Tableau on the other hand, shines when we use it to explore the question ... "WHY"  is this trend happening? "How much are profits?" For example, with the Superstore sample data set, an analyst might be interested in building out a table that compares the key performance indicators of...

Achieving sustainable growth is one of the foremost concerns of modern businesses One popular framework used by business people when analysing the impact on strategies aimed at improving revenue and achieving sustainable growth is the old chestnut of price and volume: Source: Beautiful.ai This works great, but one analysis I like to do is called cohort analysis. This really helps sharpen the focus and helps us zoom in on managerial actions that can move the dial. You can think of these as levers of value: Source:  Beautiful.ai Cohort analysis in Tableau With three, easily re-used formula, we can replicate a cohort analysis on new data sets with relative ease when we've deployed Tableau in our analytical toolkit: // A fixed LoD to set the Customer Acquisition Date [Customer Acquisition Date] {FIXED [Customer Name] : MIN ([Order Date]) } // A fixed LoD to set the Customer Lost Date [Customer Last Date] {FIXED [Customer Name] : MAX ([...