Chandra Sekhar
asked on
What's your suggestion for bad weather effecting business, sales decline,new compititor or to open a new store. How do you address this issue with this query and your potential suggestion appreciated.
Hi
I have below scenario and need help to address this issues. What would be your approach to solve this problem in bullet points or brief summary like what is your assumptions,explain your analysis approach and chosen analytics techniques, expected output results, what recommendations do you suggest,do you see limitations
1. How would you assess the impact of weather on consumer spend last winter?
2. How would you determine if a specific block in your neighborhood is suitable for a new grocery store?
3. Bank XYZ has created a new credit card product, how would you determine the targeting strategy?
4. Bank XYZ has observed declining credit card sales volumes in their core markets. How would diagnose the cause and what potential remediation’s may be put in place (if any)
5. Credit Card company recently announced a new partnership with a key tech company. How would you quantify the per customer incremental value of this partnership?
Thanks
I have below scenario and need help to address this issues. What would be your approach to solve this problem in bullet points or brief summary like what is your assumptions,explain your analysis approach and chosen analytics techniques, expected output results, what recommendations do you suggest,do you see limitations
1. How would you assess the impact of weather on consumer spend last winter?
2. How would you determine if a specific block in your neighborhood is suitable for a new grocery store?
3. Bank XYZ has created a new credit card product, how would you determine the targeting strategy?
4. Bank XYZ has observed declining credit card sales volumes in their core markets. How would diagnose the cause and what potential remediation’s may be put in place (if any)
5. Credit Card company recently announced a new partnership with a key tech company. How would you quantify the per customer incremental value of this partnership?
Thanks
Statistics? Sounds like homework..
ASKER
Hmmm..I am looking for 3 to 5 bullet points to the each point. eg. how your business impacted your business impacted your last winter beacuse of bad weather
So that..I can build various SQL queries or reports or dashboards based on your insight
So that..I can build various SQL queries or reports or dashboards based on your insight
It solely depends on the data you have.
E.g. question 1: Then you can look for correlations, cluster analysis, trend analysis...
The obvious would be look for correlations. Thus you need to have lots of historic data. So that you can look sales-to-temperature, sales-to-humidity, sales-to-sun hours per period (day, week, month). Then you need to correlate it also with the number of customers per period.
But it is very problematic, cause your question is already biased ("bad weather").
E.g. question 1: Then you can look for correlations, cluster analysis, trend analysis...
The obvious would be look for correlations. Thus you need to have lots of historic data. So that you can look sales-to-temperature, sales-to-humidity, sales-to-sun hours per period (day, week, month). Then you need to correlate it also with the number of customers per period.
But it is very problematic, cause your question is already biased ("bad weather").
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.