Data Viz Giants
When I joined data school around 3 months ago, I was under the impression that we would be heavily invested in just the one Data visualisation tool. I mean Afterall the entire application process revolved around Tableau and Tableau public. However, you quickly learn that as good data analysts and data consultants you do not want to be tied to just one tool but rather be well versed and have a versatile toolkit that you can employ to service your client’s needs. For those of you that are familiar with Gartner magic quadrants, will quickly recognise the matrix below and for the better part of a decade Microsoft’s Power BI and Salesforce’s Tableau have been distinct leaders in this space. This is just showcase that If I were to work with clients requiring data visualisation chances are they would hand me one of these two tools to accomplish that task. But I am not writing this to bore you with the commercial aspects of a data visualisation, I want to share my perspective on these two tools coming from a non-technical background and when I would use one over the other.
Look and Feel
Let’s start with the look and feel of both these tools. Technically speaking, no business end user will be looking at these tools in the same perspective that I do. However, their design and layout change the way I approach my analysis within each tool even for the same datasets.
When I first opened Tableau, it felt like a blank canvas inviting me to just start creating. I could drag things around, experiment with colours, and see immediate feedback, it was spontaneous and intuitive, almost like sketching. It also looks and feels quite minimalistic almost Apple-like. In contrast, opening Power BI felt more like stepping into a workshop. Those familiar with Microsoft’s other products will immediately feel at home with the interface however, it will feel like everything but the kitchen sink. That is, it feels inherently equipped to do everything you would need with your data without ever leaving this space. It became clear to me early on that Tableau encourages you to build a viz first and explore, whereas Power BI expects you to model your data first and then plan the visuals to follow. As someone with a background in visual arts, that sketchbook like spontaneity in Tableau felt natural. Power BI, on the other hand, asked me to think more like an engineer, structured, deliberate, and methodical. If I had to sum it up, I’d say Tableau helps me discover the picture as I go, while Power BI wants me to plan the picture before I even began.
Contrasting approaches, Common outcomes
One of the first things I noticed when working with Tableau was how effortlessly it handles colour. I always appreciated how visually pleasing the defaults were, there’s an elegance in the way Tableau layers marks, gradients, and transparencies. It felt like the tool understood colour theory. I could play with hues, drag dimensions into the colour shelf, and immediately get results that looked polished.
Power BI, on the other hand, took more setup. Colours often need to be defined manually or through themes, and there’s more logic involved in formatting, especially when using conditional colour rules. But what it lacks in spontaneity, it makes up for in consistency, such as when applying corporate branding.
Calculations follow a similar contrast. In Tableau, creating calculated fields feels like adding a new brushstroke to a canvas, you experiment, see what works, and adjust visually. The logic is tied closely to what’s happening on the view in your worksheet. Using DAX in Power BI is like coding logic into a system, you need a clear structure before you see results, you need to understand how filter context and row level logic work before you can build dynamic calculations.
Tableau lets me build as I think; Power BI makes me think before I build. Both approaches have their strengths, but they speak very different creative languages.
Conclusion
There’s a famous saying in the photography world that would feel right at home here. “Canon is designed by engineers for photographers, while Nikon is designed by photographers for photographers”. From where I am standing Tableau feels like it was designed by artists for analysts whereas Power BI feels like it was engineered by Engineers for analysts. Before my Data school journey many months ago I believed visual flair alone could carry a dashboard. Today I know the layered work that goes into making insightful dashboards that drive important decisions. So, like switching lenses on a camera, I now choose the tool that frames the story best.