Question
Column and Model Transformations You are an accountant for Bargain, which is a franchise that buys items all over North America, fixes and cleans them,
Column and Model Transformations You are an accountant for Bargain, which is a franchise that buys items all over North America, fixes and cleans them, and then sells them with a substantial markup. You have been asked to create an analytical database to understand purchases in anticipation of a business cycle review and efficiency project. Your supervisor provided you with three CSV files and a PDF file with the data dictionaries for each. Apply the appropriate data preparation patterns to the three files to create an analytical database that is consistent with the one shown here.
An illustration presents two excel spreadsheets. The first excel sheet at the top titled, Bargain Vendors, consists of four columns, and the column headers are: A table is presented with a drop down menu representing auto fill for row numbers; (A B C representing alphabets column) I D, with a drop down button to its right; (A B C representing alphabets column) Name, with a drop down button to its right; (A B C representing alphabets column) Email, with a drop down button to its right. The data from the table are presented as follows:1; I D: U S 1; Name: Cohen, Sandra; Email: scohen at the rate of vstores dot com;2; I D: U S 2; Name: Gray, Sev; Email: sev-gray at the rate of lbox dot com;3; I D: U S 3; Name: Leroy, Shanice; Email: sleroy at the rate of google dot com;4; I D: U S 4; Name: Morales, Benita; Email: bmor at the rate of hf dot com;5; I D: U S 5; Name: Wang, CeCe; Email: cece at the rate of cch dot com;6; I D: C A N 1; Name: Zhu, Jim; Email: jzhu at the rate of outlook dot com;7; I D: C A N 2; Name: Coyle, Irene; Email: lrene at the rate of coyle dot com;8; I D: C A N 3; Name: Dabrowski, Elizbieta; Email: ElzDab at the rate of dot com;9; I D: C A N 4; Name: King, Laura; Email: LauraKing at the rate of fmh dot com;10; I D: C A N 5; Name: Jackson, Kiara; Email: kiaraj at the rate of ncn dot com.The second excel sheet below titled, Bargain Purchases, consists of nine columns, and the column headers are: A table is presented with a drop down menu representing auto fill for row numbers; (1 2 3 representing numbers column) Line Item I D, with a drop down button to its right; (1 2 3 representing numbers column), Order Number, with a drop down button to its right; (Calendar) Date, with a drop down button to its right; (A B C representing alphabets column) Type, with a drop down button to its right; (A B C representing alphabets column) Category, with a drop down button to its right; (1 2 3 representing numbers column), Price, with a drop down button to its right; (1 2 3 representing numbers column), Quantity, with a drop down button to its right; (A B C representing alphabets column) Vendor. The data from the table are presented as follows:1; Line Item I D: 1; Order Number: 8,992; Date: 2 January, 2025; Type: Rice Cooker; Category: Kitchen; Price: $69; Quantity: 2; Vendor: U S 1;2; Line Item I D: 2; Order Number: 8,993; Date: 2 January, 2025; Type: Phone; Category: Electronics; Price: $113; Quantity: 1; Vendor: C A N 3;3; Line Item I D: 3; Order Number: 8,994; Date: 2 January, 2025; Type: Fryer; Category: Kitchen; Price: $181; Quantity: 1; Vendor: C A N 5;4; Line Item I D: 4; Order Number: 8,894; Date: 2 January, 2025; Type: Stuffed Animal; Category: Toys; Price: $14; Quantity: 5; Vendor: U S 2;5; Line Item I D: 5; Order Number: 8,896; Date: 2 January, 2025; Type: T V; Category: Electro; Price: $79; Quantity: 1; Vendor: C A N 2;6; Line Item I D: 6; Order Number: 8,897; Date: 3 January, 2025; Type: Stuffed Animal; Category: Toys; Price: $67; Quantity: 1; Vendor: C A N 1;7; Line Item I D: 7; Order Number: 8,897; Date: 3 January, 2025; Type: Microwave; Category: Kitchen; Price: $205; Quantity: 1; Vendor: U S 1;8; Line Item I D: 8; Order Number: 8,898; Date: 3 January, 2025; Type: Headphone; Category: Electronics; Price: $45; Quantity: 1; Vendor: U S 4;9; Line Item I D: 9; Order Number: 8,898; Date: 3 January, 2025; Type: Jewelry; Category: Toys; Price: $13; Quantity: 2; Vendor: C A N 1;10; Line Item I D: 10; Order Number: 8,899; Date: 3 January, 2025; Type: Printer; Category: Electro; Price: $199; Quantity: 2; Vendor: C A N 3.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started