- 6/1/2025
END TO END REPORT ON POWER BI MAVEN PIZZA SALES POWER BI
Category
📚
LearningTranscript
00:00so now friends so this is the second part of our of our marble pizza seeds so in the first part
00:22we have added some write some functions and beside that we have created some report here using like
00:33created some report but here we have added some more things like number of order we have but here
00:39we add like average order price average price and count of category we have added all these things
00:46beside that like we have what are our top 5 pizza quantity by by quantity top 5 pizza by quantity top
00:545 pizza by sales bottom 5 pizza by quantity and bottom 5 pizza by sales and beside that like these
01:03two we have already added and beside that we have size and size by sales so let's see our last report
01:10so this we already have and now we will add some more things here from here like we see what we
01:18have added these all things average order price average price count count by category and this
01:26bottom top bottom bottom and bottom prices are and beside the size by quantity size by sales okay so
01:35to do that we go to our report first this is our last report and what I will do like I will increase
01:42the size a bit so I need some more sizes so that we can have more idea so I click in the blank area then
01:51I will go to my properties I think I haven't here is the area then I will go to effects I will click here
02:04that's okay now I will go to the canvas setting so we have to click on the blank area and from here I will
02:13put it somewhere around the year 1500 that's okay and here I will put a 2500 so I think or either I will put
02:30here 3000 so now I think this okay so that we can have more charts here so for that first of all we
02:41will add our DAX functions I will just make it somewhere and make it a bit okay like this is okay now so now we can
02:58add more chart here this is here and I will put it totally need a one side I will just make it a little
03:09bit that's okay and put it here and then I will put this here now we have some spaces for our chart and what
03:24I will do I will do I will just increase I will make it three thousand two hundred now it's okay okay
03:40and just do it this way do it and put it down so that we can have more charts in our area and we will put
03:53those chart in that area now it's okay I will just click over this and clear selections okay so now first of
04:01all what I will do I will write some DAX functions I will write some DAX function here and here like the
04:10color is not okay so I will change the color also I just change the color so I will go here in this slice
04:18or is okay journal effect I will take some other color like this color is okay nice so we can see
04:28the chart all the all things there now what I will do I will first of all write a DAX function to write a
04:34DAX function I will go to home and from here I will write a new measure
04:39and a new measure what I will do I will just increase the size and here I will write the function like I
04:56will write AVB RAGA average price what is the average price of our sales so equal to I will write calculate and in
05:07this calculate I will sum first of all I will sum our order retail sales order and I will just go down
05:19and see where is the sales so here is the sales order retail sales I take and close this and then
05:27I will press enter so that I can go to the next line and press this button here like this slash sites
05:36because we are dividing it with some then I will open this and this time I will take order I will take
05:50order quantity so I have to just find various other quantity here here is our quantity and I will click
05:58over this and see like whether we will find average price or not so we have an average price here so I
06:09will go to again so I will just close this close this DAX and here I will create an another card I will
06:18just copy this and paste this control C and control V so that we have two cards here and in this new card what I
06:31will do I will take our average price so now we have an average price which is 16 so we have right to DAX function
06:40for that next I will take another card for that I will just take a new measure I will just copy this before and this time we will take our average order price like how many orders we have and what are the average price of per order for that again I will go to new measure
06:58and in new measure we will write another function I will just increase the size here and give it in a name
07:09average order price then I will put equal to then I will write calculate then after that I will put some
07:23bracket open bracket open bracket open first of all I will take order sales so I will take an order sales here I'm not finding it let's see where it is here is order sales so first of all whatever sales we have at total sales then I will close this then I will divide it with our count of our order IDs whatever ID like we will count them
07:53so how many order IDs so how many order IDs because we will not sum them because it will sum them like they are numbers so they will be in big one number so I will just to count our order IDs and just click over this so I will count our order ID so that we can know like how many numbers of count so it will count them
08:15so count all the order IDs and just make a function here then I will just close this and here I remove this and take our orders so we have average order price also so we have used certain functions and make it this way we have created our some information regarding our average order price next thing what we can do
08:43we can do like if we will go to our report again and see what next thing we can do we can find our size by quantity whatever size by quantity size by quantity like which size of pizza we sales more quantity by sales more for that what I will do I will go here and put a bar here
09:09and in this bar I put first of all in next axis I will put your size we have to find out where the sizes in pizza type we don't have size in pizzas might we have size so we have size in here I will put size in x-axis and our
09:37first of all first of all first of all first of all I will take quantity and then I will take quantity and quantity in our x-axis I think we have taken we do not have to so count these things sorry we will take quantity in x-axis y-axis sum of the quantity and then our size we will take
10:04very size we have to find it out size size we have to find it out size size in pizzas we have size and size is number y-axis so now we have size y-axis bar graph so which size like we can do some formatting here we will go to journal title and title we will list sum of quantity by quantity by size I will put and make it 35
10:32and fold and fold and put it in the center and other things we can do we can do column is there spacing data level if you need we can put but it is not emoking and we have to just go through and make some changes here
10:53y-axis y-axis is there so I will just increase this to 22 and bold or either I will make it 32 and bold then I will go to x-axis and values I will just increase this to again 35 here I will give and bold so the picture is more clear
11:20so basic is auto I will take none now we have this chart quantity and if you want to see it by increasing the size I will just remove this and now if you will see it by increasing the size so we can say so our large pizza is having the most sales by quantity so we have best sale by our quantity if I will copy this I will just copy this and put it somewhere here now
11:49and then I will go to our visuals and in place of sum of quantity and now I will take sales and just change the name of our chart here sales by size so we have two reports to see like whatever our sales
12:19sales by size and the next is our sales by size and the next is our sales by size so we can find out with this way and next is like we can create a table where we can find out the top 5 sales of our pizza and top low sales of our pizza
12:39so we can also do that so we can also do that so we can also do this now so I will create a table here blank table first of all and then we will take here first of all our name so name is our sales name of pizzas and then I will take here sales sales is here
13:07now we have a big list now we have a big list like we have many types of pizzas and I will go there and what I will do I will just increase the size of everything here
13:19journal visuals values so formatting will take some time 32 now I will open this filter
13:31filter and in this filter and in this filter in place of name I will take your I will click over this and take top end so we are taking the top topmost so how many top I will take 5 and what is by what mean you will like to buy sum of sales by sales so I will put here sales
13:55in values I will put sales and then I will play apply so now it will see so as only the top 5 pizzas by sales so we have a top size top size so we have here and if we will go there and put there like in journal in titles I will put the title also
14:18top 5 pizza top 5 pizza by sales I will put everything in capital by sales and just increase the size to 44 and bold it and then center it so this will look better and we can find out the report of our top 5 sales
14:47next I will copy this next I will copy this and here this time I just increase the size also I think the size is a bit small I go there in canvas setting and just increase it to 4000 now it's better and from above I will put it 2000 so now we have a bigger size so we can have more reports in better you can do it
15:17step by step by step step by step here now it's look we have to increase the size also
15:25I will go here format formatting is done and increase the size also I will put it like this
15:39now it's okay now it's okay okay and increase the size also and this much we can also increase
15:54so that we can do but before that what I will do I will just change this name here spelling mistakes I will just change the spelling title
16:11sales okay and this time here top side by not by sales and this time I will take by QTY quantity
16:23so here I will put quantity here in sales and what I need to do here is like in place of sum of sales I have to take quantity so I have to find where is the quantity quantity here so I will take quantity here and in filter also and in filter also if I will go to filter I have to change like here is the filter one in sum of sales we have to take quantity so because we have to find out
16:51according to top five by quantity so I just remove this and just apply this quantity here so now we have quantity wise and our sales wise top five name of our pizza now what I what we can do we can also create a report where we can I will first put it here and this one is just below this
17:19below this
17:26formatting will sit sometime this is the only thing which we have to do I will put it here and that much here and then
17:38okay that works
17:45next thing is like we can put pizza by bottom five so bottom five what I will do I will just copy this
17:53ctrl V and here for bottom I will go to the report here again and in place of our top we have to take the bottom
18:05bottom so click over this and we will find out where is the bottom pop and basic filter is there I will just remove this first and from here I will take bottom five and here I will put your first of all I will put quantity
18:24because we are taking the quantity and apply filter and apply filter so it will show us bottom so we have to change here in general also bottom five and press enter so this is for bottom five then I will copy this again
18:43this pizza sales and copy this and here we can take our bottom five pizza by sales and here we can take our bottom five pizza by sales so we will go here and in place of top
19:02it's okay top 10 but here we have to take bottom and here we have to take bottom and sum of sales is okay and apply then we will go to this visualization again in general and we have to put it like bottom
19:24so now we have to put where we have top five top five pizza by sales top five pizza by quantity top five pizza by bottom five pizza by quantity bottom five pizza by quantity so we
19:39can compare like which we are selling more and which we are selling less which quantity we are making besides that we have report here also sales by size also like which size
19:50size of product we are selling more and like which size of quantity by size we
19:57are selling more decide that we have a heat map which shows us where we are
20:02selling at what time we are selling the most and we can do more editing here the
20:07editing is the only issue otherwise we are ready with the product we can do in
20:12more editing and make it more beautiful and I will do it in the next part and
20:17see like whatever is there we have already made it or not so we have
20:21created all these things here and one mode is count of category we can also
20:26take so for count of category I will just copy this chart and put it here and
20:34count of category we will go to categories and we just open this visualization and
20:42here we will take category so first category instead of first category we
20:48click over this button and say count distinct category and then we can save
20:58this so that's all for this part next part we will do more things
Recommended
0:53
|
Up next
0:40
0:15
21:04
5:31
16:56
15:41
7:43