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.
Data Exploration
Introduction Data Exploration
This week Felienne talks about how to perform exploratory analysis on your data.
Pivot Tables and Charts
In this video Felienne shows how to use PivotCharts to explore your data.
Pivot Charts continued
In this video Felienne shows how to use PivotCharts to explore your data.
Power Pivot
The next data exploration tool we are looking at is Power Pivot!