Excel

As an analyzer, we sift through a huge amount of data everyday. Data can and usually come from various sources and in various formats. They cannot be visually represented clearly if their differences are not considered. Choosing the wrong visual aid or simply defaulting to the most common type of data visualization could cause confusion with the viewer or lead to mistaken data interpretation. You need to ask yourself some questions when deciding which type of chart to use. Do you want to compare values? If yes, choose the any of the following charts: Column  Bar Pie Line Scatter Plot Bullet Do you want to show the composition of something? If yes, then chose the following: Pie Stacked Bar Mekko Stacked Column Waterfall Area If you want to understand the distribution of your data, choose among the following: Scatter Plot Mekko Line Column Bar These charts help you determine outliers If you want to analyze trends in your data, choose among the following: Line Dual-Line Axis Column De...

Here's what I learnt from Basic Data Visualization - Udemy course Excel is an excellent medium to analyze and visualize data. It is very easy to use and anyone can become very good at analyzing data within a very short period of time. Our entire focus would be on data  rather than the process behind it. To create any insights, we need to make sure that the data we're using is well organized and easily translatable into a visual format such as a chart or graph. Unorganized data would make it difficult to understand it and perform actions. An organized dataset would have perfectly labelled attribute fields. We start off by checking if they are properly labelled. If they aren't we re-label these fields. Next we need to check for empty values. If any such fields are encountered, we have 2 ways to deal with them. We can either delete entire rows of data which contain any empty field (usually done when there are thousands of rows), or we could fill them up randomly or by using an...