SQL or Structured Query language is the standard language used to query and manage relational database systems. In its initial days, it was called as “SEQUEL” but later changed to “SQL” due to trademark issues. As there are a lot of database systems are available based on SQL and they all have different extensions, different structure, function […]
Performing Pareto Analysis using Tableau and Microsoft Excel
Pareto Analysis also called as 80/20 rule, is a decision-making technique which states that 80 % effects of things happen in the system, arises from 20 % causes. Consider below two examples to understand better: 80 % of your profit came from 20 per cent of Products you sold 80% of issues in your website/business […]
13 Most Used Matplotlib Plots for Data Visualization in Data Science (with Python Codes)
Here in this post, we have shared 13 Matplotlib plots for Data Visualization widely used by Data Scientists or Data Analysts along with Python codes so that you can easily implement them side by side with us. Python’s Matplotlib library plays an important role in visualizing and serve as an important part for an Exploratory Data […]
Top 20 Advanced Excel formulas for Data Analysis
Recently released Microsoft Excel 2016 version has 484 functions, out of these, 360 existed prior to Excel 2010. Here in this post, i have gathered most used advanced Excel formulas for Data Analysis in industry. Microsoft Excel since after released in 1987 and after version 5 which was released in 1993, became the widely applied spreadsheet […]
Creating Time Series with Line Charts using Python’s Matplotlib library
In this post, we will see how we can create Time Series with Line Charts using Python’s Matplotlib library. Basically, in Data Visualization, Time series charts are one of the important ways to analyse data over a time. In general, any chart that shows a trend over a time is a Time series chart and usually […]
Plotting multiple histograms with different length using Python’s Matplotlib library
In my previous posts, we have seen how we can plot stacked histogram (filled) and a stacked Step histogram (unfilled). In this post, we will see how we can plot multiple histograms with different length using Python’s Matplotlib library on the same axis. Basically, Histograms are a graphical representation of a frequency distribution of numerical data and it’s a […]