Dynamic Parameter in Tableau
Hello friends!! We’ll be learning how to create the dynamic parameter range in Tableau.
Read moreHello friends!! We’ll be learning how to create the dynamic parameter range in Tableau.
Read moreHello friends!! We’ll be learning how to add CAGR line in bar or Line in single chart in Excel. I’ve attached the workbook to download and reuse.
Read moreHello friends!! We’ll be learning how to create bar and stack bar in single chart in Excel. I’ve done something similar in Tableau in my previous post Profit Gap Analysis in Tableau. Also I’ve attached workbook to download and reuse.
Read moreHello friends!! today we’ll be learning how to calculate Median and Quartile values with multiple conditions. I’ve attached the Excel workbook for download and reuse. So it is MEDIAN IFs and QUARTILE IFs but there is no direct formula we’ll create one.
Read moreHello friends!! today we’ll be learning to do RFM analysis in Alteryx. I’ve attached the Alteryx workflow for download and reuse. The workflow is reusable to calculate the RFM or tweak the workflow logic in RFM algorithm.
RFM (recency, frequency, monetary) analysis is a marketing technique used to determine quantitatively which customers are the best ones by examining how recently a customer has purchased (recency), how often they purchase (frequency), and how much the customer spends (monetary) read more
Read moreHello friends!! today we’ll be learning to create Pareto in Alteryx. I’ve attached the Alteryx workflow for download and reuse.
The Pareto Principle (also known as the 80/20 rule), for many events, roughly 80% of the effects come from 20% of the causes. The Pareto Principle is an observation, not a law of nature.
Hello friends!! today we’ll learn to make correlation matrix in Excel, Python and R. Also we’ll be creating correlation matrix heatmap in Excel, Python and R.
Read moreHello friends!! We’ll be learning to do calculation and do aggregation on filtered data in Excel. We’ll achieve this using the SUBTOTAL() function in Excel.
Read more