SONIA: [MUSIC]
Now I'd like to welcome Microsoft
Power BI technical fellow Amir Netz.
Amir, thank you so much for being here.
I hear you're going to talk us through a new way
to create data marts in Power BI.
AMIR NETZ: Yes. Thank you so much, Sonia.
I'm really happy to be here.
Yes, Power BI is introducing an amazing new capability,
this build, which is data marts.
Data marts, that's something that everybody gets.
Data mart is where you go and
build a database to collect
data from all sorts of sources,
all at the departmental level,
done by people who are not
necessarily professionals and they
can go and cure the data and reach the data,
query the data, analyze the data,
all without really having major technical skills.
SONIA: Great. What are these new capabilities that
are being announced this year at Build?
AMIR NETZ: We are now allowing anybody who
has a power BI premium license to
go and create new data marts
directly within power BI with no extra cost.
It's a full-fledged relational database.
It's a SQL Server, SQL Azure.
It has the full power of SQL
and you just get it and you load the data.
It's very very easy to connect to
the data using power query.
It's super easy to query the data,
you can type SQL or you
can use the video query tools with park query,
or you can connect from your code to
the SQL Server using RTDs endpoints,
and then you can immediately go
and analyze the data using Power BI.
SONIA: Awesome. You said it was super easy.
You started talking about it.
But let's give a base level
what kind of dev skills do you
need to build a data model or data mart in Power BI?
AMIR NETZ: Well, it's really it's designed
for the full spectrum of developers.
We're talking about people who are
just basically advanced Excel users
who understand the concept of tables.
They can immediately start using
it because you don't need to know
any code and you can just provision it immediately.
The idea is to go to the Azure portal.
It's just like creating a new PowerPoint presentation
you create a new data mart.
Then loading the data is completely visual,
not a single line of code is necessary,
and then querying the data again, completely visual.
If you have no Excel, you're already at home.
But then if you are a full-fledged developer,
you like to code, you want to build an application,
then the APIs of the SQL Server are completely
there and you can build any piece of code
you want against that relational database.
SONIA: Oh, that's great.
Can you educate our audience,
we have some new people who
are joining Build for the first time.
Like you said, maybe there are
some new developers in the audience.
What's the main difference between
Power BI Pro Power BI Premium,
and then Power BI Embedded?
AMIR NETZ: Power BI Pro is our
basic entry-level offering.
It's great if you want to build the reports,
you want to build dashboards,
you want to do self-service,
analytics, building share among
your colleagues power BI Pro is awesome.
But if you want to get the advanced features,
this is where Power BI Premium is
coming in and this allows you to have
Power BI Paginated reports and allows you to do
complex data that allows you to do
these new data marts are all part of Power BI Premium.
The other part that is really
awesome about Power BI Premium with
the Power BI Premium capacity is the ability
to distribute reports freely to
anybody in the organization without
having to have power use licenses
for every person in the organization.
Then of course these Power BI Embedded.
Power BI Embedded is designed for
those developers who want to build applications,
full-fledged applications, and they want to have
analytics embedded into their applications.
It has all of the right API
to do customer authentication,
to have events that are flowing
from Power BI into your own hosting application.
All of that is just ideal for the developers of you.
SONIA: I love it. Any of Satya's announcements
today that really spoke to you that
you wanted to make sure our developer audience
was even more aware of and that you wanted to plug?
AMIR NETZ: The intelligence platform that
Satya announced where you bring
all of the data assets from analytics,
from the operational database for governance,
all coming together under one roof.
I think it's going to be transformational.
The announcement today is just
the beginning of a journey.
What we have in stalk in
the coming year, it's going to be amazing.
SONIA: I love it. I like how you're like,
I want to tease a little bit more,
but we got to keep everyone.
We got some more announcements in store.
I love it and I know like the metaverse and a couple of
these other huge topics AI
that we're able to talk about.
I'm excited to hear what you'll have to say
about this in the next Build, for sure.
Thank you so much for your time, Amir,
and for coming and talking to us
about data marts and about Power BI.
For those of you in the audience,
make sure you tune in and watch the demo at
the URL below to try out data marts for yourself.
Thank you again, Amir, for joining us today.