Deploying WebApp on Microsoft Azure. We have all the codes available including datasets. We have to deploy it to the Azure platform.
Final Group Project: Data Science using Azure Cloud Technologies and Tools Due Monday by 11:59pm Points 20 Submitting a text entry box, a website url, or a file upload Attempts 0 Allowed Attempts 3 Available Nov 10 at 12am - Dec 5 at 11:59pm Start Assignment Project Abstract As data volume, variety and velocity accelerate, organizations need to leverage modern data engineering. Every industry is being disrupted by data. In healthcare and life sciences, genomic data enable targeted drug discovery and personalized medicine. In financial services, alternative and third- party data provide increasingly vital investment signals. In retail and consumer packaged goods, demand forecasting, pricing, and inventory data deliver an order of magnitude efficiencies. Azure and Cloud Computing provide an opportunity to deploy Software application solutions easier, faster, better, and at scale. For the final group project, we will explore real-world Retail data from 84.51°/Kroger (anonymized) to create an interactive Web Application in Azure Cloud. You will have the ability to focus on innovative problem-solving solutions using the Azure technology stack. The goal is to work on solutions that will make life easier for a Retail shopper. Be creative and put yourself into the shopper’s shoes. Focus on the core principle, "Make the Customer's Life Easier" Below are some of the questions you are looking to answer: 1. How does customer engagement change over time? Do households spend less or more? What categories are growing or shrinking with changing customer engagement? 2. Which demographic factors (e.g. household size, presence of children, income) appear to affect customer engagement? How do they affect customer engagement with certain categories? How might we re-engage customers within the store? Or within a specific category? Here is an example of the dashboard. Your dashboard does not need to be this fancy. Please use the attached SAMPLE data set, which contains household level transactions over two years from a group of 400 households who shop at a retailer. It contains all of the purchases from each household. WHAT IS INCLUDED IN THE DATA SET? 1. 400_household.csv: 400 sampled households Household demographics (if available for that household) Household Loyalty 2. 400_transactions.csv: Transaction data for each household (Please upload a minimum of 10K records for Transactions) 8/17/2018 8/15/2020 Spend Products Units Regional Information 3. 400_products.csv: Product Information Product Number Department Commodity Private vs National Brand Natural/Organic Product Flag For more detail please see Case Study Overview - UPDATED.pdf (https://uc.instructure.com/courses/1548068/files/161311721?wrap=1) within the 8451_The_Complete_Journey_2_Sample.zip (https://uc.instructure.com/courses/1548068/files/161311713?wrap=1) (https://uc.instructure.com/courses/1548068/files/161311713/download?download_frd=1) file provided above. FINAL Group Project Requirements: Provide the code, write-ups, and URL to the Azure Web application. 1. Provide a short write-up on which Data Science Predictive modeling techniques would be most suitable to reasonably answer the questions below. Please see The Top 10 Machine Learning Algorithms (https://builtin.com/data-science/tour-top-10-algorithms-machine-learning-newbies) for model section. (No more than 200 words) (3 points) Retail Question: What categories are growing or shrinking with changing customer engagement? 2. Launch / configure Web server in Azure (any platform accepted but should be accessible through the internet). Design an interactive web page to do the following (3 points): Username Password Email 3. Create a datastore or database in Azure of your choice, and load SAMPLE Transactions, Households, and Products data from the 8451_The_Complete_Journey_2_Sample.zip (https://uc.instructure.com/courses/1548068/files/161311713?wrap=1) (https://uc.instructure.com/courses/1548068/files/161311713/download?download_frd=1) (Azure SQL, PostgreSQL, MySQL, Mongo DB, Azure Storage Account, etc.) Please choose the free (No Cost) or Least cost option where possible in Azure. Create a display page where we can see Sample Data https://uc.instructure.com/courses/1548068/files/161311721?wrap=1 https://uc.instructure.com/courses/1548068/files/161311713?wrap=1 https://uc.instructure.com/courses/1548068/files/161311713/download?download_frd=1 https://builtin.com/data-science/tour-top-10-algorithms-machine-learning-newbies https://uc.instructure.com/courses/1548068/files/161311713?wrap=1 https://uc.instructure.com/courses/1548068/files/161311713/download?download_frd=1 Pull for HSHD_NUM #10, linking the household, transaction, and products tables. Sort by Hshd_num, Basket_num, Date, Product_num, Department, Commodity. Similar to the SAMPLE DATA PULL FOR HH #0001 table shown. (You have an option to join the data sets ( Households,Transactions, Products) beforehand in Anaconda or Databricks before storing the DATA PULL in Azure). (4 points) 4. Create an interactive web page that will allow us to search on DATA PULLs based on Hshd_num. Sort by Hshd_num, Basket_num, Date, Product_num, Department, Commodity. (2 points) 5. Web Page with Dashboard to answer Which demographic factors appear to affect customer engagement? (4 points) Retail Question: Which demographic factors (e.g. household size, presence of children, income) appear to affect customer engagement? "You can choose to answer with one of the options provided (e.g. household size, presence of children, income); but not limited to them for your answer. " I am planning to be very lenient with your answers so that we can foster creativity. 6. Web App, where we can load the most current Data sets for Transactions, Households, and Products. I am planning to load new Transactions, Households, and Products for 2021, and test the output from the interactive web page in Question 4, which allows us to search on DATA PULLs based on Hshd_num. ( 4 points)