New feature addition into existing system. New features are to be maintained same Categorical representation of products As existing system. Inside the pantry. System must have scalability to support Essential and non-essential products can Large customer data. Added to the cart. System should be secured against Non-intrusive placement of ads into the Malicious threats. featureofmaximum5. User-friendly and self-exploratory. Freedeliveriesonorderabove$30. System would perform fast and Prominent location should highlight new Effectively for better ease of use. features on the system. lO M o Rc PSA D| 23 41 07 08
CURRENTPROCESSFLOWCHART lO M o Rc PSA D| 24 10 70 8
FUTUREPROCESSFLOWCHART(AFTERADDINGNEWFEATURES) lO M o Rc PSA D| 23 41 07 08
Testing Informed Closing lO M o Rc PSA D| 23 41 07 08
SCOPEDIAGRAM
INSCOPE REQUIREMENTS OUT OF SCOPEREQUIREMENTS Adding a new feature to the current system. Access to online pantry in offline/portal mode. Placement of feature in highly visible location Additional discounts are offered on specific goods. Status of product availability Request for Order Cancellation/Refund Money Essential things and non-essential items were Direct contact to the supplier. Both placed to the pantry. Auto suggestion active for the products on pantry. Deals/Offers are available for both single Free delivery of products below $30, for limited Products and combos. Stocks or time. 5advertisements are placed in a feature without Portal’s option for expense prediction. Being obtrusive. Request for a certain delivery time/date. Orders above $30 are eligible for free delivery. Subscriptions for further product discounts that are Reviews are shown underneath the products. Monthly or annually basis. Items that must be added to the cart or Wishlist for the checkout process. lO M o Rc PSA D| 23 41 07 08
WIREFRAMES lO M o Rc PSA D| 23 41 07 08
Question1:
Create a bar graph showing the sales. Label the chart correctly so that senior Management gets a clear report of sales. Arrange the data above in excel in ascending and descending order. lO M o Rc PSA D| 23 41 07 08
Question2:
Create bar graphs of sales for zone 1 cities.
Find total sales across all cities. lO M o Rc PSA D| 23 41 07 08
Question3:
Using VLOOKUP for product code HS, find sales in Phoenix.
Using VLOOKUP for product code FR, find sales in Dallas. lO M o Rc PSA D| 23 41 07 08
1.Create a dash board for senior management for Chicago to view sales of personal care products for the last 6 months. Make assumptions as appropriate and create the dashboard using your own mock data. For any missing data make your assumptions To create mock data. Write down the assumptions as well.
2.Create a dashboard to show Senior Management for Chicago to view sales of
breakfast products for the last six months. Make assumptions as appropriate and create the dashboard using your own mock data. For any missing data make your assumptions to create mock data. Write down the assumptions as well. lO M o Rc PSA D| 23 41 07 08
1. Make a product back log of user stories for the given case study. User Stories should be in the format of Asa<typeofuser>, Iwant<goal>so that<reason>
