Forum Discussion

carlosmorales's avatar
carlosmorales
Frequent Visitor
5 years ago

Customer analysis

Hello, happy new year everyone.

I once again appear before you requesting your support.

I keep learning from Power Bi. however, I consider that some issues are still outside my capabilities, such as the following:

from the attached database, I should find the following:

1) Customers: the number of customers who made a purchase within that period of time.

2) New customers: the number of customers who made their first purchase within that time period.

3) Returning customers: the number of customers who have already bought something in the past and who return in that period of time.

4) Lost customers: the number of customers whose last purchase occurred at least 2 months before the start of the current period.

5) Recovered Customers: The number of customers who were considered lost in a previous time period and then made a purchase 

in the current period.

and present a graph like the following one for each class or type of client, filtered by category or brand.

https://drive.google.com/file/d/1jJCsBJd9zMH2KDmwzaZdYvRq48ZWt0p_/view?usp=sharing 

 

 

Thank you in advance for your time, and for sharing your knowledge.

3 Replies