Datatables

Below you see an example sales dataset that is formatted as a responsive datatable using DokuWiki plugin Datatables. The dataset is based on a download I found here. Initially, the table is sorted in ascending order on the first column. You can sort it on other columns by clicking on the heading of that column. Clicking a column header twice sets the order to descending. In the search box, you can type a word of an item included in one of the fields instantly filtering the rows. The total remaining rows are shown below the table.

Datatables can be used as a basic but efficient form of Business Intelligence solution to provide insight into sets of data. Its usability depends greatly on designing the right reporting formats and creating interlinked solutions. But that's no different from using “real” BI tools. I have used datatables on several projects. Data to be presented in these tables were provided through an API by external systems either by generating static DokuWiki pages on a daily basis or directly through pulling the data in at run-time.



Region Country Item Type Sales Channel Order year Units Sold Total Profit
Middle East and North Africa Libya Cosmetics Offline 2014 8446 1468506.02
North America Canada Vegetables Online 2011 3018 190526.34
Middle East and North Africa Libya Baby Food Offline 2016 1517 145419.62
Asia Japan Cereal Offline 2010 3322 294295.98
Sub-Saharan Africa Chad Fruits Offline 2011 9845 23726.45
Europe Armenia Cereal Online 2014 9528 844085.52
Sub-Saharan Africa Eritrea Cereal Online 2015 2844 251949.96
Europe Montenegro Clothes Offline 2012 7299 536038.56
Central America and the Caribbean Jamaica Vegetables Online 2015 2428 153279.64
Australia and Oceania Fiji Vegetables Offline 2013 4800 303024
Sub-Saharan Africa Togo Clothes Online 2015 3012 221201.28
Europe Montenegro Snacks Offline 2010 2694 148547.16
Europe Greece Household Online 2016 1508 249920.84
Sub-Saharan Africa Sudan Cosmetics Online 2015 4146 720865.02
Asia Maldives Fruits Offline 2011 7332 17670.12
Europe Montenegro Clothes Offline 2010 4820 353980.8
Europe Estonia Office Supplies Online 2016 2397 302621.25
North America Greenland Beverages Online 2012 2880 45100.8
Sub-Saharan Africa Cape Verde Clothes Online 2014 1117 82032.48
Sub-Saharan Africa Senegal Household Offline 2012 8989 1489746.97
Australia and Oceania Federated States of Micronesia Snacks Online 2012 407 22441.98
Europe Bulgaria Clothes Online 2010 6313 463626.72
Middle East and North Africa Algeria Personal Care Online 2011 9681 242605.86
Asia Mongolia Clothes Online 2015 515 37821.6
Central America and the Caribbean Grenada Cereal Online 2012 852 75478.68
Central America and the Caribbean Grenada Beverages Online 2017 9759 152825.94
Sub-Saharan Africa Senegal Beverages Offline 2014 8334 130510.44
North America Greenland Fruits Offline 2012 4709 11348.69
Sub-Saharan Africa Chad Meat Offline 2016 9043 517259.6
Sub-Saharan Africa Mauritius Personal Care Online 2016 8529 213736.74
Middle East and North Africa Morocco Beverages Offline 2017 2391 37443.06
Central America and the Caribbean Honduras Office Supplies Online 2015 6884 869105
Sub-Saharan Africa Benin Fruits Online 2014 293 706.13
Europe Greece Baby Food Offline 2014 7937 760840.82
Central America and the Caribbean Jamaica Beverages Offline 2010 7163 112172.58
Sub-Saharan Africa Equatorial Guinea Office Supplies Online 2010 2352 296940
Sub-Saharan Africa Swaziland Office Supplies Offline 2013 9915 1251768.75
Central America and the Caribbean Trinidad and Tobago Vegetables Offline 2011 3294 207950.22
Europe Sweden Baby Food Online 2016 7963 763333.18
Europe Belarus Office Supplies Online 2011 6426 811282.5
Sub-Saharan Africa Guinea-Bissau Office Supplies Offline 2014 3221 406651.25
Asia Mongolia Beverages Online 2013 9913 155237.58
Middle East and North Africa Turkey Meat Online 2011 103 5891.6
Sub-Saharan Africa Central African Republic Snacks Offline 2016 4419 243663.66
Sub-Saharan Africa Equatorial Guinea Office Supplies Offline 2015 5523 697278.75
Asia Laos Beverages Online 2013 3107 48655.62
Europe Armenia Meat Online 2010 8896 508851.2
Europe Greece Household Online 2012 1643 272294.39
Middle East and North Africa Israel Personal Care Offline 2015 2135 53503.1
Asia Bhutan Meat Online 2016 8189 468410.8
Australia and Oceania Vanuatu Vegetables Online 2012 9654 609457.02
Sub-Saharan Africa Burundi Vegetables Online 2010 3410 215273.3
Europe Ukraine Cosmetics Online 2014 8368 1454944.16
Europe Croatia Beverages Online 2016 470 7360.2
Sub-Saharan Africa Madagascar Fruits Online 2016 7690 18532.9
Asia Malaysia Snacks Offline 2012 5033 277519.62
Asia Uzbekistan Office Supplies Offline 2012 9535 1203793.75
Europe Italy Office Supplies Online 2011 5263 664453.75
Asia Nepal Vegetables Offline 2014 8316 524989.08
Australia and Oceania Fiji Personal Care Offline 2016 1824 45709.44
Europe Portugal Office Supplies Online 2014 949 119811.25
Central America and the Caribbean Panama Cosmetics Offline 2015 7881 1370269.47
Europe Belarus Beverages Offline 2013 6846 107208.36
Sub-Saharan Africa Botswana Clothes Offline 2015 9097 668083.68
Sub-Saharan Africa Tanzania Personal Care Online 2013 7921 198500.26
Europe Romania Office Supplies Offline 2013 3636 459045
Sub-Saharan Africa Mali Cereal Online 2012 8590 760988.1
Sub-Saharan Africa Central African Republic Office Supplies Offline 2014 2163 273078.75
Sub-Saharan Africa Niger Baby Food Online 2016 5766 552728.76
Europe Austria Office Supplies Online 2011 7841 989926.25
Asia India Fruits Online 2010 8862 21357.42
Europe Luxembourg Baby Food Offline 2013 6335 607273.1
Sub-Saharan Africa Cape Verde Beverages Offline 2013 9794 153374.04
Europe Sweden Vegetables Offline 2017 5808 366659.04
Europe Iceland Meat Offline 2015 2975 170170
Middle East and North Africa Qatar Personal Care Offline 2012 6925 173540.5
Sub-Saharan Africa South Sudan Meat Online 2013 5319 304246.8
Europe United Kingdom Office Supplies Online 2014 2850 359812.5
Middle East and North Africa Tunisia Cereal Online 2010 6241 552890.19
North America United States of America Office Supplies Online 2017 9247 1167433.75
Sub-Saharan Africa Liberia Cereal Online 2015 7653 677979.27
Sub-Saharan Africa Eritrea Snacks Offline 2010 4279 235944.06
Asia South Korea Fruits Offline 2010 3972 9572.52
Sub-Saharan Africa Kenya Clothes Offline 2013 8611 632391.84
Sub-Saharan Africa Rwanda Snacks Online 2017 2109 116290.26
Central America and the Caribbean Cuba Beverages Offline 2011 5408 84689.28
Middle East and North Africa Libya Cereal Offline 2014 1480 131113.2
Europe Czech Republic Snacks Online 2013 332 18306.48
Europe Montenegro Beverages Offline 2011 3999 62624.34
Europe Montenegro Clothes Offline 2016 1549 113758.56
Asia Philippines Baby Food Online 2014 4079 391012.94
Central America and the Caribbean El Salvador Clothes Offline 2010 9721 713910.24
Australia and Oceania Tonga Household Online 2013 8635 1431078.55
Sub-Saharan Africa Democratic Republic of the Congo Personal Care Offline 2010 8014 200830.84
Middle East and North Africa Afghanistan Cereal Online 2016 7081 627305.79
Australia and Oceania Tuvalu Snacks Offline 2011 2091 115297.74
Sub-Saharan Africa Sudan Fruits Online 2012 1331 3207.71
Sub-Saharan Africa Niger Clothes Online 2015 117 8592.48
Sub-Saharan Africa Gabon Household Offline 2013 5798 960902.54
Australia and Oceania East Timor Vegetables Offline 2014 2755 173923.15
North America United States of America Clothes Offline 2010 7398 543309.12
Middle East and North Africa Jordan Vegetables Offline 2015 3170 200122.1
Europe Cyprus Snacks Offline 2012 5544 305696.16
Sub-Saharan Africa Malawi Vegetables Online 2012 7025 443488.25
Europe Iceland Personal Care Online 2013 2149 53853.94
Middle East and North Africa Israel Personal Care Online 2016 2484 62249.04
Middle East and North Africa United Arab Emirates Snacks Offline 2011 1629 89823.06
Asia China Cosmetics Offline 2011 213 37034.31
Sub-Saharan Africa Kenya Beverages Online 2012 897 14047.02
Middle East and North Africa Somalia Clothes Offline 2011 3374 247786.56
Australia and Oceania Tonga Beverages Offline 2010 9367 146687.22
Asia Bangladesh Baby Food Online 2011 7632 731603.52
Middle East and North Africa Egypt Beverages Offline 2014 8954 140219.64
Sub-Saharan Africa Eritrea Cereal Offline 2014 1150 101878.5
Sub-Saharan Africa Swaziland Office Supplies Online 2015 4071 513963.75
Asia Vietnam Baby Food Online 2011 4594 440380.84
Australia and Oceania Marshall Islands Snacks Online 2012 1632 89988.48
Asia Taiwan Household Online 2017 1127 186777.71
Europe Ireland Vegetables Online 2012 1052 66412.76
Sub-Saharan Africa Rwanda Meat Offline 2010 6413 366823.6
Europe Sweden Snacks Online 2011 4245 234069.3
Sub-Saharan Africa Gabon Snacks Offline 2010 8615 475031.1
Sub-Saharan Africa South Africa Baby Food Online 2013 5624 539116.64
Europe United Kingdom Clothes Offline 2015 8399 616822.56
Europe Albania Fruits Offline 2011 2104 5070.64
Asia Malaysia Snacks Offline 2010 8929 492345.06
Sub-Saharan Africa Ghana Household Offline 2012 3098 513431.54
Central America and the Caribbean Cuba Clothes Offline 2011 5867 430872.48
Central America and the Caribbean Saint Lucia Cosmetics Online 2012 522 90760.14
Europe Romania Snacks Offline 2014 7379 406878.06
Europe Portugal Office Supplies Online 2015 8788 1109485
Europe Macedonia Beverages Online 2011 4129 64660.14
Asia China Beverages Offline 2013 4811 75340.26
Europe Germany Baby Food Online 2015 9279 889484.94
Europe Ireland Household Online 2014 8006 1326834.38
Europe Poland Office Supplies Offline 2015 8496 1072620
Sub-Saharan Africa Namibia Household Online 2013 285 47233.05
Asia Uzbekistan Personal Care Offline 2013 9942 249146.52
Sub-Saharan Africa Zimbabwe Meat Online 2014 6064 346860.8
Asia Mongolia Meat Offline 2015 4281 244873.2
Europe Norway Personal Care Online 2011 2256 56535.36
Middle East and North Africa Oman Snacks Offline 2013 4679 258000.06
Europe Serbia Cosmetics Online 2017 8275 1438774.25
Sub-Saharan Africa Democratic Republic of the Congo Fruits Offline 2017 6798 16383.18
Europe Bulgaria Baby Food Online 2014 6035 578515.1
Asia Brunei Baby Food Online 2015 8803 843855.58
Europe Serbia Snacks Offline 2013 9951 548698.14
Sub-Saharan Africa Ghana Cereal Offline 2013 1358 120305.22
Sub-Saharan Africa Malawi Cereal Offline 2014 6936 614460.24
Sub-Saharan Africa Zimbabwe Fruits Offline 2011 7627 18381.07
Europe Cyprus Snacks Offline 2010 6405 353171.7
Central America and the Caribbean Nicaragua Cereal Online 2011 3274 290043.66
Europe Estonia Baby Food Offline 2011 271 25978.06
Europe Estonia Clothes Online 2016 6463 474642.72
Europe Lithuania Fruits Offline 2013 2949 7107.09
Sub-Saharan Africa Republic of the Congo Meat Offline 2017 7859 449534.8
Europe Czech Republic Baby Food Online 2010 1353 129698.58
Sub-Saharan Africa Cameroon Snacks Online 2013 624 34407.36
Asia Vietnam Office Supplies Online 2016 4897 618246.25
Europe Moldova Meat Offline 2014 424 24252.8
Middle East and North Africa Bahrain Office Supplies Offline 2012 5494 693617.5
Europe Hungary Household Online 2017 5423 898753.79
Australia and Oceania Marshall Islands Personal Care Offline 2017 7559 189428.54
Middle East and North Africa Iraq Office Supplies Online 2011 6283 793228.75
Europe Albania Vegetables Online 2015 8006 505418.78
Sub-Saharan Africa Lesotho Office Supplies Online 2012 6170 778962.5
Middle East and North Africa Lebanon Clothes Offline 2015 6249 458926.56
Europe Hungary Vegetables Online 2014 748 47221.24
Asia Japan Beverages Online 2012 4203 65818.98
Europe Georgia Office Supplies Offline 2013 8180 1032725
Europe Estonia Office Supplies Online 2011 6280 792850
Europe Luxembourg Household Online 2014 9131 1513280.63
Sub-Saharan Africa Swaziland Personal Care Online 2017 9396 235463.76
Europe Romania Clothes Offline 2010 6765 496821.6
Sub-Saharan Africa Ethiopia Personal Care Offline 2010 2964 74277.84
Sub-Saharan Africa Chad Office Supplies Offline 2011 6746 851682.5
Middle East and North Africa Morocco Office Supplies Online 2014 8898 1123372.5
North America Mexico Clothes Online 2012 7237 531485.28
Sub-Saharan Africa Nigeria Personal Care Offline 2011 1612 40396.72
Central America and the Caribbean Trinidad and Tobago Beverages Offline 2012 8904 139436.64
Europe Moldova Personal Care Offline 2017 8022 201031.32
Australia and Oceania Solomon Islands Personal Care Online 2010 4909 123019.54
Asia India Personal Care Online 2015 7539 188927.34
Sub-Saharan Africa Burkina Faso Office Supplies Offline 2016 917 115771.25
Australia and Oceania Kiribati Meat Online 2010 2079 118918.8
Middle East and North Africa Israel Meat Offline 2010 5093 291319.6
Sub-Saharan Africa Comoros Snacks Offline 2014 6056 333927.84
Middle East and North Africa Iran Baby Food Offline 2014 8099 776370.14
Asia Vietnam Cosmetics Offline 2016 6384 1109986.08
Central America and the Caribbean Belize Household Online 2013 3101 513928.73
Europe Belarus Personal Care Offline 2012 2476 62048.56
North America United States of America Baby Food Offline 2015 5763 552441.18
Europe Poland Beverages Online 2012 6247 97828.02
North America Canada Vegetables Offline 2016 4247 268113.11
Middle East and North Africa Israel Beverages Offline 2011 2111 33058.26
Middle East and North Africa Lebanon Household Online 2016 9219 1527864.87
Europe Andorra Baby Food Online 2011 6982 669294.52
Europe Slovakia Clothes Online 2013 3843 282229.92
Sub-Saharan Africa Liberia Fruits Online 2010 274 660.34
Central America and the Caribbean Antigua and Barbuda Cereal Offline 2011 3782 335047.38