| DAL4 A1.2 |
Forecast sheets can be used to create a future forecast based on existing data. In this case, we have a sheet with recent sales and we're going to try and forecast forward to see what the rough trend of data is, if the pattern of sales is to continue. To do this, we will highlight the data we want to analyze, click onto the data sheet tab, and then select the forecast sheet command. Here, it will display the data, giving us three very different types of forecast based on the pattern that we have seen. If we're happy with this, click create, and a new forecast sheet and forecast sheet chart are then created.
There is also a feature called 3D maps, where data from a table can be used to create charts based on a map of the world. To do this, we select a cell on our table, go to insert, select 3D map and then select open 3D maps. From the data that we have selected, we can see that it has picked up information in the UK. On the right hand side of the screen, we can see that we are looking at a stacked column chart, but we will change this to a bar chart. We can now add features to create the chart that we want to see. So at the moment, we can see it separating data by location. But what we would like to do is add height to each of the columns by dragging and dropping salary into the height area, and as we can see, different districts have different values. And we can now add a category of department into the category area. What this now does is to separate the bars into different colors based on the departments that we are looking at. This layer one tool gives us a legend so that we can show the data that we are interested in.
To finish off, firstly, change the data so that it shows as a clustered column so that each particular department salary values are separated. And then, we will go and display each person by date of birth and changes in salary over time. We can use a Zoom tool just so that we can see the details a little better in the UK area. Just remove that field list because we now have the data that we want. What I can do to demonstrate things is to say that currently, this is based on everyone who has a date of birth around, let's say the 26th of the sixth, 1993. However, we can use this slider to go back in time and display different data of different people as time goes by, until the point we have only one or two employees back from 1948. If we click the play button, we can see the number of employees slowly getting added over time and see the changes in the data.
A world-leading tech and digital skills organization, we help many of the world’s leading companies to build their tech and digital capabilities via our range of world-class training courses, reskilling bootcamps, work-based learning programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.