There are four types of analytics, descriptive analytics, diagnostics analytics, predictive analytics, and prescriptive analytics. Among all four types of analytics, predictive analytics is one of the important type of analytics to predict the future based on historical data. There are many factors which impacts the dependent variable and the future trend. So, while doing … Read more
Pivot table in excel is one of the powerful tool to analyze data or creating a summary from a data set. Excel is considered as basic tool for data analysis and pivot table gives an extra power to it. Here we’ll discuss the pivot table in excel tutorial in terms of steps to create pivot … Read more
Regression is the basic concept of predictive analytics. When we say predictive analytics, it’s all about to predict the future or forecast the future. There are many types of regression exist in the world of data science or statistics like linear regression, logistic regression, ridge regression and many more. As a basic data analytics tool, … Read more
Among four types of analytics (descriptive, diagnostic, predictive and prescriptive), predictive analytics is one of the important type of analytics to predict the future data. Forecasting can be done with all the statistical tools or analytics tool like R, Python, Alteryx. As a basic analytical tool, forecasting can be done also with the help of … Read more
SQL stands for Structured Query Language where Join is an important concept to merge two data sets by using primary key or unique key. SQL is based on the concept of Relational Algebra. In other words, it can be said the it is the application of Relational Algebra. SQL was developed by Raymond Boyce & … Read more
