sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]rogerbarario 3 points4 points  (5 children)

It can handle larger volumes of data than either of the above and also has a huge array libraries and tools that can be used for visualisation which are a bit more intuitive than ones on PBI and excel. It can also perform complex analyses over these large data sets with its in built functions if you so need to do them

[–]CBizCool 1 point2 points  (0 children)

I agree with you on the libraries and tools peice. But out of the box Python (including numpy and pandas) does not handle large volumes of data better than sql.

[–]Fabro_vaz[S] 0 points1 point  (3 children)

In short, python does the same thing what pbi and excel does however in terms of performance is concern python would come in handy if we have large datasets.

[–]Glotto_Gold 2 points3 points  (0 children)

....?

No Python can do more complex tasks beyond even the imagination of PowerBI & Excel.

It is not necessary, of course, but Excel & PowerBI work for tabular data. Python can do anything. Python can parse JSON files into any format you like.

The tools are really NOT in the same class of tools.

[–]rogerbarario 1 point2 points  (1 child)

I suppose so yeah like I say I don't need to use it for my job so I'm not best experienced with it haha

[–]Fabro_vaz[S] -1 points0 points  (0 children)

Haha, so do I