Tableau-DIY-BDCS.xlsx

Channel Type Pay Type Online Debit Online Debit Online Debit Online Debit Online Credit Online Credit Online Credit Online Credit Online Credit Direct Cash Direct Cash Direct Cash Direct Cash Direct Cash Direct Cheque Direct Cheque Direct Cheque Direct Cheque Direct Cheque Post FedeX Post FedeX Post FedeX Post FedeX Post FedeX Post DHL Post DHL Post DHL Post DHL Post DHL Online Debit Online Debit Online Debit Online Debit Online Credit Online Credit Online Credit Online Credit Online Credit Direct Cash Direct Cash

Item Category Item ID Electronics Electronics Electronics Electronics Electronics Electronics Electronics Electronics Electronics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cellular Cellular Cellular Cellular Cellular Cellular Cellular Cellular Cellular Cellular Electronics Electronics Electronics Electronics Electronics Electronics Electronics Electronics Electronics Cosmetics Cosmetics

Item code 10 P1 10 P1 10 P1 10 P1 14 P2 14 P2 14 P2 14 P2 14 P2 20 P3 20 P3 20 P3 20 P3 20 P3 24 P4 24 P4 24 P4 24 P4 24 P4 30 P5 30 P5 30 P5 30 P5 30 P5 38 P6 38 P6 38 P6 38 P6 38 P6 10 P1 10 P1 10 P1 10 P1 14 P2 14 P2 14 P2 14 P2 14 P2 20 P3 20 P3

Item Name Laptop Laptop Laptop Laptop DVD DVD DVD DVD DVD Powder Powder Powder Powder Powder Soap Soap Soap Soap Soap ATT ATT ATT ATT ATT Verizon Verizon Verizon Verizon Verizon Laptop Laptop Laptop Laptop DVD DVD DVD DVD DVD Powder Powder

Direct Direct Direct Direct Direct Direct Direct Direct Post Post Post Post Post Post Post Post Post Post Online Online Online Online Online Online Online Online Online Direct Direct Direct Direct Direct Direct Direct Direct Direct Direct Post Post Post Post

Cash Cash Cash Cheque Cheque Cheque Cheque Cheque FedeX FedeX FedeX FedeX FedeX DHL DHL DHL DHL DHL Debit Debit Debit Debit Credit Credit Credit Credit Credit Cash Cash Cash Cash Cash Cheque Cheque Cheque Cheque Cheque FedeX FedeX FedeX FedeX

Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cellular Cellular Cellular Cellular Cellular Cellular Cellular Cellular Cellular Cellular Electronics Electronics Electronics Electronics Electronics Electronics Electronics Electronics Electronics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cellular Cellular Cellular Cellular

20 P3 20 P3 20 P3 24 P4 24 P4 24 P4 24 P4 24 P4 30 P5 30 P5 30 P5 30 P5 30 P5 38 P6 38 P6 38 P6 38 P6 38 P6 10 P1 10 P1 10 P1 10 P1 14 P2 14 P2 14 P2 14 P2 14 P2 20 P3 20 P3 20 P3 20 P3 20 P3 24 P4 24 P4 24 P4 24 P4 24 P4 30 P5 30 P5 30 P5 30 P5

Powder Powder Powder Soap Soap Soap Soap Soap ATT ATT ATT ATT ATT Verizon Verizon Verizon Verizon Verizon Laptop Laptop Laptop Laptop DVD DVD DVD DVD DVD Powder Powder Powder Powder Powder Soap Soap Soap Soap Soap ATT ATT ATT ATT

Post Post Post Post Post Post Online Online Online Online Online Online Online Online Online Direct Direct Direct Direct Direct Direct Direct Direct Direct Direct Post Post Post Post Post Post Post Post Post Post

FedeX DHL DHL DHL DHL DHL Debit Debit Debit Debit Credit Credit Credit Credit Credit Cash Cash Cash Cash Cash Cheque Cheque Cheque Cheque Cheque FedeX FedeX FedeX FedeX FedeX DHL DHL DHL DHL DHL

Cellular Cellular Cellular Cellular Cellular Cellular Electronics Electronics Electronics Electronics Electronics Electronics Electronics Electronics Electronics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cosmetics Cellular Cellular Cellular Cellular Cellular Cellular Cellular Cellular Cellular Cellular

30 P5 38 P6 38 P6 38 P6 38 P6 38 P6 10 P1 10 P1 10 P1 10 P1 14 P2 14 P2 14 P2 14 P2 14 P2 20 P3 20 P3 20 P3 20 P3 20 P3 24 P4 24 P4 24 P4 24 P4 24 P4 30 P5 30 P5 30 P5 30 P5 30 P5 38 P6 38 P6 38 P6 38 P6 38 P6

ATT Verizon Verizon Verizon Verizon Verizon Laptop Laptop Laptop Laptop DVD DVD DVD DVD DVD Powder Powder Powder Powder Powder Soap Soap Soap Soap Soap ATT ATT ATT ATT ATT Verizon Verizon Verizon Verizon Verizon

Employee ID Employee CodEmployee NamEmployee LocaEmployee Coun Manager 1 E1 Sachin TendulkAP India Manager 2 E2 Rahul Dravid AP India Manager 3 E3 Saurav AP India Manager 4 E4 Mohsin Khan AP India Manager 5 E5 Rahul Gandhi HR India Manager 6 E6 Yuvraj Singh HR India Manager 7 E7 Viru Sehwag HR India Manager 8 E8 Gautam HR India Manager 9 E9 Zaheer Khan HR India Manager 10 E10 Michael VA USA Manager 11 E11 George MD USA Manager 12 E12 Michel NY USA Manager 13 E13 Steve VA USA Manager 14 E14 Glenn McgrathMD USA Manager 15 E15 Bret Lee NY USA Manager 16 E16 Mark Waugh VA USA Manager 17 E17 Andy Marsh MD USA Manager 18 E18 Tim NY USA Manager 19 E19 Kenny TX UK Manager 20 E20 Angela IL UK Manager 21 E21 Simon TX UK Manager 22 E22 Mark IL UK Manager 23 E23 Geof WA UK Manager 24 E24 John IL UK Manager 25 E25 Jefery TX UK Manager 26 E26 Javed IL UK Manager 27 E27 Hulk Hogan WA UK Manager 28 E28 Mustaq AhmedWA UK Manager 29 E29 Kaushik TX UK Manager 1 E1 Sachin TendulkAP India Manager 2 E2 Rahul Dravid AP India Manager 3 E3 Saurav AP India Manager 4 E4 Mohsin Khan AP India Manager 5 E5 Rahul Gandhi HR India Manager 6 E6 Yuvraj Singh HR India Manager 7 E7 Viru Sehwag HR India Manager 8 E8 Gautam HR India Manager 9 E9 Zaheer Khan HR India Manager 10 E10 Michael VA USA Manager 11 E11 George MD USA Manager

1 1 1 1 2 2 2 2 4 5 4 5 4 5 4 5 4 5 3 3 3 3 3 3 3 6 7 8 9 1 1 1 1 2 2 2 2 4 5 4

12 E12 13 E13 14 E14 15 E15 16 E16 17 E17 18 E18 19 E19 20 E20 21 E21 22 E22 23 E23 24 E24 25 E25 26 E26 27 E27 28 E28 29 E29 1 E1 2 E2 3 E3 4 E4 5 E5 6 E6 7 E7 8 E8 9 E9 10 E10 11 E11 12 E12 13 E13 14 E14 15 E15 16 E16 17 E17 18 E18 19 E19 20 E20 21 E21 22 E22 23 E23

Michel NY Steve VA Glenn McgrathMD Bret Lee NY Mark Waugh VA Andy Marsh MD Tim NY Kenny TX Angela IL Simon TX Mark IL Geof WA John IL Jefery TX Javed IL Hulk Hogan WA Mustaq AhmedWA Kaushik TX Sachin TendulkAP Rahul Dravid AP Saurav AP Mohsin Khan AP Rahul Gandhi HR Yuvraj Singh HR Viru Sehwag HR Gautam HR Zaheer Khan HR Michael VA George MD Michel NY Steve VA Glenn McgrathMD Bret Lee NY Mark Waugh VA Andy Marsh MD Tim NY Kenny TX Angela IL Simon TX Mark IL Geof WA

USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA India India India India India India India India India USA USA USA USA USA USA USA USA USA USA USA USA USA USA

Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager

5 4 5 4 5 4 5 3 3 3 3 3 3 3 6 7 8 9 1 1 1 1 2 2 2 2 4 5 4 5 4 5 4 5 4 5 3 3 3 3 3

24 E24 25 E25 26 E26 27 E27 28 E28 29 E29 1 E1 2 E2 3 E3 4 E4 5 E5 6 E6 7 E7 8 E8 9 E9 10 E10 11 E11 12 E12 13 E13 14 E14 15 E15 16 E16 17 E17 18 E18 19 E19 20 E20 21 E21 22 E22 23 E23 24 E24 25 E25 26 E26 27 E27 28 E28 29 E29

John IL Jefery TX Javed IL Hulk Hogan WA Mustaq AhmedWA Kaushik TX Sachin TendulkAP Rahul Dravid AP Saurav AP Mohsin Khan AP Rahul Gandhi HR Yuvraj Singh HR Viru Sehwag HR Gautam HR Zaheer Khan HR Michael VA George MD Michel NY Steve VA Glenn McgrathMD Bret Lee NY Mark Waugh VA Andy Marsh MD Tim NY Kenny TX Angela IL Simon TX Mark IL Geof WA John IL Jefery TX Javed IL Hulk Hogan WA Mustaq AhmedWA Kaushik TX

USA USA USA USA USA USA India India India India India India India India India USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA

Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager

3 3 6 7 8 9 1 1 1 1 2 2 2 2 4 5 4 5 4 5 4 5 4 5 3 3 3 3 3 3 3 6 7 8 9

Department Sales Sales Sales Sales Sales Sales Sales Sales Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Finance Finance Finance Finance Finance Finance Finance Audit Audit Audit Audit Sales Sales Sales Sales Sales Sales Sales Sales Accounting Accounting Accounting

Sales Date Sales_Cost Sales_Amt Sales_Qty 1/1/2012 80 100 1/2/2012 180 200 1/3/2012 305 300 1/4/2012 350 400 1/5/2012 400 500 1/6/2012 550 600 1/7/2012 680 700 1/8/2012 700 800 1/9/2012 798 900 1/1/2012 876 1000 1/2/2012 1020 1100 1/3/2012 988 1200 1/4/2012 100 100 1/5/2012 200 200 1/6/2012 300 300 1/7/2012 400 400 1/8/2012 500 500 1/9/2012 550 600 1/1/2012 680 700 1/2/2012 700 800 1/3/2012 798 900 1/1/2012 876 1000 1/2/2012 1020 1100 1/3/2012 988 1200 1/4/2012 100 1300 1/5/2012 1400 1400 1/6/2012 1500 1500 3/7/2012 550 1500 3/8/2012 680 1600 3/9/2012 700 100 3/3/2013 798 200 3/2/2013 876 300 3/3/2013 1020 400 3/4/2013 988 500 3/5/2013 100 600 3/6/2013 700 700 3/7/2013 800 800 3/8/2013 900 900 3/9/2013 1000 1000 3/3/2013 1100 1100

Sales Type 10 Domestic 11 International 12 Domestic 13 International 14 International 15 Domestic 16 International 17 International 18 International 19 Domestic 20 International 21 Domestic 22 Domestic 23 International 24 Domestic 25 International 26 International 27 Domestic 28 International 29 Domestic 30 Domestic 31 International 32 Domestic 33 Domestic 34 International 35 Domestic 36 Domestic 37 International 38 Domestic 10 Domestic 11 International 12 Domestic 13 International 14 International 15 Domestic 16 International 17 International 18 Domestic 19 International 20 Domestic

Accounting Accounting Accounting Accounting Accounting Accounting Accounting Finance Finance Finance Finance Finance Finance Finance Audit Audit Audit Audit Sales Sales Sales Sales Sales Sales Sales Sales Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Finance Finance Finance Finance Finance

3/2/2013 3/3/2013 3/4/2013 3/5/2013 3/6/2013 3/7/2013 3/8/2013 3/9/2013 3/3/2013 3/2/2013 3/3/2013 3/3/2013 3/2/2013 3/3/2013 3/4/2013 3/5/2013 3/6/2013 3/7/2013 1/1/2014 1/2/2014 1/3/2014 1/4/2014 1/5/2014 1/6/2014 1/7/2014 1/8/2014 1/9/2014 1/1/2014 1/2/2014 1/3/2014 1/4/2014 1/5/2014 1/6/2014 1/7/2014 1/8/2014 1/9/2014 1/1/2014 1/2/2014 1/3/2014 1/1/2014 1/2/2014

1200 100 550 680 700 798 876 1020 988 100 1000 550 680 700 798 876 1020 988 80 180 305 350 400 550 680 700 798 876 1020 988 100 200 300 400 500 550 680 700 798 876 1020

1200 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1500 1600 100 200 300 400 500 600 700 800 900 1000 1100 1200 100 200 300 400 500 600 700 800 900 1000 1100

21 International 22 International 23 Domestic 24 International 25 International 26 International 27 Domestic 28 Domestic 29 International 30 Domestic 31 International 32 International 33 Domestic 34 International 35 International 36 International 37 Domestic 38 International 10 Domestic 11 International 12 Domestic 13 International 14 International 15 Domestic 16 International 17 International 18 International 19 Domestic 20 International 21 Domestic 22 Domestic 23 International 24 Domestic 25 International 26 International 27 Domestic 28 International 29 Domestic 30 Domestic 31 International 32 Domestic

Finance Finance Audit Audit Audit Audit Sales Sales Sales Sales Sales Sales Sales Sales Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Finance Finance Finance Finance Finance Finance Finance Audit Audit Audit Audit

1/3/2014 1/4/2014 1/5/2014 1/6/2014 3/7/2014 3/8/2014 3/9/2014 3/3/2015 3/2/2015 3/3/2015 3/4/2015 3/5/2015 3/6/2015 3/7/2015 3/8/2015 3/9/2015 3/3/2015 3/2/2015 3/3/2015 3/4/2015 3/5/2015 3/6/2015 3/7/2015 3/8/2015 3/9/2015 3/3/2015 3/2/2015 3/3/2015 3/3/2015 3/2/2015 3/3/2015 3/4/2015 3/5/2015 3/6/2015 3/7/2015

988 100 1400 1500 550 680 700 798 876 1020 988 100 700 800 900 1000 1100 1200 100 550 680 700 798 876 1020 988 100 1000 550 680 700 798 876 1020 988

1200 1300 1400 1500 1500 1600 100 200 300 400 500 600 700 800 900 1000 1100 1200 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1500 1600

33 Domestic 34 International 35 Domestic 36 Domestic 37 International 38 Domestic 10 Domestic 11 International 12 Domestic 13 International 14 International 15 Domestic 16 International 17 International 18 Domestic 19 International 20 Domestic 21 International 22 International 23 Domestic 24 International 25 International 26 International 27 Domestic 28 Domestic 29 International 30 Domestic 31 International 32 International 33 Domestic 34 International 35 International 36 International 37 Domestic 38 International

Customer ID Customer NamCustomer LocaCustomer Country 100 Ram Mumbai IN 101 Ramesh New York US 102 Suresh London UK 103 Naresh Mumbai IN 104 Mahesh New York US 105 Rajesh London UK 106 Pawan Mumbai IN 107 Charan Washington US 108 Prasad Bristol UK 109 Arvind AP IN 110 Arjun Washington US 100 Ram Mumbai IN 101 Ramesh New York US 102 Suresh London UK 103 Naresh Mumbai IN 104 Mahesh New York US 105 Rajesh London UK 106 Pawan Mumbai IN 107 Charan Washington US 108 Prasad Bristol UK 109 Arvind AP IN 110 Arjun Washington US 100 Ram Mumbai IN 101 Ramesh New York US 102 Suresh London UK 103 Naresh Mumbai IN 104 Mahesh New York US 106 Pawan Mumbai IN 107 Charan Washington US 108 Prasad Bristol UK 109 Arvind AP IN 110 Arjun Washington US 100 Ram Mumbai IN 101 Ramesh New York US 102 Suresh London UK 103 Naresh Mumbai IN 106 Pawan Mumbai IN 107 Charan Washington US 108 Prasad Bristol UK 109 Arvind AP IN

110 Arjun 100 Ram 101 Ramesh 102 Suresh 106 Pawan 107 Charan 108 Prasad 109 Arvind 110 Arjun 100 Ram 101 Ramesh 106 Pawan 107 Charan 108 Prasad 109 Arvind 110 Arjun 100 Ram 101 Ramesh 100 Ram 101 Ramesh 102 Suresh 103 Naresh 104 Mahesh 105 Rajesh 106 Pawan 107 Charan 108 Prasad 109 Arvind 110 Arjun 100 Ram 101 Ramesh 102 Suresh 103 Naresh 104 Mahesh 105 Rajesh 106 Pawan 107 Charan 108 Prasad 109 Arvind 110 Arjun 100 Ram

Washington Mumbai New York London Mumbai Washington Bristol AP Washington Mumbai New York Mumbai Washington Bristol AP Washington Mumbai New York Mumbai New York London Mumbai New York London Mumbai Washington Bristol AP Washington Mumbai New York London Mumbai New York London Mumbai Washington Bristol AP Washington Mumbai

US IN US UK IN US UK IN US IN US IN US UK IN US IN US IN US UK IN US UK IN US UK IN US IN US UK IN US UK IN US UK IN US IN

101 Ramesh 102 Suresh 103 Naresh 104 Mahesh 106 Pawan 107 Charan 108 Prasad 109 Arvind 110 Arjun 100 Ram 101 Ramesh 102 Suresh 103 Naresh 106 Pawan 107 Charan 108 Prasad 109 Arvind 110 Arjun 100 Ram 101 Ramesh 102 Suresh 106 Pawan 107 Charan 108 Prasad 109 Arvind 110 Arjun 100 Ram 101 Ramesh 106 Pawan 107 Charan 108 Prasad 109 Arvind 110 Arjun 100 Ram 101 Ramesh

New York London Mumbai New York Mumbai Washington Bristol AP Washington Mumbai New York London Mumbai Mumbai Washington Bristol AP Washington Mumbai New York London Mumbai Washington Bristol AP Washington Mumbai New York Mumbai Washington Bristol AP Washington Mumbai New York

US UK IN US IN US UK IN US IN US UK IN IN US UK IN US IN US UK IN US UK IN US IN US IN US UK IN US IN US