{"id":1446,"date":"2021-04-15T11:59:17","date_gmt":"2021-04-15T10:59:17","guid":{"rendered":"http:\/\/www.mjmenergy.com\/global\/?page_id=1446"},"modified":"2021-07-14T15:04:58","modified_gmt":"2021-07-14T14:04:58","slug":"data-gathering-analysis","status":"publish","type":"page","link":"https:\/\/www.mjmenergy.com\/global\/publishing\/data-gathering-analysis\/","title":{"rendered":"Data gathering \/ analysis"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1446\" class=\"elementor elementor-1446\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-70c47be4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"70c47be4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-501f8868\" data-id=\"501f8868\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8e03616 elementor-widget elementor-widget-text-editor\" data-id=\"8e03616\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div>With a strong core team MJMEnergy has been able to provide clients with extensive data gathering and analysis services covering a variety of areas including the following:<br \/><br \/><\/div><ul class=\"Apple-dash-list\"><li>Analysis of large quantities of data provided by clients using SQL.<\/li><li>Undertaking technical reviews of technologies deployed in the gas chain.<\/li><li>Gathering and analysing commercial contractual data for clients.<\/li><\/ul><div><\/div><div>Some examples of companies and organisations that MJMEnergy has worked with in providing data gathering and analysis services can be found below;<\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-30ab63a elementor-tabs-view-horizontal elementor-widget elementor-widget-tabs\" data-id=\"30ab63a\" data-element_type=\"widget\" data-widget_type=\"tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-tabs\">\n\t\t\t<div class=\"elementor-tabs-wrapper\" role=\"tablist\" >\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-5101\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-5101\" aria-expanded=\"false\">Daily News Report<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-5102\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-5102\" aria-expanded=\"false\">Singapore Gas Market Surveillance Panel<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-5103\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-5103\" aria-expanded=\"false\">LNG data for Cedigaz<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"elementor-tabs-content-wrapper\" role=\"tablist\" aria-orientation=\"vertical\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-5101\" aria-expanded=\"false\">Daily News Report<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-5101\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-5101\" tabindex=\"0\" hidden=\"false\"><h5>Background<\/h5><p><span data-contrast=\"auto\">Since late 2014 <\/span><span data-contrast=\"auto\">MJMEnergy<\/span><span data-contrast=\"auto\">\u00a0has been providing\u00a0<\/span><span data-contrast=\"auto\">Cedigaz<\/span><span data-contrast=\"auto\">\u00a0with a daily news bulletin service for its members on its website.<br \/><br \/><\/span><\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGnews-232x300.png\" alt=\"\" width=\"232\" height=\"300\" class=\"size-medium wp-image-1970 alignright\" srcset=\"https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGnews-232x300.png 232w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGnews-791x1024.png 791w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGnews-768x994.png 768w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGnews.png 1066w\" sizes=\"auto, (max-width: 232px) 100vw, 232px\" \/><\/p><h5>Brief overview of the project<\/h5><p><span data-ccp-props=\"{}\">T<\/span><span data-contrast=\"auto\">he report consists of<\/span><span data-contrast=\"auto\"> pickin<\/span><span data-contrast=\"auto\">g<\/span><span data-contrast=\"auto\">\u00a0up to 6 of the most popular Gas,\u00a0<\/span><span data-contrast=\"auto\">Unconventional Gas, LN<\/span><span data-contrast=\"auto\">G,<\/span><span data-contrast=\"auto\">\u00a0Hydrogen<\/span><span data-contrast=\"auto\"> or Bio-Gas stories, ranging for exploration, production to supply.\u00a0<br \/><br \/><\/span><\/p><h5><span data-contrast=\"auto\"><strong>Project implementation<\/strong><\/span><\/h5><p><span data-contrast=\"auto\">These stories then get compiled into a month<\/span><span data-contrast=\"auto\">ly CNR report by\u00a0<\/span><span data-contrast=\"auto\">Cedgiaz<\/span><span data-contrast=\"auto\">\u00a0which is made available to members for them to read. The most interesting stories from the month are highlighted and are put on to the\u00a0<\/span><span data-contrast=\"auto\">Cedigaz<\/span><span data-contrast=\"auto\"> website on the front page as a scrolling news service.<\/span><\/p><h5><\/h5><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-5102\" aria-expanded=\"false\">Singapore Gas Market Surveillance Panel<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-5102\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-5102\" tabindex=\"0\" hidden=\"hidden\"><h5>Background<\/h5>\n<p><span>Following the introduction of gas to gas competition in Singapore and the associated Network Code, the Energy Market Authority (EMA) was concerned that one or more gas shippers were attempting to game the network. Therefore EMA asked MJMEnergy to undertake a huge data gathering, monitoring and analysis exercise reporting the results to an independent panel made up of economists, lawyers and academics. The purpose of this analytical process was to identify inappropriate commercial and operational behaviour on the gas network otherwise known as \u2018gaming\u2019.<br><br><\/span><\/p>\n<h5>Brief overview of the project<\/h5>\n<p class=\"\"><span>As highlighted above from July 2010 to October 2013 MJMEnergy were appointed by the EMA to provide a data management and analysis service to the Gas Market Surveillance Panel (GMSP). This work entailed the analysis and manipulation of large amounts of gas shipper data in relation to Singapore\u2019s gas networks as shown below.<\/span><\/p>\n<ul class=\"\"><\/ul>\n<div><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/SingaporeTransmission-1024x693.png\" alt=\"\" width=\"750\" height=\"508\" class=\"wp-image-2232 size-large alignleft\" srcset=\"https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/SingaporeTransmission-1024x693.png 1024w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/SingaporeTransmission-300x203.png 300w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/SingaporeTransmission-768x520.png 768w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/SingaporeTransmission-1536x1040.png 1536w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/SingaporeTransmission-2048x1386.png 2048w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/div>\n<div>In order undertake the various analyses required by the GMSP, the MJMEnergy Project Team developed a number of key indices that allowed the evaluation of gas shipper behaviour on Singapores gas networks. Once this set of indices were agreed with the GMSP the MJMEnergy Project Team worked with EMA and the gas transporter to extract 1 TB of energy market data every quarter for market monitoring purposes.<\/div>\n<div><\/div>\n<div>Once the data had been downloaded the MJMEnergy Project Team undertook the following activities.<\/div>\n<ul class=\"Apple-dash-list\">\n<li>Manipulation and analysis of the data using a combination SQL code and Excel macros.<\/li>\n<li>The identification of key gas shipper behavioural issues based on the analysis of the data.<\/li>\n<li>The production of quarterly market monitoring reports.<\/li>\n<li>The presentation of the quarterly reports to the GMSP in Singapore.<\/li>\n<li>The presentation of the quarterly reports to the shipper community in Singapore.<br><br><\/li>\n<\/ul>\n<h5><strong>Conclusion<\/strong><\/h5>\n<p class=\"\"><span>This project involved the manipulation and analysis of 1TB of gas system network data every quarter for three years. During this time the MJMEnergy Project Team which consisted of database experts, analysts and network code experts identified a number of issues which were brought to the attention of the GMSP and ENA.<\/span><\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-5103\" aria-expanded=\"false\">LNG data for Cedigaz<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-5103\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-5103\" tabindex=\"0\" hidden=\"hidden\"><h5>Background<\/h5><p><span>Cedigaz provides an extensive gas market data gathering and analysis service for a number of clients throughout the world, which includes the provision of gas supply, demand, storage, LNG and shipping data. MJMEnergy has a long-term framework agreement with Cedigaz to gather much of this data. One of these data services is the monitoring of LNG cargo movements from around the world.<br \/><br \/><\/span><\/p><p><\/p><h5>Brief overview of the project<\/h5><div>In order to gather and manipulate the relevant data the MJMEnergy undertake the following activities on a monthly basis.<\/div><ul class=\"Apple-dash-list\"><li>Gathering data from customs databases.<\/li><li>Gathering data directly from LNG terminals.<\/li><li>A more recent endeavour, since May 2020, MJMEnergy have collated monthly import data for Cedigaz.<\/li><\/ul><div><p>Having gathered data from a variety of sources the MJMEnergy Project Team then use a series of macros to manipulate and store the data in a format that allows its transmission to Cedigaz&#8217;s online database without futher manhours.<\/p><\/div><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGmonthly-1024x418.png\" alt=\"\" width=\"750\" height=\"306\" class=\"aligncenter wp-image-1965 size-large\" data-wp-editing=\"1\" srcset=\"https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGmonthly-1024x418.png 1024w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGmonthly-300x122.png 300w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGmonthly-768x313.png 768w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGmonthly-1536x627.png 1536w, https:\/\/www.mjmenergy.com\/global\/wp-content\/uploads\/2021\/06\/LNGmonthly.png 1976w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p><h5>Conclusions<\/h5><p>This is an on-going project with the MJMEnergy Project Team gathering and analysing LNG shipping data for roughly one week each month. The process itself requires the analysts to be flexible and adaptable since data sources can change from month to month and new sources of LNG can come on stream with little notice.<\/p><\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-958f0ee elementor-widget elementor-widget-text-editor\" data-id=\"958f0ee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><a href=\"https:\/\/www.mjmenergy.com\/global\/publishing\/\">Go to Publishing overview<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>With a strong core team MJMEnergy has been able to provide clients with extensive data gathering and analysis services covering a variety of areas including the following: Analysis of large quantities of data provided by clients using SQL. Undertaking technical reviews of technologies deployed in the gas chain. Gathering and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":152,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1446","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mjmenergy.com\/global\/wp-json\/wp\/v2\/pages\/1446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mjmenergy.com\/global\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mjmenergy.com\/global\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mjmenergy.com\/global\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mjmenergy.com\/global\/wp-json\/wp\/v2\/comments?post=1446"}],"version-history":[{"count":46,"href":"https:\/\/www.mjmenergy.com\/global\/wp-json\/wp\/v2\/pages\/1446\/revisions"}],"predecessor-version":[{"id":2308,"href":"https:\/\/www.mjmenergy.com\/global\/wp-json\/wp\/v2\/pages\/1446\/revisions\/2308"}],"up":[{"embeddable":true,"href":"https:\/\/www.mjmenergy.com\/global\/wp-json\/wp\/v2\/pages\/152"}],"wp:attachment":[{"href":"https:\/\/www.mjmenergy.com\/global\/wp-json\/wp\/v2\/media?parent=1446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}