in this video we are going to talk about how you can publish the power bi report
to web version of power bi also we will look into how you can share this report
how you can export it to PDF ex etc and we'll just cover some other useful
features as well now before we start I want to show you quickly of one
important feature which is see right now what's happening is when I click on
electrical tickle whatever this customer it is just highlighting the revenues
from less in Mumbai so this customer has some revenue coming from Mumbai and not
poor market but for Delhi the revenue is zero but it is still showing the bar you
know sometimes you know it's useful if you see the if this Delhi is hidden
coach is hidden because those are not contributing those locations have
nothing to do with this particular client so there is a setting you can go
to file option in settings go to options and whenever it comes up so go to report
settings and you can click on let's see this one change default with dual
interaction from cross highlighting to cross filtering now when you do that
what's going to happen is let's see see now when we when I clicked on it actress
tickle it is showing only the relevant markets it it it is hiding now other
things and and this is applicable for the entire project so wherever you go
try to click on it for example products 0:40 is only selling in these four
markets okay so that was just a quick feature introduction now we are going to
publish our report yes so how do you publish the report well that is a big
button here when you click on publish it is going to ask you to login so what we
are doing is now the report is by the way power bi report
is nothing but this visualization this dashboard okay so don't get confused
when you say publish we are trying to upload this to cloud so let's say now in
AtliQ hardware there are 10 managers who wants to access this so that will be
this way where you publish it to a cloud version and they can login to that
website and they can just see this report here you have to login now you
need work email you cannot login using your own gmail ID so if you if any of
you have work email please click here need a power become try for free and
when you click that they will ask you for working mail guys so remember you
cannot login using your personal Gmail you have to have work email now if you
say oh I am a student I don't have work email then unfortunately there is no
there is no way there is one way actually which is you can buy a domain
for let's say 10 dollar and whenever you buy any website domain you know XYZ XYZ
XYZ com they will give you some email ID with that domain so maybe you can do
that so if you are interested just by like 10 or 15 dollar domain from GoDaddy
or some other website and use that email to log in here now I have already
created my account so I am gonna login using that yeah you if you don't have
the account of course you will click on that blue link that was below and you
will create a new account okay giving my password now I will
publish this report so I have already created this my workspace that's the
default workspace you have you can say select and it will publish it to there
so now you will so see this P bi X file it is uploading to the power bi web
version that I have now you can say open this in power bi so that's all now we
are in a browser see we are going to this website and you can now log in this
is a power bi website okay so while this is coming up I want to
show you two courses these two courses are free these courses are round acts
and data modeling so next is nothing but the language that power bi uses for
formulas and stuff if you remember in our power bi we use this formula you
know to transform the data to a clean up the currency to do the normalization of
currency and clean up the records which had sales amount to be like minus 1 or 0
so that language is nothing but a Dax and this is a great free course on decks
which I'm going to provide a link in the video description below so I highly
encourage that you complete this course it will teach you a lot about the decks
language okay so next language is basically let me just show you see this
formula each if what is this language so that is decks another course I want to
suggest is on data modeling so when we created our star schema where we had a
sales transaction table in the middle and there was customer entity tables you
know like customer product etc that is called data modelling data modelling
there is this great course again free course guys there are so many free
resources so follow that data modeling is very important if you are trying to
pursue a career as a data analyst so do that now my dashboard is loading so you
see now I have a same dashboard available in my web version so this is
great now if I log in to a different computer you know I can access this
dashboard let's look at some of the features so the first one is export so
let's say you made this report now you are going to some presentation and you
want to put this report in that presentation you can just say click
export PowerPoint or PDF and when you do PowerPoint you get something like this
see you got this report nice visual in PowerPoint exported you can also click
on this link and go to power bi directly also the PDF report looks something like
this it's just an image that it will export to PDF you can also save
different bookmarks let's say you are a regional manager covering Delhi in that
case you are only interested in Delhi's numbers you know you are only interested
in this graph so what you can do is you can say bookmarks I mean I have added
this but let me add a personal bookmark and I will say daily sales insights ok
let's say you are a regional manager for Mumbai then you can save this as a
mumbai says insights very good now when you have dashboard like this you want to
quickly look at Mumbai or Delhi insights you just go here and say ok Dell
insights see now it's just showing you Delhi you go here you say Mumbai says
insights and it's just showing you movement so these are just some quick
bookmarks that you can have you can also share this report with your colleagues
at work now this requires a power bi pro version which I don't have but you know
you can try it for free and just see basically I will just share this report
with all the regional managers in AtliQ hardware and then they can utilize
this report the next option is comments so let's say if I click on comments and
you know my data master group which is my data analyst they give me this report
and I want to have some discussion is like you know can I have a pie chart of
five customers and when you say post see now you can have a collaborative
discussion so if this this report is shared with less I am I'm a marketing
director and and this comment now will go to the data analyst and he will also
you know he will reply saying that yes I can have it maybe I need one week or
whatever two days okay so you can have a great collaboration going on here
through comments you can also just you know explore all these different options
now one thing is when this report is getting data from MySQL database which
is on my local system now let's say you see here you might see this thing data
updated six twenty seven twenty so this is not showing you data in a real-time
it's not like you know my MySQL database might have like ten new transactions I
want to see them so in that case what you have to do is you have to go to
workspaces my workspace okay so you go to my workspace you click on see there
are two things you see here there is a database so if you clear if click
refresh now it will just refresh this is like one time refresh but you can also
set up a shedule for the refresh and this requires setting up a gateway
connection etc and that requires its own tutorial but just to give you an idea
that you can refresh your database maybe two times refresh your power bi report
maybe two times a day with the latest data okay and you have to set up all
these things but I just wanted to demonstrate that all of that is quite
possible okay let's go back to our report now
also there is something called our report bookmark okay so did the bookmark
that I talked about earlier was a personal book man there is a report
bookmark so what is report bookmark okay so let's add it if you have to click on
edit this and then only this button will get enable and what you can do is let's
say I am Sales Director and I am presenting to the CEO of my company you
know see you of AtliQ hardware in that case CEO is interested in knowing the
different trends in Delhi Mumbai and Ahmedabad these are the two top top
three markets so what I can do is I can click on Delhi here okay I can say
report bookmark and this is of course Delhi okay so this is daddy then I can
have Mumbai so I can add Mumbai here Mumbai yes how about a meta bad I'm from
Gujarat by the way I am from Gujarat which enemy debod is a big town made yes
so now I have these three bookmarks so I can click on view
so here I can click on view and say full screen so this is short of like you know
presentation more so if I'm presenting against my CEO I don't need to make any
PowerPoint I can just go here and click on view and you see this is already
behaving like a PowerPoint so this is at the bottom this is daily market so that
i can talk about daily market how revenues are increasing declining this
is a interactive by the way so i can even click on 2020 i can show different
things and these are all for daily market then like powerpoint i can click
on the next slide so when i go next now I'm talking about Mumbai market you know
the revenue trends different years you know in Mumbai also see sales are
declining so my Cu wants to know why is that and then again click on next and
that is my Ahmedabad market okay so this way I don't have to take an image and
put it in my powerpoint presentation I can directly from here itself I can just
present there are so many other features which I did not cover which is let's say
you want to get an email every day at 5:00 p.m. on how your cells are looking
or let's say when when your business closes at for example 7 p.m. and at 8
p.m. as a Sales Director you want to get an email with the numbers on that day's
business you can configure that as well so power bi has a lot of useful features
which you can configure you can automate a lot of things in your business and
that is one of the reasons why tools such as power bi and tableau are getting
very very popular if you have any question please post in a video comment
below again do this course on data modeling and Dex the links for these
courses are available in the video description below thank you