In this tutorial, we are going to learn advanced techniques in Dashboards as well as the concept of Storytelling. We will also learn some other types of charts such as Tree Maps.
In this entire dashboard and storytelling lesson, we are essentially looking at Ship Mode versus different variables such as Profit, Sales, Discount, etc. What this means from an analysis point of view is that we are trying to see what factors, if any, are showing trends in conjunction with shipping modes.
A database is a collection of logically interrelated data and description of this data, designed to meet the information needs for organization. The primary objective of creating a database is to store, update and retrieve data efficiently and use it for analysis. The data stored can also include any transient data such as input documents, reports and intermediate results obtained during processing of the data. To achieve this, database must have different characteristics and some of them are:
It should have a structure which deals with data types and data behavior.
It should have a proper retrieval method which could be a declarative query language (like SQL, which we'll talk about in this article) or a procedural database programming language (like Java or Python).
Network Analysis, metrics for Centrality and The PageRank Algorithm
Introduction to Network Analysis
Networks are everywhere. Be it the network of friends in a university or the online social networks such as Facebook and Twitter or the transportation networks or financial networks, networks are ubiquitous in human society. A network is a collection of objects (nodes) with relationships / interconnections (edges) between them.
Since networks are so universal, analyzing them gives us valuable information about different complex phenomena. For example, by analyzing a network of people in an organization, we can find out the most influential people in that organization. Or by analyzing a network of different airports or train stations we can find out which places have the maximum risk of spreading a particular virus. Network analysis provides us with the tools that will help us answer these type of questions.
Graphs and types of graphs
The most common and easy method to represent network...
Statistics: Central Tendency metrics, Dispersion and Correlation
Statistics is a very broad branch of mathematics that deals with everything related to data, from collection and organization of data to its analysis, interpretation and presentation. With the ever increasing amount of data, statistics has become an indispensable tool in every field where one has to work with data.
When the amount of data we are dealing with is fairly small then it might be possible to talk about all the data items individually. However, when we are dealing with large quantities of data, which is almost always the case in real world situations, we need to have some characteristic values that can represent the data.
In this tutorial, we'll introduce such measures first for a single variable. For example, say the weight of students in a particular school. These measures will include measures of central tendency and measures of dispersion. Then, we'll look at measures for und...