Overview for Power BI
the time has come for us to officially meet Power BI by a quick summary. Here
Power BI is a standalone Microsoft business intelligence product which includes
both desktop and web based applications for loading modelling and visualizing
There’s a ton of additional info if you’d like to learn more at powerbi.microsoft.com
want to show you something called the Gartner Magic Quadrant and
Gartner’s and market intelligence Research Company. They produce these
quadrants a few times a year. And what we’re looking at here is the Magic
Quadrant for analytics and business intelligence platforms specifically updated
February 2021 and the idea is that you have completeness of vision on the x
axis and the ability to execute on the Y axis.
you break down the players into the four quadrants you end up with niche
player's challengers, leaders and visionaries and where you want to be is right
here in this top right corner where the leaders live.
that’s exactly where we find Microsoft with power BI leading the charge among
some very popular and very powerful other platforms like Tableau, IBM, Qlik,
exciting time to be learning power BI because I think it’s only going to get
more powerful and more popular from here onwards.
of Power BI
are some of the key benefits that make this such a game changing product.
Connect, transform and analyze millions of rows of data
connect transform and analyze millions even hundreds of millions of rows of
data and you can access that data from virtually anywhere whether it’s a
database flat files on your desktop cloud services folders of files etc.
There’s a huge connector library that allows you to access a ton of information
and then not only that but you can create fully automated and repeatable ETL
procedures to shape and transform and load the data from those different
relational models to blend data from multiple sources.
actually build relational models inside of power BI. to blend the data from
each of those multiple sources. And this is a concept that’s getting more and
more important in the analytics world by creating relationships between all of
those sources were able to analyze holistic performance across our entire data
model. And that’s a critical skill set for anyone working in data or analytics
or business intelligence it’s that ability to blend information tie sources
together and paint that comprehensive view of performance.
complex calculations using Data Analysis Expressions (DAX)
define complex calculations using data analysis expressions or that DAX formula
language. So we’ll be doing this to enhance our data sets and enables some
really interesting advanced analytics techniques using those powerful and
Visualize data with interactive reports & dashboards
important one we can visualize or data with interactive reports and dashboards
and what we’ll be doing throughout the course is actually building our own
custom business intelligence tools using power be best in class visualization
and dashboard features.
BI is the industry leader among BI platforms
last but not least, fact is power BI is the industry leader among other
Business Intelligence platforms. It’s intuitive it’s powerful and most
importantly it’s absolutely free to get started with power BI desktop.
vs. MS Excel
but not least just want to make a quick comparison between power BI and Excel
because there is quite a bit of overlap here especially between Power BI and
So let’s think of this like Venn diagram where you’ve got power Excel tools on the left you’ve got power BI tools on the right. And this area of overlap in the middle with features that both platforms share. So here’s kind of what it looks like.
summary you’ve got these Excel specific tools on the left like pivot tables,
pivot charts, power map, power view and cube functions and then shifting over
to the right side you’ve got the report, dashboard, views and power behind that
don’t exist in Excel.
custom visualization tools that we’ve been talking about as well as the
publishing and collaboration options available through power vs service.
the intersection part. These two tools are actually built on the exact same
engine. Power BI takes the same data shaping modelling and analytics
capabilities and then adds these incredible new reporting and visualization and
publishing tools on top of them.
though they’re called different things in different places you know that data
loading tools will be called either power query or get and transform and excel
the data modelling tools will be called Power pivot.
is it’s all the same thing. And the best news of all is that transitioning is
incredibly easy. These two platforms play really nicely together.
- Jay Charole
- Mar, 11 2022