__STYLES__
Tools used in this project
Maven Cafe Rewards

About this project

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.

Additional project images

Discussion and feedback(27 comments)
comment-1845-avatar
kabir iyer
17 days ago
Good Work.

comment-1846-avatar
riya deshmukh
17 days ago
Truly elegant and well structured presentation! Well done! Thank you for your inspiration.

comment-1847-avatar
sana mirza
17 days ago
good project

comment-1848-avatar
kiara patel
17 days ago
appreciate it

comment-1850-avatar
myra patel
17 days ago
nice one

comment-1857-avatar
Amit Mukherjee
Amit Mukherjee
15 days ago
Love the choice of UI!

comment-1864-avatar
Steven Gonzales
Steven Gonzales
11 days ago
this looks awesome

comment-1873-avatar
Femi Ogunwuyi
Femi Ogunwuyi
3 days ago
Looks good
2000 characters remaining
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.