Data Visualization

Probability and Proportion are not the same. Although they appear to be the same however there is a very thin line between these two concepts. Let me explain! Probability vs Proportion What is probability? Wikipedia definition “Numerical descriptions of how likely an event is to occur or how likely the proportion is ture” Simply put, it’s a way of measuring an expected outcome of an event. For example, if I flip a fair coin what are the chances of getting a Head....

Very often we use Best-case and Worst-case scenarios to explain uncertainty. If you are into Sales or Revenue forecasting then you should be familiar with these terms. To understand further you can read the scenario planning article here. In this tutorial, I’ll show you how to create a nice little Best case and Worst case chart in excel to explain the underlying uncertainty. Excel chart for best & worst case If you know how to create a Line chart in excel then it will be very quick and easy....

If you are an aspiring Data Scientist then the Pandas pivot table is one of the primary tools that you must learn. We all know how to use the excel pivot table. In fact, there are many use cases from summarizing data to performing calculations. But as you know excel pivot table is based on a Graphical User Interface (GUI) so it’s relatively easy to learn and apply. On the contrary Pandas pivot table is based on python code so it can be overwhelming for beginners and often your excel pivot table understanding will interfere....

Yes, the headline is correct, this tutorial is about employee attrition prediction using ML algorithms. A person like me who mostly writes tutorials on Excel and Finance has taken up this challenge to learn Data Science a few months back. (Please note I’m a finance professional with no IT background ) And today I can confidently say I’m somewhere around the intermediate level in terms of my data science/ML skills....

The term speedometer is very well known in the automobile industry, however in today’s tutorial, we are going to take a look at how to create Speedometer Chart using google sheets. Creating visually appealing presentations is a key to a successful business meeting. Indeed, traditional excel charts will certainly boost your confidence but that’s not enough. In a world increasingly saturated with data and information, visualizations are a potent way to break through the clutter, tell your story, and persuade people to action, says Adam Singer – Analytics Advocate at Google....