 We're going to talk about introduction to visualization, overview of custom visuals, differences between custom and standard visuals. Then we're going to be talking about visualizations. I know a lot of us have used Power BI. No Power BI is part of the Microsoft Power Platform. On the Power Platform, you have Power BI, you have your Power Automates, you have your Power Virtual Agents, and you have your Power Apps. But today we're going to be focusing on Power BI, and we're going to be talking about custom visuals in Power BI. Now, visualizing data is one of the core parts and basic building blocks of Power BI. When you're creating visuals, this is one of the most effective way to find and share your insights. Today we're going to discover a variety of visualizations in Power BI, which will help us change our reporting game. What data visualization is actually the graphical representation of your data. You have your data and you want to represent it using pictures, chats, that is what is data visualization. This can be helpful when you try to explore the data sets, extract some information, to know more about your data set. Visualization can also help you in identifying patterns, corrupt data, add layers, and much. It also can help you to express and identify key relationship in plots and chats that might be useful to you and your stakeholders. If you notice why growing up, a lot of times we're all taught with things like pictures, chats, because they know that once a child sees a picture, it's easier for them to remember what has been told. That is that they see children learn by what they see, and not by what you do. When they see something, they always remember that thing. That is why visualization is important. It is more effective than text. Now, when people see data in a tabular form, it's always very, like I said, always skeptical, most times they don't really get much out of it. But when they see it in a chat, in a plot, it's always easier for them to understand. Today, we're going to talk about some custom visuals in Power BI. Now, one thing you should understand is, it is very important we have to make a distinction between a report designer and a report consumer. So if you're the person building or modifying the report, then you are a report designer. You know, it is the designers who have permission to edit the report and the underlying data sets. Then if you're someone who a report has been shared with you, you are a report consumer. So the only thing you'll be able to do is just to view and interact with the reports and the visuals in it. But you're not able to make as much changes as the designer. So when a designer is creating a report, they need to understand the audience. What are you trying to communicate to your audience? Do you want them to understand some certain things? Okay, I want them to look at this my chat. I want them to get this inside at a glance. They should be able to understand what I'm trying to tell them about. So that is what we're going to be doing today. In Power BI, there are actually many visual types available, different types of visualization from your visualization pane. But there are actually two groups of visuals in Power BI. So you have your standard and your custom visuals. You have the standard visuals and your custom visuals. So your standard visuals are the ones that are available in Power BI by default. So if you open your Power BI desktop, you go to your visualization pane. You discover that there are some visuals that are there by default. Those visuals are called your standard visuals. So currently, there are about 40 standard visuals present in your visualization pane in Power BI. Why your custom visuals are those ones that need to be imported before use? So any visual you're importing from somewhere, maybe you created a visual by yourself, if you're trying to import it, maybe from the Power BI marketplace or App Store, that is a custom visual. So those ones are out of the box visuals with additional features. So currently, there are more than 300 in the Microsoft App Store or the Microsoft Marketplace. So we're going to be talking about some custom visuals today. And we said custom visuals are the visuals you get from your Power BI marketplace. And we have some standard visuals. So if you look here under your visualization pane, you can see we have some standard visuals here inside this one. So these are the visuals that are there by default from Power BI. And if you can see underneath here, I have some other visuals there. So these are some custom visuals that I got from my Power BI marketplace or the App Store. So the first one we're going to be talking about is the Zebar BI table. We're going to talk about the Zebar BI tables. Now the first thing you should note is when you want to get a chart from the Power BI marketplace or from the App Store, you have to go to your visualization pane. So if you have your blank Power BI file open, you can just go to your visualizations. And you can see here under your visualizations pane, you have three ellipses here under your visualization pane, three ellipses today. And you can see what it says. It says get more visuals. So if I click on get more visuals, I can see different options here. I can see get more visuals, import the visual from the file, remove a visual and to restore them back to the default visuals you have on in your Power BI desktop. So I'll just click on get more visuals. Click on get more visuals. And once you click on get more visuals, it takes you to your Power BI marketplace or your App Store. So you can see Microsoft App Store. And you can see you have a lot of visuals here, a lot, a lot of them, but I'm going to choose to just show you the 10 that I love the most, the 10 which will help you change your reporting game. So if you just go to search, you can see it's also filtered. You have it by analytics, advanced analytics, change over time. You want to do a visual that you want to tell your story that tells change over time. You can go to the change over time field that you have by filters, you have by infographics, you have by KPI, and you have by maps. So if you go to search, and I say I want to just search for Zebra BI Table, that Zebra BI, you can see we have about three. You have your Zebra BI Table, tables, your Zebra BI cards, and your Zebra BI charts. So if you want to bring it in, the first thing you do is you click on the particular visual you want to use. So if I click on it, I can just click on it, and you can see. So one thing about your app source is to tell you the visual which you're going to pay for or the one which is free. So now you can see underpricing, if you come underpricings, you can see additional purchase might be required. So for visuals that you want to use and they're not actually free, you might need to purchase them after maybe you use them for like 30 days free trial. You have to now start paying for it. So what you just do is when you've looked at it and you see, okay, I love this visual. I want to use it for my reporting. You just go to add. So you click on add. But since I already have that visual there, it's just going to tell me this visual already exists. I can just decide to click on updates or I leave it like that. So let's just bring one which I currently do not have here. Let me bring one which I currently do not have here. And that one is called the animated bar chart rate. So I'll just type it here, animated. And you can see it's already here. So if I click on it and I'll just click on add. So once you bring it in, it's going to tell you cause the visual was successfully imported. Can you see I have this message up here. The visual was successfully imported into this report. So for this, I'm going to tell you 10 custom visuals that are going to change your Power BI reporting game. You can just take them down. You write the Zebra BI table. You have the Zebra BI chart. You have the Zebra BI card. You have your world cloud. You have your scroller. You have your play axis. You have your ultimate KPI card. You have your infographic designer. You have your chicklet slider. And you have your tornado chart. So one thing about the Zebra BI table and chart and card, they try to create a standard. They try to create a standard for you when you're reporting. So let's, they try to create a standard. So when you're reporting, there's something that happened. If you go online and you check for financial reports, if you go online, you go and check for financial reports, financial report dashboards. You see that we have a lot of dashboards there. There are a lot of dashboards. And when you're looking at it, there's really no standard. If someone looks at this dashboard and they're trying to get maybe an information from this, today I will see a dashboard and I have green colors here. I have blue colors here. And someone is telling me, okay, this is representing profit. This is representing loss. And tomorrow another report designer, because we said report designers are the ones that create the reports, if you remember. Another report designer will come with a report and then you have your profit there, showing let's say purple and showing your loss at green. So there's really no standard when reporting. But we notice in other disciplines, when they are creating reports, maybe financial reports, they have a standard for reporting. So the Zebra BI chart, the Zebra BI chart follows a standard reporting. For music, you can see there's a particular theme, even for architecture. Once you send a construction plan, everybody knows what they want to do. You send it to different places in the world. They know what they want to do. So what your Zebra BI chart does for you is, it shows you that your actual is actually your solid field. Your previous year is light. Your expected data, your forecast is actually hatched and let's say your budget or your plan should be, let's say A, an outlined color. So now let's see what we can do with it. Let's see what we can do. So now we're going to Zebra BI tables. Let's go to Zebra BI tables and we've brought it in and this is our Zebra BI table. This is our Zebra BI table. This is our table. And let's assume we want to plot something. Let's say our revenue sum by, want to check our revenue by market and want to compare it over previous year. Let's try it, let's bring it in. This is our chart. This is our chart. And let's say we want to compare it by our revenue sum. So let's bring in our revenue sum and then let's say our revenue sum, our revenue same period last year. And let's say we want to compare it over our markets. Let's put it over our market. So I'm going to make this in the focus mode. So now looking at this chart, you can already tell that, okay, this is our previous, this is actually our actual. So from this Zebra BI tables, which is the first thing we just did now, we can tell that, okay, with this chart, once you just hover around each of them to tell you, okay, our actual, what we currently have now is 59, 5.9 billion. And what we had our previous year was 2.2 billionaire. And what is the change? We actually increased by 3.7 billionaire and what is the percentage increase? Increase, sorry, it's 10 us 1.169.5%. So this Zebra BI tables is actually changing your reporting. So once someone sees this, they already know what you're actually talking about. Look at it. So here it's already showing that it's green. So if we are running at the loss, you have seen that this color here for the change is going to be like, let's say a green, but we can see that now we are making profit. So this is what Zebra BI tables can do in your reporting. It's going to make your reporting more understandable. And people are going to be able to understand what you're doing. Let's go to the next one, which is Zebra BI charts. Zebra BI charts. So let's go to the card visual. So this is our Zebra BI card visual. So this is not like a normal card visual. If you look at it, you have it showing you your total revenue sum here. So you can see your revenue sum by your transaction count and it's showing you how it's changing over time. So this is the difference between your printers and others. And as it goes, it's showing you, okay, this is your transaction count. This is the revenue you made. So your total revenue was 8.8 billion error. And the transaction count actually for parts is 14.7K. So that's like 407,000. So now what did you change? It's telling you what it's, how it's increased and the percentage increase. So this is what your Zebra BI card visuals can do. So this is your card visual here. So let's say, okay, we want to check it by something else. So let's say, let's remove our transaction count. And let's say we want to see by our same period last year. Okay, it's already there. And you can see what the card visual is already doing for us. It's already comparing what you have currently and what you had in your previous year. You can see it's showing your revenue sum currently is actually 6.2. Let's see, that's for printer sales. That's for printer sales. It's telling you that this is what you have for printer sales, that your revenue is this, 6.4 billion. And what you had same period at this time, at this time last year, what you had was 2.3 billion. So this is what your Zebra BI card visual will help you do is to make your reporting more understandable. So when you're working with Zebra BI, it's going to make your reports more understandable. So now let's go to the card visual. So I think it's coming up. Okay, so now this is our Zebra BI card visual. So it's almost like the Zebra BI tables and card, but one thing is that they have a standard. So anytime you see green, you know you're actually making profits. Anytime you see black or like a full color, you know if you're actual. So this is going to help you change your reporting game and make your reporting more understandable and people to get more insight from it. So now let's go to the next one, which is your world cloud, which is your world cloud. So your world cloud is actually a text analysis chart. So it makes you to understand more. So when you look at this, your world cloud here, this is your world cloud. So you can just go to the marketplace and get the world cloud. It's showing you the particular region. So when you look at it is analyzing what you have. So here what we put is we have our markets and our revenue sum. So it's telling us that the markets with the highest revenues, equity, because you can see from the text analysis, equity is the one that looks like it's bold that is large. So if you look at it, you can just over around it and you can see it to give you the particular revenue for each of them. You can see for buy outside and for equity. It is showing you what you have for equity. If you go to Abia, it's showing you the revenue for Abia. So if you go here, get more visuals. So if you come to world cloud, you can see all the visuals you want to. So if you go to your Fabia marketplace, can you see once you search there, you see all the visuals we've mentioned. So we've talked about world cloud. So let's go to scroller. Let's go to our scroller and see what scroller can do for us. So this is your scroller. So let's just click on our scroller visual. And one thing, when you want to bring a visual in, you have to select from your fields pane. So you can see what we selected for this. We selected our store. Want to see our store by revenue. And what we had our same period last day, if you're comparing it by same period last day. So this is what your scroller is doing for you. So your scroller visual makes it possible to create animated scrolling text from your measures and your dimensions. So it is useful when you're displaying a dashboard on a light screen in a meeting or in a production flow. Since it is constantly moving, you're seeing that it's constantly moving, it will catch the viewers. I am made the reports come to life. So once someone sees this now, they're already seeing, okay, this is Bauchi. This is what we made. And this is what we had our same period last day. So this is what your scroller visual and how it can bring your reports to life. Let's go to the next one, which is our play axis. These are our play axis. So while it's coming up, your play axis is perfect for reporting. When you want to show your report, you want to click at every time. You want to see the changes in the value over a period of time. Your play axis is the best visual for that. It helps you to see trends and look for patterns in your data. So once you go to your app source or your Microsoft Power BI marketplace, once you just check for play axis, you're going to see your play axis and then you can now import it and use it for reporting. So let's look at the play axis. So here we use our play axis and we brought in our month. So let's just try it. So let's say this is my play axis, I've brought it in and I want to put some fields in it. I will just go to my D calendar and now tick my month in. Once I tick my month in, I want to see how this my report is moving over different months. So once I click on play, you can see it's moving over time. Even now your KPI visual is moving, it's showing you, okay, July, this is what we have in the month of July, the month of September, the month of October, November, December. This is what we had over a different period of time. It showed us the patterns in our report. So let's go to the next one, which is our ultimate KPI card. Our ultimate KPI card. So this ultimate KPI card, which is this visual, let me put it in focus. So if you search in the marketplace, you're going to see it also. So this visual allows you to show a value, it's various to a reference value and it's various to the second or the third value. So it also shows you absolute and in percentage with arrows and color indicators. So if you just have your mouse around it, it's telling you, okay, what are we trying to look at here? The category is service plan. And this is the revenue generated for service plan. You look at it. This is the unit sold we have. So absolute number of units sold is this. The percentage is this. So this is the transaction count same period last year. So this is your revenue same period last year. It's trying to show you, okay, in all what we did here for service plan, we actually made profit. You go to copy our sales. It's actually telling you, giving you more information. So once you're using this for reporting, it's going to make your report look very interesting and a lot of people will want to, we look forward to your reporting in maybe your business meetings or your presentations. Even your stakeholders are going to like it. So the next one we're talking about is your infographics. Infographic designer. So when a report designer is telling you something about reports and they are saying, okay, I want to tell stories with data. So if telling stories with data was a chat, this is what it is. So this visual is very, very interesting. So this chat allows you to control the specific appearance of your line, your bar chat or calling chat in different shapes, colors, layout, which will represent your data and tell it in the best way that people will understand. So now we are talking about region by revenue sum here. So we can see this region. So we just use this picture. So assuming maybe you work in a plant or a manufacturing industry and you want to change it. Okay, I'm using this because maybe I'm trying to represent regions. So what you just do is you come to the pen. So let me close this. You can see there was a pen here, which is to format. I'll just come to this pen and I'll click here, which is to insert shape. I want to change the shape. I can just come here because I already have this and I'll just delete this and I'll go to shapes. You can see on that the shapes, you can use different ones. You have business and tech. You have food and drinks. You have household, nature, people, transportation. And then you can also upload your own to make your visual. Maybe you want to give it your own storyline. So for example, now what I use was under nature. You can see it here, this tree. Let's say I'm working for a food industry and they want to see the region that gives the highest let's say drink. I can just decide to use maybe you create drinks or anything, let me just use this bottle. So you can see this has already changed your reporting game. Once someone sees this, they already understand, okay, this is what this person is trying to talk about. The person is trying to talk about drinks. So you can see for not this region, this is the revenue generated for Southwest. And you can see the low West, which is your North Central. So if someone is trying to talk about, okay, why is that North Central, we have the list. So we already know that, okay, maybe because of the crisis arising, the North, nothing part of Nigeria, that is why we have the least what revenue coming from that particular region. Then the next one we go to is the chiclet slicer. So I really enjoyed this because of simplicity. So this is made up of buttons and it has different looks from your standard default slicer that you have in Power BI. So you can also include images instead of button and you can use this to filter. So let's just try this. So this is just like a button. I click on me and you see my report changes. I click on January, my report changes. I click on February, my report has changed. Now I'm not able to slice at once for January, February and May. So you're not trying to say, okay, in January, February, May, this is what happens if I just click and then we can just see for February. So let's go to the last one, last but not the least, which is our tornado chart. So you can also go to the marketplace and get it in our tornado chart. So these are tornado charts. So this tornado chart, this is a special type of bar chart where your categories are listed vertically instead of your normal standard horizontal view. So it's majorly used to depict the sensitivity of the results to select, to change this in a selected variable. So now we're looking at our model. So we put our, yeah, as our legend. So our comparing it over two years, which is 2014 and 2015. So the values we put our revenue and our values and then our group we put our model. So in our model, we have different models. So now we can now see over the year 2015, you can see here under our legend, we're able to tell the different years. So you have 2015 as the green and you have 2014 as the purple. So if you go to about 2014, we can see for our model, 2500 C, we can see the revenue generated and we can now compare it with 2015. So we can see that in 2014, we made more revenue from the 2500 C model. So now you'll ask the actual questions. Okay, when we are comparing it, why is it that we are not making as much as what we did last year? In 2014, we made more, but in 2015, we are losing. So now I have to compare. Okay, maybe it's because we've not gotten to the end of the year. That's why it looks like about 2014 is currently bigger than about 2015. So these are some things you can, some custom visuals you can bring in that will change your reporting game. So I hope you really enjoyed this webinar. So you can always reach out to us. via our LinkedIn pages. You can also share the data set with you so that it can also work on it. Then if you ask, if you have questions, just reach out to us via our Twitter page, our LinkedIn and our Facebook page. And we'll also guide you through this and then we'll also share the video for this webinar with us. So thank you everyone. Hope you enjoyed our webinar. Thank you.