Reference no: EM133268204
Assignment:
Q1. For the Database given as SalesFact.txt, Branch Dimension.txt, Item Dimension.txt, Location Dimension.txt, Time Dimension.txt (The data files are attached as separate sheets). Do The following using OLAP operations studied in the class.
- roll-up on total sales by year and by year/quarter
- roll-up on total sales by country, by state, and by city
- roll-up on total sales by item brand and by item type (digital or analog)
- drill down on total sales by month and by day
- drill down on total sales by item name
- drill down on total sales by street address
You can use either SQL statements to implement each roll-up, drill-down or make use of Spreadsheet to complete the assignment.
Q2. The retail company has an important feature as E-Wallet service that depends on holding the credit card that can be used to pay for products purchased on the platform. The customers can use the credit cards services in many different ways.
The CFO (chief financial officer) of the company decided to develop reporting and analytics on the e-wallet service so they can understand the extent of the wallet liabilities the company has.
Some of the questions they would want to answer from this are like below:
What is the daily balance of credit in the e-wallet service? How much credit will expire in the next month?
What is the outcome (i.e. % used, % expired, % left) of credit given in a particular month?
Propose a Solution Design by specifying the key decisions for the design by explaining the decision steps for the above e-Wallet case.
Use logical diagram of the dimensional model for the eWallet service. (Start Schema). Make assumptions for the dimensions and measures.