Power BI and Tableau guides

WOW2022 W33 Tableau vs. PowerBI Workout Wednesday 2022 Week 33   challenge   by Lorna Brown originally done in Tableau, also recreated in PowerBI.  This blog aims to highlight the similarities and differences between both softwares. A big thank you to Lorna for her encouragement and support to create this post. Preparation Tableau  Other than hiding all the fields that are not required, there was no preparation needed. Power BI First thing, I also removed the columns that are not needed for this exercise.  As this visual requires several date operations I created a date table.Here lies one of the main differences between Tableau and Power BI. Power BI gives you more flexibility to design and expand your data model. With the additional date table I have more control over the format of the date values I need and also I can reference the fields I need for date operations rather than create a separate calculation for that. This script creates a calendar table from the minimum ord

Power BI vs. Tableau  Why Sets are so powerful Watching the video Display Sales for Top Products and Others  from  Chandeep Chhabra , i was intrigued by his solution to the problem.  As there's quite some preparation needed for the desired outcome in Power BI i was wondering how i would tackle this in Tableau. The answer is by using Sets.  In this article i want to document the approach in both tools. Although Chandeep provides a comprehensive walkthrough, I'll create the Power BI visual from scratch for better comparison. The Challenge  Chandeep created a visual that displays the Sales of the top n products and all remaining products as 'Others'. The result is sorted by Sales amount, with 'Others' at the last position. In order to make it easier and to focus on the essentials, I have focused on the top 5 instead of the top n for my example. As dataset i used the Sample Superstore from dataworld . Preparing the dataset Tableau I only need Sales and Sub-Category