Ribbon Charts Hello and welcome to level five. In this level, we’re going to have a look at some of the other visualisations that we’ve not previously looked at. So, in level two, we had a look at the table visualisation. Level three, the matrix and the bar and the line charts. Level four, we’ve had to look at adding more control, more user interaction into your visualisations. So now, we’re going to continue to expand our repertoire of visualisations. So first of all, we’re going to create a line…

Tooltip Pages In the past few videos, we’ve had a look at things like drill through, which allow you to go to a secondary chart, and we’ve seen buttons and actions, which equally allow you to go to various links. But what if we wanted not to go anywhere but just to have more information to hand? Now, Tooltips are little pieces of information that come up when you hover over objects. And most of the time, they are automatically controlled. So, for instance, if I hover over this visualisation,…

Buttons and Actions Now, when you drill through, you are going from one page to another, and it’d be nice if you were able to go back to where you came from and you can do. There is a back button that gets added as part of the drill through. And if I click on this back button, you can see Ctrl and click here goes back to the previous page, and do that. We get back to our original page, but what if you wanted to make the option…

Use Bookmarks for Reports Right. I’m going to create a story line. I’m going to do a presentation. And I’m going to say, first of all, this is the overall picture from 1995 to 2016. Then, I’m going to look at 2000 to 2009. And I’m going to just show the Top 2 regions so I can focus on them. Then I’m going to talk about 2006 and then 2009. The problem with all of this is that, in a presentation it’s, yeah, you could sort of say, okay, I’m…

Slicer Warning Now, I do have one word of warning regarding slices. Let’s add a slicer. So, we add a slicer based on the date. I will use my Sync slicers and I will synchronise the matrix page to it as well. I will take this up to 2002. And we can see that the matrix is so affected. I’m now going to delete the slicer. So, you can see this slicer here, so this visualisation 1995 to 2015, 1995 to 2015 or 2016 even, go to the matrix. It…

2B3 Opening meeting Let’s look at the purpose of an opening meeting. The key purpose of an opening meeting is to confirm the agreement of all participants, the auditor and audit, to the audit plan. So in the opening meeting, both auditor and audit teams agree to the audit plan which have been issued to them earlier. Another important thing, what is done in the opening meeting? Introducing the auditor and audit team. We will talk about the participants of the opening meeting later on. But let’s understand that in…

Advanced Filtering In the previous video, we had a look at basic filtering. In this video, we’re going to look into advance filtering for text, numbers, and dates. So, advanced filtering for text gives you a few options. These are similar options you may have had in Excel. So, does the string contain or not contain the certain words or letters? Does it start with or does it not start with certain words? So, for instance, we can say, “Does it contain the word, or the letter W, say?” And…

Adding Text boxes, Images and Shapes Hello, and welcome to level four. And in this level, we’re going to be adding more control to your visualisations. Now, we’re going to start fairly easy. We’re going to add additional elements to your pages that aren’t actual your visualisations. For example, previously, we have got this item, this visualisation, which we can click on and it highlights individual elements elsewhere. And it also filters down on this table, but there’s no real way of knowing that without actually being a proficient Power…

Line and Area Charts, including 8b. Configure Duplicate Pages In this video, we’re going to have a look at all of the Line and Area charts. So, I’m just going to duplicate this. So, we name this page Line, or Area, and go back up to the top. So, Line and Area charts follow very similarly to what we’ve just seen in the bar charts. So, first of all, our Standard line charts. So, this is eachQ of the individual areas, not stacked on top of each other. So, you…

Bar Chart Formatting, Including Continuous Versus Categorical Axes Just a quick look at all of the formatting that you can do. So, you can change the X-axis, so you can have either Continuous or a Categorical type. So, you can see the difference. What this means is categories each year becomes a unique category as opposed to something on a scale. So, here we treating it something on a scale from 1995 through to 2015. Here it’s treating it like a category just like red, green, blue, or car, vehicle,…