Course:
Data Analysis 2025 (Batch A)
A slicer is a visualization tool that allows you to filter and manipulate data in a dashboard. Slicers are often used in conjunction with PivotTables and Pivot Charts. They’re essentially interactive filters that allow you to quickly narrow down the data in a dashboard to just the information you need. For example, if you have a PivotTable showing sales data for all of your products, you could use a slicer to just show the data for a specific product category.
Creating a slicer
Click on any of your visuals and go to insert and click slicer icon, it will give options of list of items to create a slicer for, select the items you want to create slicers with e.g products, year and region, go to slicer setting and format it to the color of your choice.
Right click all the slicer and click report connection and tick all pivot table to link all the visuals together.
CORRELATION
Correlation analysis measures the strength and direction of the linear relationship between two variables. It gives you a correlation coefficient (usually “r”) that ranges from -1 to 1. The closer the value is to 1, the stronger the positive correlation is between the variables; the closer the value is to -1, the stronger the negative correlation is. However, correlation analysis doesn’t tell you why two variables are related.
v Positive Linear Correlation. There is a positive linear correlation when the variable on the x -axis increases as the variable on the y -axis increases.
v Negative Linear Correlation.
v No Correlation.
Ø Positive correlation
Any score from +0.5 to +1 indicates a very strong positive correlation, which means that they both increase at the same time. The line of best fit, or the trend line, is places to best represent the data on the graph. In this case, it is following the data points upwards to indicate the positive correlation.
Ø Negative correlation
Any score from -0.5 to -1 indicate a strong negative correlation, which means that as one variable increases, the other decreases proportionally. The line of best fit can be seen here to indicate the negative correlation. In these cases, it will slope downwards from the point of origin.
Ø No correlation
Very simply, a score of 0 indicates that there is no correlation, or relationship, between the two variables.