Brown Lab 2

.docx

School

Rowan University *

*We aren’t endorsed by this school

Course

98242

Subject

Industrial Engineering

Date

Jun 19, 2024

Type

docx

Pages

3

Uploaded by CoachWillpower2023

Trevor Brown A @5 Editor Transform Add Column View Lab 2.2 2-2MA g;B Transpose Data Type: Currency {)2 Replace Values v ?fl Unpivot Columns ~ Y . /’. Merge Columns Yo’ 4+~ 2 A_':]Tvigonometry < [4 Expand @, = e — rin asd e 5 @gm 100 2 (= Reverse Rows 7| Detect Data Type Fill ~ f}!’,‘] Move v 123 Extract ~ 5.0 Rounding ~ Aggregate Group Use First Row ‘ —_ . Split Format i Statistics Standard Scientific i Date Time Duration Create By asHeaders~ H Count Rows =[] Rename e, Pivot Column D Convert to List Column ~ »= Parse - - - Information ~ Extract Values pata Type Table Any Column Text Column Number Column Date & Time Column Structured Column Queries [3] < fx = Table.TransformColumnTypes(#"Promoted Headers",{{"Sales_Order_ID", Int64.Type}, {"Sales_Order_Date", type date}, {"Invoice_Order_Total", v Q‘ [ Sales_Order_Lines [7). »s_Order_Date ~| $ Invoice_Order_Total ~| 123 sales_Employee_ID ~| 123 Customer_ID ~| 123 Account_ID ~ $ Shipping_Cost ~ | 123 Approval_Employee_ID |~ [ Sales_Order 4P 1 11/1/2019 3,595.00 1006 2056 1000264 92.19 1005 FA Finished_Good_Prod... A 2 11/1/2019 4,980.00 1006 2031 1000264 14463 1005 . 3 11/1/2019 3,940.00 1006 2011 1000264 79.63 1005 : 4 11/1/2019 4,725.00 1007 2017 1000264 71.26 1005 A 5 11/1/2019 5,655.00 1006 2012 1000264 101.26 1005 4A 6 11/2/2019 1,810.00 1006 2051 1000264 12854 1005 7 11/2/2019 2,080.00 1006 2048 1000264 117.54 1005 8 11/2/2019 1,830.00 1006 2026 1000264 92.33 1005 9 11/2/2019 3,330.00 1006 2005 1000264 146.93 1005 ] 10 11/3/2019 490.00 1006 2033 1000264 23.40 1005 1 11/3/2019 315.00 1006 2019 1000264 120.02 1005 12 11/4/2019 570.00 1006 2009 1000264 77.01 1005 13 11/4/2019 3,885.00 1007 2038 1000264 67.82 1005 14 11/5/2019 1,135.00 1007 2004 1000264 58.98 1005 15 11/5/2019 905.00 1006 2042 1000264 14.19 1005 16 11/6/2019 1,155.00 1007 2013 1000264 75.93 1005 17 11/7/2019 2,985.00 1006 2043 1000264 14342 1005 18 11/7/2019 3,160.00 1006 2052 1000264 77.71 1005 19 11/7/2019 3,700.00 1006 2027 1000264 115.78 1005 20 11/7/2019 1,125.00 1006 2032 1000264 77.98 1005 21 11/7/2019 3,160.00 1006 2006 1000264 81.10 1005 22 11/7/2019 1,620.00 1007 2033 1000264 27.43 1005 23 11/8/2019 2,955.00 1007 2052 1000264 69.29 1005 24 11/8/2019 1,155.00 1007 2033 1000264 3433 1005 25 11/8/2019 4,445.00 1006 2020 1000264 83.81 1005 26 11/9/2019 3,920.00 1007 2030 1000264 4825 1005 27 11/9/2019 3,720.00 1006 2049 1000264 107.74 1005 28 11/9/2019 1,830.00 1006 2005 1000264 127.61 1005 v 29 11/11/2019 735.00 1006 2057 1000264 79.54 1005 3 X > & au 1 C F f” < = < L. I ©- Finished_Good_Products+ (Copy ... Connection Filters Conhections Add ® Live Extract 0 | Add Copy of ... Dataset Use Data Interpreter Data Interpreter might be able to clean your Microsoft Excel E workbook. & Cash & Customer..._Listing & Employee_Listing & Finished...Products 8 Purchase_Order B Purchase...er_Lines B Raw_Materials & Recipe E Sales_Order = ® & Sales_Order_Lines e & Suppliers - -~ ) & - * & o & New Union g Sales Order ID (Sales!Or... Sales Order Date Invoice Order Total Sales Employee ID Customer ID Account ID Shipping Cost Approval Employee ID & New Table Extension EKE 20001 11/1/2019 3595 1006 2056 1000264 92.190 1005 § 20002 11/1/2019 4980 1006 2031 1000264 144630 1005 20003 11/1/2019 3.940 1006 2011 1000264 79630 1005 20004 117172019 4725 1007 2017 1000264 71.260 1005 20005 11/1/2019 5655 1006 2012 1000264 101.260 1005 20006 11/2/2019 1810 1006 2051 1000264 128540 1005 20007 117272019 2,080 1006 2048 1000264 117540 1005 < 20008 11/2/2019 1830 1006 2026 1000264 92.330 1005 il. Go to Worksheet 20009 117272019 3330 1006 2005 1000264 146.930 1005 [ ______ [P afNat~Ca
2-2MB 2-2TB lome Insert Pagelayout Formulas Data Review View Automate Help PivotTable Analyze Design 1 IN REC . . . ) Manage Relationships X V|| status Table « Related Lookup Table New... Active Sales_Order_Lines (Product_Code) Finished_Good_Products (Product_Code) Auto-D " | Active Sales_Order_Lines (Sales_Order_ID) Sales_Order (Sales_Order_ID) JLiaks s Edit... Activate Deactivate Delete Close Stout 700 1452 2152 Y A (s File Home Insert Pagelayout Formulas Data Review View Automate Help PivotTable Analyze Design | B Con () SIGN IN REQUIRED We can't upload or download your changes because your cached credentials have expired. ‘ Sign In ‘ F11 v i fx Dec A B C D E F G H I J K L & . 1 PivotTable Fields 2 Active Al 3 — 4 Choose fields to add to report: 5 6 ’ Search 7 8 B ?fil Sales_Order Lines 9 Sales by Month Column Labels ~ [ Sales_Order_ID 10 -2019 +2020 Grand Total [[] Product_Code " “Nov “Dec Sales_Order_Quantity Sold 12 Row Labels -~ B 13 Imperial IPA 183 179 568 930 TP - 14 Imperial Stout 510 607 2411 3528 Drag fields between areas below: 15 IPA 458 535 1911 2904 T Filters IlI" Columr 16 Pale Ale 254 238 768 1260 Sales_Orde 17 Stout 324 376 1452 2152 I J 18 Wheat 266 264 1076 1606 Sales Orde 19 Grand Total 1995 2199 8186 12380 = Rows 3 Values ;? Product_Description v | | Sales by M 22 23 v < > Sheet1 + 4 G » [ Defer Layout Update Ready f?,Accessibility: Good to go [& Display Settings H o -- o wa = = I
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help