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.
Customer loyalty data – Data base
Store location data – Data base
Customer location data bought from mobile companies – streaming data – Kafka interface
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.