hey guys welcome to Intellipaat we are back again with another interesting
video on a vs. topic so today's video is gonna be all about two of the most
popular data visualization tools which are tableau and power bi so guys before we
proceed further to subscribe to Intellipaat's youtube channel so that you never
miss out on any upcoming videos so let's have a look at the agenda for this video
first and foremost we'll discuss what exactly is tableau and power bi after
that we'll see the data visualization in both of them then we'll discuss few of
the parameters based on which we'll differentiate in between tableau and
power bi after discussing the parameters we'll see the pricing in both of them
followed by the functionality support level and licensing then we'll also
discuss about the infrastructure and scalability in power BI and tableau
finally we'll conclude our video by discussing which one is better to choose
we'll also have a short quiz based on the video make sure you put on your
answers in the comment section below also guys if you're looking to get
certified in power bi or tableau then do visit Intellipaat.com alright guys so now
without any further delays let's get started so guys first and foremost
we'll discuss what exactly is tableau and power BI starting of it
what exactly is Tableau, Tableau is a powerful data visualization tool which is used in bi
industry right by using this you can simplify raw data into an easily
understandable format table was developed in 2003 and the data that you
create using tableau can be understood by professionals at any level and the
best part of using this is that it does not require hardcore technical skills in
this even a person who does not have any programming knowledge can create
customized dashboard in tableau now moving on to what exactly is power BI
so it is a business analytics tool which was developed by Microsoft in 2013 it
has generally used for interactive data visualizations and business intelligence
it provides an interface which is easy and simple to understand and work with
end users can create their own dashboards and reports using power bi
right now as we'll discuss about these tools in a brief now let us discuss
about the data visualization in both of them right so first and foremost let us
understand what exactly is data Visualization so data visualization is nothing but we
presenting the particular data in the forms of charts diagrams graphs and so
on instead of going through the reports which are made up of complex and large
amount of data you can just use graphs diagrams charts etc that is as they will
be more convenient for the users to understand isn't it
which bi tool you should choose for data visualization well it depends if you are
looking for data visualization tool for customized data visualization then you
can go with power bi as you can drag and drop into the visualization through a
sidebar and you can import the data as well right it also has open up software
development kit which helps you convert data from various data sources into
interactive reports and dashboards whereas when it comes to data
visualizations using tableau then it is majorly used for pure visualization like
if you are looking for more organized and clean approach then you can choose
Tableau if this data visualizations are created in the form of worksheets or
dashboards right now a view provides corrections to multiple different sets
of data sources and it has majorly used for larger sets of data visualization in
an organization so it has additional drill down features also now let us move
forward and discuss about few the parameters based on which we will
differentiate between both of these tools so the first parameter that we
have is performance here so this in tableau it can handle large
amount of data from different data sources with better performance whereas
power bi can only handle a limited amount of data here second parameter is
the source of data Power BI has limited access to the other
servers and databases as compared to tableau for example oracle databases
post way SQL database SQL Server database SAP Hana database and so on
whereas in case of tableau it has got access to multiple number of different
servers and database sources such as text file JSON file PDF file actual
statistical files Microsoft SQL Server MySQL and Oracle redshift and the list
goes on right now in the third point we have the difficulty level of learning or
learning curve so there is a power bi it is comparatively easier to learn as
compared to tableau even if we see from the learners point of perspective
or the business point of perspective Power BI is comparatively easy to
understand as well as easy to learn I'm not saying that tableau is very much
typical to learn or understand but Power BI is comparatively a little more precise
when it comes to such kind of terminologies right so now if we talk
about its data capability so as in power bi each group or workspace can handle up
to 10 GB of data and more than 10 GB of data are supposed to be in cloud or
Azure I would say right but if it is in local database then power just pulls the
data and does not import them but in case of tableau it works on columnar
base structure that is it only allows to store unique values for every column and
that is how it is possible to fetch billions of records or rows in this
right now moving towards our fifth parameter which is integration so
integration in case of power bi you can easily integrate with different data
sources like SharePoint Azure power flow power Apps 365 Excel and many other
Microsoft products whereas tableau is used for more scalable approach here
with different different outsourcing tools as well even including all of
these Microsoft based tools as well as out so space tools also right and a six
parameter is about the Data shaping so Power BI offers query editor which
allows its users to do many things in an easier manner and it is more flexible it
also offers set documenting and other features as well whereas tableau does
not offer any of these kinds of services now the seventh parameter that we have
is the data modelling Power BI provides PowerPivot dots which are more
accessible to the users whereas tableau does not provide any of them finally we
have application today's Power bi is used for dashboards custom visuals and more
like open source approaches but tableau is used for longer run operations and ad
hoc analysis as you have discussed about the parameters now let us hit the word
surprising path so guys when it comes to pricing then power bi is more affordable
option as Compare to Tableau because Power BI offers three
subscription t is that is desktop true and premium desktop cost is not
chargeable for its users and pro cost starts as nine point ninety nine dollar
per user per month pro also offers sixty days of free trial and in this server
cost web user cost etc is lesser and the premium plan starts at four thousand
nine ninety five dollar per user per month as per the storage resource right
whereas Tableau offers creator Explorer and view subscriptions and at offers free
trials of 14 days for users create a plan costs $70 per user per month and
the Explorer cost starts at $35 per user per month and tableau viewer cost
starts at $12 per user per month which is a bit higher as compared to Power BI so
if you look at it from the initial cost perspective then power bi is way cheaper as
compared to tableau but for longer run that has total users cost per year is
lesser than tableau so there's after knowing about pricing let us differentiate them
based on some of the functionalities of both tableau and Power BI first we have in the
functionalities is the support level so as a power bi a customer support is
limited for users for free bi account and it offers robust support resources
and documentation whereas tab you offers comprehensive knowledge base support for
its users now if you talk about licensing then power bi has rigid licensing
whereas tableau has flexible licensing and in case of infrastructure Power BI has SAS or
software as a service infrastructure whereas tableau has a flexible
infrastructure here and when it comes to scalability for larger data set Power Bi
has good scalability whereas tableau has much better scalability for larger data
sets as compared to power BI now ways let me wrap up this session for you
with a small discussion on which one is better to choose Tableau or power bi if I
speak honestly then one cannot say that I'd be that one bi tool is better than
the other because power BI can be a better option for small organizations as power
BI offers more affordable business solutions right whereas tableau users
can integrate huge amount of data points from
different data sources for analysis right so both Tableau and power bi have their
own pros and cons and different features which either both of them have or other
one lacks right but still if you want to conclude then it all depends on users
business size and requirements and if we talk about the career scopes in them
then of course a career in both of these domains is of higher relevance as the
majority of companies are always in a dire need of peer professionals with the
skill sets in both tableau and power bi so guys now I have a very simple
question for you what are the different kinds of licenses that are available in
power BI and the options are oxygen a power bi free option B power bi premium
option C power bi Pro option D all of the above option e none of the above
right so do let us know your answers in the comment section below know if you're
correct so guys I hope this video was helpful to you if you have any further
queries then do let us know in the comment section below we'll reach out to
you immediately thank you so much for watching this video and giving us a
precious time see you again