Data Analysis Techniques
These modules introduce you to some fundamental concepts of data analysis and interpretation. Human decision-makers face the challenge of interpreting the data they have collected and stored in their data warehouse to impart meaning to the data. Once we understand the meaning of the data and can interpret it properly, we can use this information to make decisions. The first step in data analysis often involves presenting data in forms other than simple lists and tables. In this unit, we will explore some formats – graphs, charts, and diagrams. We will then explore how we can organize these data presentation formats into what we call a business intelligence dashboard. Much like the dashboard on your car, we want to present the most critical information in the most convenient form for the decision-maker and store less useful data in a less visible location.
Visualizing Trends
Introduction to Trends
Last week we looked at the past. This week we use our data to predict the future!
Conditional Formatting
In this video Felienne explains how to use conditional formatting to highlight certain parts of your data
Spark Lines
In the previous video Felienne showed you how to use colors to visualize your data. But what are the alternatives to using colors? In this video Felienne uses Spark Lines to visualize the data.
Trend Plotting
In the last two videos we have explored the data to discover trends. In this video Felienne shows you how to present the trends you have discovered in a graph.