12-22-2021 11:21 AM - last edited 12-23-2021 05:36 AM
I built a similar dashboard using Tableau public a few years ago, thought I replicate the Tableau dashboard in Power BI to compare this two popular data visualization tools. Here are the key findings:
1. Data Connection: The stock price and other information are downloaded using Python package yfinance, then stored in Google Sheets. Both Tableau and Power BI can connect to Google sheets and set up the refresh schedule easily. Both tools can connect hundreds data sources from local compuater to cloud storage. I do have trouble to connect Power BI to IBM planning analytics at work, but I am sure there are data sources that Tableau cannot make the connections either.
2. Data Transformation: Power BI has my 100% vote as the better data transformation tool. I love the feature of Power Query records all the steps, and how easy to trouble shoot when the data changed. I cannot tell you how many times that Tableau prep breaks with little change in the source data and I have to re-do all the steps. No wonder Alteryx are picked to pair with Tableau for data transformation.
3. Data Visualization: Well, I have to vote for Tableau on this one. Out of box visual in Power BI are very basic. Although there are custom visuals available, they usually act slow and don't play well with the native visuals. I was excited that it does have the Python visual which opens up a lot of possibility for me, but I can only use it at work with the pro license. Tableau, on the other hand, it is quite easy to use when buildig visualizations. I love how easy it is to make the tool tip and title, and formating. While using Power BI, I have to write a novel long dax to make it happen 😂.
Overall, both are great tools to create data visualizations. Both tools have their limitations, but both companies are working on the improvement and they are getting better every day.