Lag difference for a group in R
Hello friends! Today we’ll be learning to calculate the lag difference for a group in R.
Read moreTag: Data Analytics
Overwrite or Append data in Excel sheet using R
Hello friends! Today we’ll be learning to overwrite or append data in Excel sheet using R
Read moreRFM Analysis in Alteryx
Hello 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 morePareto in Alteryx
Hello 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.
Correlation matrix in Excel, Python and R
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 moreGet the Sum of Filtered Data in Excel
Hello 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 moreAutomated workflows using CrewMacros in Alteryx
Hello friends!! We’ll be learning to automate the Alteryx workflows using the CReW Macros in Alteryx. These quick Alteryx tip will help you run multiple workflows with single click in Alteryx.
Read moreGenerate dates between two dates in Alteryx
Hello friends!! We’ll be learning to generate dates between two dates using Alteryx. These quick Alteryx tip will help you use Generate Rows option in Alteryx.
Read more