and the winner is in this video we'll compare Microsoft Excel versus Power bi across these
six categories so you can see which one is better so let's get into it starting off with difficulty
and Excel is much easier to get started you can pretty much learn to make charts or formulas in
just a few minutes on the other hand with power bi you need to know how to use power query to
manipulate the data and you need to learn how to use powerpivot to link the data before you
can even get to charts or visuals so the learning curve is definitely steeper with power bi also if
you get stuck with Excel there's so many more resources out there to help you out than there
are for power bi for these reasons we'll give a point to Microsoft Excel when it comes to
visuals both power bi and Excel have an extensive list so let's take a look at both over here you
can see that we've got an Excel dashboard and as you can see it's fairly customizable and
I've also been able to link it like that and so let's suppose that we want to change this chart
over here to do so we would have to go under chart design and then go to change chart type
let's suppose I change this to an area chart and hit on OK and you notice here that it doesn't look
very good because you can't see 2021 so you would need to change some of the formatting there on the
other hand with power bi let's say I have this dashboard over here and I want to change this
from a column chart to something else well I can simply click on any other type of visual
and that's going to update pretty much on the go so the interface here is definitely a lot better
similarly if I want to filter specifically by this age group say 40 to 49 I can simply click
on that and you'll notice how all of my dashboard dynamically changes as well you can also get a lot
more detail into the data so suppose over here I have this other dashboard page I want to find out
why this increase happened from September to October when it comes to revenue I can
simply right click on the number I'm interested in go over to analyze and explain this increase
so over here it's going to give me a breakdown of why that increase happened in this case broken
down by day finally power bi does have some unique visuals that Excel doesn't for example over here I
have what's known as the decomposition tree and I know it looks quite empty but just hit on the
plus sign let's suppose that I want to find out by region so you can see the revenue breakdown
by each of the regions I can further break it down into country and let's suppose that I'm interested
in the city as well and it's fully Dynamic so if I switch over to West you can see how that switches
and same thing goes from country to City for these reasons we'll give power bi the point here after
all it is a visual Focus tool when it comes to entering data which can be useful for financial
modeling data cleaning Etc Excel is much easier and more intuitive to use so for example if you
just want to do some quick analysis on the data Excel is probably the faster tool for example
suppose I want to find out the average price here I can simply just use the average formula
and then select this area and I'll find the average like that similarly if within this whole
range over here I want to find out the values that are above the average I can just go over
to conditional formatting then go to top bottom rules and say above average now I'm just going to
fill those let's say in green for example and hit on ok now I can see what that looks like for quick
analysis like that Excel is much faster and more intuitive than power bi that said when it comes
to larger data sets with thousands or millions of rows then power bi is typically slightly better as
it doesn't lag as much as Excel does nonetheless we'll give the point to excel here for data entry
if you're watching this video and considering watching Power bi you can check out our brand
new power bi for business analytics course in our all-inclusive curriculum we start with data
cleaning and transformation using power query then we get into Data visualization tools followed by
docs or data analysis Expressions which is what you would use to build formulas in power bi then
to simulate real world scenarios we'll practice with two extensive case studies one will focus on
building a profit and loss dashboard from scratch on Nike while the other will focus on visualizing
mcdonald's's European restaurant operations and if you get stuck along the way you can always ask us
the instructors questions and the discussions Forum on the side so if you're looking to
level up your power bi check out the link in the description below alright back to the video a key
area that Excel lacks is sharing and collaborating most of the time you just end up sending the Excel
file without being able to work on it together Live While there is an option to share an Excel
file on the web it's typically quite slow and laggy and it's not all that common on the other
hand for power bi you can view reports on a computer on a tablet or even on a smartphone
then for the collaboration side you can upload it to the web as well and you can have discussions on
the side to in this sense power bi is a clear winner next up is popularity and this is more
important than you think you don't want to end up learning a software that nobody else knows how
to use excel's main competition is Google Sheets which is pretty much the same tool so we'll just
put those as one on the other hand with power bi there are some serious competitors including
Tableau or qlikview so depending on the company that you join they might not be using power bi
that said a recent report from Gardner showed that 97 of Fortune 500 companies use power bi
so it's probably still a safe bet overall for popularity Excel gets the point finally when it
comes to getting set up both power bi and Excel are free to get started but Power bi is a bit
more tedious in that it requires a work email so not one that ends in gmail.com for example
when it comes to pricing to unlock all features all the eye has three different tiers starting
at ten dollars per month as far as I can tell there's no option for a one-time payment on
the other hand you can buy Excel as a one-off or you can also buy it as a subscription which
comes with other Microsoft Office products at a much cheaper price of seven dollars per month
so when accessibility Excel gets a point here and the overall winner is Microsoft Excel at
Four Points to two on the whole Excel is much more useful to the general audience when power
bi is more focused for those that work on data analysis and business intelligence as per which to
learn as a first step you should learn Microsoft Excel which is really just a basic requirement for
most jobs and then switch into Power bi which will hopefully give you a bit of a recruiting
Edge as it's not that common for everyone to know it if you're comfortable with Excel and
you want to learn power bi check out this video over here we take our power bi course over here
hit a like and that subscribe and I'll catch you in the next one