A retail customer needs a customer targeted promotions initiative, to take effect when any customer walks into the store. There will be a need to analyse when customers buying trend is going down and for those identified customers.

Agenda:

Intro – 5 min
Background discussion – 15 min
Solution discussion in programming, process and reporting plus model– 20 min
General discussion – 20 min


Outline of scenario:

A retail customer needs a customer targeted promotions initiative, to take effect when any customer walks into the store.

There will be a need to analyse when customers buying trend is going down and for those identified customers, there will be a requirement to offer a promotion in the form of an offer or a discount.



Sources:

Customer loyalty data – Data base
Store location data – Data base
Customer location data bought from mobile companies – streaming data – Kafka interface


Target:

Load into Azure SQL DB



Solution Presentation with components in detail:



Integration with sources – solution design
Processing python/PySpark ETL design
Reporting – Visual and model


Presentation can be on 3 – 5 slides. I can visualize myself. I only need help with the remaining task.