![]() ![]() You could argue that the Dependency view inside Power Query could give you that “high level view” that Tableau Prep also gives you, but the whole drag and drop, the whole visualization and layout that Tableau Prep has is something really well done and interactive, so it’s engaging and inviting. Here’s a quick comparison showcasing the pros and cons of each tool based on the experience that I had with them during the creation of the Merging Data solution:Īgain, the main difference between Power Query and Tableau Prep is the fun factor and, in this specific case, the “flow” view that is right in your face whenever you’re creating a solution with Tableau Prep. ![]() They were all able to accept the logic that we had in mind. Similar to the first scenario, none of the tools had any issues delivering the expected solution. Trifacta Wrangler also had that fun factor, but for some reason it was pretty sluggish loading datasets and loading its own screens. The whole drag and drop and the whole visualization and layout that Tableau Prep was something new and refreshing to me, so perhaps that has something to do with it, but I haven’t had that much fun with an ETL tool in a while. The main difference between Power Query and Tableau Prep is the fun factor. The winner in this case is actually Tableau Prep! In second place we have Power Query and third place Trifacta Wrangler. (for more information about what is and how to read a Pugh Matrix I recommend reading this article ) Now let’s go with the final Results for this specific scenario: ![]() Here’s a quick comparison showcasing the pros and cons of each tool based on the experience that I had with them during the creation of the Grouping Data solution: Scenario 1: Grouping DataĪll of the tools were able to accomplish the result fairly quick and simple. We’re going to break this down by each scenario and then we’ll tally up the results to figure out who’s the winner. Big thanks to everyone who helped me along the way through forum responses and multiple emails! Luckily, someone within Tableau’s Sales team did see my videos on YouTube and was able to give me a more refined view of what Tableau is capable of. I tried getting in touch with the Tableau folks, but they never replied to my emails. I was able to get in touch with the Product Team from Microsoft’s Power Query and also the one from Trifacta’s Wrangler. The results are in! Let’s find out which tool is better for the average Business Analyst based on the 3 scenarios that I showcased a few weeks ago here. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |