But there is one crucial part we often don't invest in sufficiently. The actual output that is almost singularly responsible for driving the change we want in our organizations. The thing that is the difference between an organization that data pukes and the one that influences actions based on understandable insights. I believe we should present our data as effectively as possible in order to first build our credibility, second to set ourselves apart from everyone else who can present complicated graphs/charts/tables, and third allow our leadership teams to understand the singular point we are trying. A vast majority of occasions where data is presented (reports, executive dashboards, conference presentations, or just plain here's a automated emailed thingy from google Analytics ) end up being abject failures because most of the discussion is still about the data. And if you are sitting in a nth level tactical meeting, that. But if the occasion is a strategic discussion, any occasion about taking action on data, then you need to get off data as fast as you can.
PowerPoint, presentation - id:343361
#4 Add context to your autism chart Different people analyze and interpret same chart differently. It all depends upon the context in which they analyze and interpret the chart. No matter what chart you select, some people will always find a way to misinterpret your chart. Therefore it is critical that you provide context with your chart in the form of written commentary and describe exactly the intent of your chart. First present the context, then the insight and then the chart to support your insight. In this way you are giving clues to your chart reader regarding how to read your chart. For example: you can learn more data reporting tips from this articles: How to become Champion in Data reporting. There are three elements to our "big data" efforts, or unhyped normal data efforts: Data collection, data reporting, and Data Analysis. (More on that here: dc-dr-da: a simple Framework for Smarter Decisions. we are all aware that the best companies in the world have an optimal dc-dr-da allocation when it comes to time/money/people: 15-20-65. All well and good.
The majority of people have no idea what you essay are trying to communicate via these charts. Use these charts only when your target audience is as data savvy as you. Best practices for designing column and line charts #1 Start the yaxis value at zero When you do not start the y axis value of a chart at zero, the chart does not accurately reflect the size of the variables (in case of column charts) and. For example, following column chart amplify changes because the y axis value start at 440 instead of 0: Following is the correct column chart: Another example. Following line chart amplify the growth of Facebook fans because the y axis value start at 2500 instead of 0: Following is the correct line chart: #2 do not use line chart (to create trends) if you have less than eight data points When you create a line. For example, following line chart just contain two data points and as a result it makes the growth look phenomenal: For a line chart, the more data points the better. #3 do not hide the scale on the y axis of a column/line chart When you hide the scale of the y axis, your chart wont accurately reflect the size of the variables (in case of column charts) and trend (in case of line charts). Without any scale on the y axis, there is no way of knowing where the y axis starts from. When you use such charts it create doubt on your analysis.
The multi-channel conversion visualizer chart used in google Analytics to visualize multi-channel attribution is actually a venn diagram: In the context of web analytics, we can use a venn diagram to determine whether or not a website has got attribution problem. If there is little to no overlap between two or more marketing channels then the website doesnt have attribution issues. If there is a good amount of overlap then the website has got attribution issues and you should seriously consider taking multi-channel attribution into account while analyzing and interpreting the performance of marketing campaigns. To learn more about attribution modelling read this article: Beginners guide to google Analytics Attribution Modelling Another great use of Venn diagrams is in visualizing the back links overlaps between websites: The tool that I have used to create this Venn diagram is known. Note : you can create a venn diagram in Excel. Check out this tutorial on Microsoft Office website: Create a venn diagram Charts to avoid for reporting purposes Throughout this article I have talked about the charts that should be used. But there are some charts which should be avoided for reporting purpose unless your target audience is as data savvy surgery as you. Following are those charts: Treemap Waterfall chart Radar chart Bubble chart The reason you should be avoiding reporting data via these charts to your clients is simple.
However if there were more than four categories to plot, like eight or ten categories, then the pie chart would have become cluttered and hard to read. For example following pie chart looks cluttered because it has got too many categories: #3 Use a pie chart to show data composition only when the pie slices are of comparable sizes. In other words, do not use a pie chart if the size of one pie slice completely dwarf the size of the other pie slice(s #4 Order your pie slices in such a way that as you look clockwise from top to bottom, the biggest pie slice. This makes the pie chart easy to read: These pie charts are made from following data: In order to create a pie chart where the biggest pie slice comes first followed by second biggest pie slice and so on, i have sorted the data in decreasing order. When to use a stacked area chart Use a stacked area chart when you want to show the trend of composition and emphasise the magnitude of change over time. For example following stacked area chart shows the breakdown of website traffic: When to use a histogram Use histogram to show frequency distribution for quantitative data: Note: you would need to install the analysis toolpak in order to create histogram in Excel. When to use a venn diagram Use a venn diagram to show overlapping of data.
Data analysis and presentation
If you want to visualise just summary one type of data and it contains a numeric value which does not fall in any range/interval then use the number chart: When to use a gauge chart (also known as speedometer chart) If you want to visualise just one. What that means, as the value of the variable x increases there is a corresponding increase in the value of the variable. #2 Create a scatter chart only when there are ten or more data points on the horizontal axis. The more data points the better it is for a scatter chart. Conversely just a few data points (like five or six data points) are not good enough for creating a scatter chart. #3 Use a scatter chart when you want to show why.
For example: why revenue is correlated with average order value or why conversion rate is correlated with number of transactions. When to use a pie chart #1 Use a pie chart when you want to show 100 composition of data. In other words the various pie slices you use, must add up to 100. What that means, do not create a pie chart where the various pie slices do not represent parts of the whole pie. For example, following pie chart is not a good representation of data composition as the two pie slices add up to 82 and not 100: #2 Use a pie chart to show composition of data only when you have got one data series and less than. For example following pie chart shows the breakdown of a website traffic sources in the last one month: Here i have got only four categories (search traffic, referral traffic, direct traffic and campaigns) to plot. So pie chart is ideal to show the breakdown.
So if the values of one data series dwarf the values of the other data series then do not use the column chart. For example in the chart below the values of the data series Website Traffic completely dwarf the values of the data series named Transactions: #4 Use a clustered column chart when you want to show maximum and minimum values of each data series you want to compare. #5 Use a clustered column chart when you want to focus on short term trend (i.e. Changes over days or weeks) and/or the order of categories is not important. Breaking a clustered column chart The chart below contains 11 data series and is very difficult to read and understand: One method of making this chart easier to read and understand is by breaking it into several smaller clustered column charts.
For example, you can create one column chart which just compare the sales performance of various countries in January. Create another column chart which just compare the sales performance of various countries in Feb and so on: The rule of thumb is to avoid presenting too much data in one chart, regardless of the chart type you use. When to use combination charts A combination chart is simply a combination of two or more charts. For example the combination of a column chart with a line chart. I use combination charts a lot and I think you must know how to create them as they are very useful. Following is a short video on creating a combination chart in excel: #1 Use a combination chart when you want to compare two or more data series that have different units of measurement: #2 Use a combination chart when you want to compare two or more data. Changes over several months or years) between the values of the data series: #2 Use line charts when you have too many data points to plot and the use of column or bar chart clutters the chart. #3 Use a line chart instead of clustered column chart if the order of categories is important: When to use a number chart?
Statistical presentation and analysis of ordered categorical
For example: Very satisfied, satisfied, Unsatisfied, very unsatisfied or Strong dislike, dislike, neutral, like, strong like when to use a clustered column eksempel chart #1 Use a clustered column chart when you want to compare two to four data series. In other words, avoid using column charts if you have just one data series to plot: Alternatively, avoid creating a column chart which has got more than four data series. For example following chart contains just five data series and it has already started looking cluttered: The chart below contains 11 data series and is very difficult to read and understand: If you want to create a column chart which contain lot of data series then you. #2 Use a clustered column chart when the data series you want to compare have same unit of measurement. So avoid using column charts which compare data series with different unit of measurements. For example in the chart below Sales and roi have different unit of measurements. The data series Sales is of type number. Whereas the data series roi is of type percentage: #3 Use a clustered column chart when the data series you want to compare are of comparable sizes.
For example 10 customers, sales, roi, weight etc. Qualitative data is the data that essay can be classified/categorized but it can not be measured. For example: colours, satisfaction, rankings etc. Discrete data quantitative data with finite number of values / observations. For example: 5 customers, 17 points, 12 steps etc. Continuous data quantitative data with value / observation within a range/interval. For example: sales in the last one year. Nominal data qualitative data that can not be put into a meaningful order (i.e. For example: Blue, yellow, Green, red, Black Ordinal data qualitative data that can be put into a meaningful order (i.e.
represents a mark on a chart: Consider the following excel chart which is made from the data table mentioned earlier: This chart is made up of following chart elements : Primary horizontal Axis: Primary vertical Axis, secondary vertical Axis. Primary horizontal Axis Title Primary vertical Axis Title secondary vertical Axis Title Chart Title data labels Gridlines Legend Trendline In Excel, categories are plotted on the horizontal axis and data series are plotted on the vertical axis: From the chart above, we can conclude the. Sales, cost and profit are plotted on the primary vertical axis. Roi is plotted on the secondary vertical axis. In order to add, remove or edit a chart element in Excel (2013 follow the steps below: Step-1 : Open ms excel and navigate to the spreadsheet which contains the chart you want to edit. Step-2 : Select the chart and then from the design tab select Add Chart Element drop down menu: you can also include data table in the chart above, by following the steps below: Step-1 : Click on the chart in Excel (2013) Step-2 : Click. Big data) Classify and categorise data find relationship among data Understand the composition of data Understand the distribution of data Understand the overlapping of data determine patterns and trends Detect outliers and other anomalies in data Predict future trends Tell meaningful and engaging stories.
But selecting the right excel chart is essay always a challenge. If you use an incorrect Excel chart for your analysis, you may misinterpret data and make the wrong business and marketing decisions. If you use incorrect an Excel chart for your presentation, then stakeholders may misinterpret your charts and take wrong decisions. Therefore selecting the right Excel chart is critically important. Get the free e-book (40 Pages). The anatomy of an Excel chart. In order to read an Excel chart, it is important that you understand the various components of the chart. Consider the following data table in Excel: This data table has got five variables : Month, sales, cost, Profit and roi: This data table is made up of categories and data series : Categories, here the first category is Jan, second category is Feb, third.
PowerPoint templates, backgrounds, presentation slides
Index, the importance of data visualization, data visualization is the presentation of data (both qualitative and quantitative data) in graphical format. Through data visualization you can easily: Visualise data (make sense of data, especially big data). Classify and categorise data, find relationship among data, understand the composition of data. Understand the distribution of data, understand the overlapping of data, determine patterns and trends. Detect really outliers and other anomalies in data. Predict future trends, tell meaningful and engaging stories to decision makers. Data presentation is a very important skill for an optimizer (marketer, analyst). In fact it is so valuable that LinkedIn lists it as one of the top skills that can get you hired in 2017: source : LinkedIn Unveils The top skills That Can Get you hired In 2017. Excel charts are commonly used for data visualisation and presentation.