Maven Cafe Rewards

Maven Cafe rewards analytics have a big challenge as first time entry & begginner learner.

Started with data, data cleaning played crucial role.

Started in excel query, Started with data, i first separated event order id, rewards, amounts etc. details. Then separated each events received, viewed, completed, transaction. Change time from hour to day by divide 24. Sort Customer ID, Order ID, then Time to match each event. in excel manually add index for make sequence of the events. i used =IF(AND(A3=A2,B3=B2),D2+1,1). This make sequence of each event when repeats. then merge data with customer id, order id, time & sequence index as main criteria. This will convert full data into one sequence for reference to order receive.

Made many DAX for offer completion, view, within time, by age, by group etc. views.