Instructions
This week, you learned about the use of relational database information for business intelligence purposes. In this assignment, you will use the RFM analysis sample scenario and related scriipts in weekly resources and SQL Server Management Studio Express to write stored procedures with SQL statements to manipulate (query) the data that is present in the database for business intelligence purposes.
Part 1:
Using the SQL scriipts for the RFM analysis provided in weekly resources, modify as necessary to create the necessary tables and stored procedures to conduct an RFM analysis using data in the Pets ‘n Paws database.
Describe the process of modifying the scriipts for each of the required elements in the RFM analysis. Include embedded annotated screenshots of the results of each part of the process.
Provide a copy of the modified sample RFM analysis SQL scriipts as a ZIP file.
Part 2:
Describe different types of business intelligence acquired based on the spending behavior information in the Pets ‘n Paws database as follows.
Provide answers to the following business intelligence questions with a clear explanation as to how this insight was determined:
Which customers are your top customers (based on frequency and spending) and what RFM score do they have?
Which customers are your bottom customers (based on recency) and what RFM score do they have?
Which customers could be called “frequent flyers” and what RFM score do they have?
Which customers are your “top spenders” and what RFM score do they have?
Assuming a limited marketing budget, which set of customers should be included in your next marketing campaign?
Length: 5 to 7-page paper, plus 1 zip file of ready-to-execute SQL (.sql) files
References: Include a minimum of 2 scholarly resources.
The completed assignment should address all of the assignment requirements, exhibit evidence of concept knowledge, and demonstrate thoughtful consideration of the content presented in the course. The writing should integrate scholarly resources, reflect academic expectations and current APA standards, and adhere to Northcentral University’s Academic Integrity Policy.
