{"id":3846,"date":"2019-10-18T11:01:55","date_gmt":"2019-10-18T11:01:55","guid":{"rendered":"https:\/\/sigma-redesign.sigmainfo.net\/?case-studies=energy-saving-management-pentaho"},"modified":"2025-06-10T11:37:17","modified_gmt":"2025-06-10T11:37:17","slug":"energy-saving-management-pentaho","status":"publish","type":"case-studies","link":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/","title":{"rendered":"Energy Saving Management \u2013 Pentaho"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9ykhj2-09f115cd5e0697f27aa514652f27e8b5\">\n#top .av-special-heading.av-lz9ykhj2-09f115cd5e0697f27aa514652f27e8b5{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lz9ykhj2-09f115cd5e0697f27aa514652f27e8b5 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lz9ykhj2-09f115cd5e0697f27aa514652f27e8b5 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lz9ykhj2-09f115cd5e0697f27aa514652f27e8b5 av-special-heading-h1 blockquote modern-quote modern-centered'><h1 class='av-special-heading-tag'  itemprop=\"headline\"  >Energy Saving Management \u2013 Pentaho<\/h1><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9ymusg-f17fc32acc2fc8d4e8718668f587da78\">\n#top .hr.av-lz9ymusg-f17fc32acc2fc8d4e8718668f587da78{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-lz9ymusg-f17fc32acc2fc8d4e8718668f587da78 .hr-inner{\nwidth:50px;\nborder-color:#8dc321;\n}\n<\/style>\n<div  class='hr av-lz9ymusg-f17fc32acc2fc8d4e8718668f587da78 hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<div  class='flex_column av-1kgqvp2-227cdf8305a44487f4eb99e57273626e av_one_half first flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9ywzac-b293f03e6b09d8c545ffe9775f937997\">\n.avia-image-container.av-lz9ywzac-b293f03e6b09d8c545ffe9775f937997 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-lz9ywzac-b293f03e6b09d8c545ffe9775f937997 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-lz9ywzac-b293f03e6b09d8c545ffe9775f937997 av-styling- avia-align-center'   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-44025 avia-img-lazy-loading-not-44025 avia_image ' src=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o.webp\" alt='Energy Saving Management Pentaho' title='Energy Saving Management Pentaho'  height=\"800\" width=\"1200\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o.webp 1200w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o-300x200.webp 300w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o-1030x687.webp 1030w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o-768x512.webp 768w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o-705x470.webp 705w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/div><\/div><\/div><\/div>\n<div  class='flex_column av-1j589wm-3e4163b5d4eee8b3025ec5042c26fcc2 av_one_half flex_column_div  '     ><p><section  class='av_textblock_section av-lz9yvirs-a8d26ae8c3c2d2463131deb79048fb1b '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Sigma\u2019s web-based reporting solution, using Pentaho, helped in increasing portability, with over 5% saving in strategic analysis for a large energy company.<\/p>\n<\/div><\/section><br \/>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9yvr0o-45f83a5af4d188808a2c33194d0fca3f\">\n#top .av-special-heading.av-lz9yvr0o-45f83a5af4d188808a2c33194d0fca3f{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lz9yvr0o-45f83a5af4d188808a2c33194d0fca3f .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lz9yvr0o-45f83a5af4d188808a2c33194d0fca3f .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lz9yvr0o-45f83a5af4d188808a2c33194d0fca3f av-special-heading-h3 blockquote modern-quote'><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >Client Challenge<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div><br \/>\n<section  class='av_textblock_section av-lz9yw506-4ade01777651c5f50cf2dea69182f91d '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Global generation of energy across various modules uses a big part of the database, making a large number of transactions every day. There were times when a heavy load on the database caused it to crash, hence abruptly terminating the data loading and fetching process.<\/p>\n<\/div><\/section><\/p><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9yuqsp-db3034fd9ab57bfe9ba69e73e7bc756e\">\n#top .av-special-heading.av-lz9yuqsp-db3034fd9ab57bfe9ba69e73e7bc756e{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lz9yuqsp-db3034fd9ab57bfe9ba69e73e7bc756e .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lz9yuqsp-db3034fd9ab57bfe9ba69e73e7bc756e .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lz9yuqsp-db3034fd9ab57bfe9ba69e73e7bc756e av-special-heading-h2 blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Client Journey<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-5aav1y-46710952d7bddebf2ff92ab7aafa0aca\">\n#top .hr.av-5aav1y-46710952d7bddebf2ff92ab7aafa0aca{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-5aav1y-46710952d7bddebf2ff92ab7aafa0aca .hr-inner{\nwidth:50px;\nborder-color:#8dc321;\n}\n<\/style>\n<div  class='hr av-5aav1y-46710952d7bddebf2ff92ab7aafa0aca hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-lz9yv3ma-c403769a251daeb1586b56c9b5057945 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Experts from Sigma worked closely with the client organization to design an\u00a0<a href=\"https:\/\/www.sigmainfo.net\/bi-analytics\/\" target=\"_blank\" rel=\"noopener noreferrer\">Enterprise Business Intelligence<\/a>\u00a0Reporting Solution which enables real time information, to make data -driven decisions. The solution removed unnecessary caching problems in\u00a0<a href=\"https:\/\/www.sigmainfo.net\/pentaho-data-integration-kettle-writing-custom-step-plug-inextension-point\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pentaho Data Integration<\/a>\u00a0and, optimized the database and mondrian application for better performance., It also extracted data from JIRA and Google APIs and maintained heavy datasets of\u00a0around 300 gigs. The next phase involves creating more reports and generating cubes for various sub organizations.<\/p>\n<\/div><\/section>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-1dypt86-f4d78b774e82623675c24504d5489d92\">\n.avia-section.av-1dypt86-f4d78b774e82623675c24504d5489d92{\nbackground-repeat:no-repeat;\nbackground-image:url(https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/07\/business-office-work-300x200.webp);\nbackground-position:50% 50%;\nbackground-attachment:fixed;\n}\n.avia-section.av-1dypt86-f4d78b774e82623675c24504d5489d92 .av-section-color-overlay{\nopacity:0.9;\nbackground-color:#35383c;\n}\n<\/style>\n<div id='av_section_1'  class='avia-section av-1dypt86-f4d78b774e82623675c24504d5489d92 main_color avia-section-default avia-no-border-styling avia-full-stretch avia-bg-style-fixed av-section-color-overlay-active container_wrap sidebar_right'  data-section-bg-repeat='stretch'><div class=\"av-section-color-overlay-wrap\"><div class=\"av-section-color-overlay\"><\/div><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-3846'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-1ddmmza-62b84dde73e51b049bf3226e4f4f8ec3\">\n#top .av-special-heading.av-1ddmmza-62b84dde73e51b049bf3226e4f4f8ec3{\npadding-bottom:10px;\ncolor:#ffffff;\n}\nbody .av-special-heading.av-1ddmmza-62b84dde73e51b049bf3226e4f4f8ec3 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-1ddmmza-62b84dde73e51b049bf3226e4f4f8ec3 .special-heading-inner-border{\nborder-color:#ffffff;\n}\n.av-special-heading.av-1ddmmza-62b84dde73e51b049bf3226e4f4f8ec3 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-1ddmmza-62b84dde73e51b049bf3226e4f4f8ec3 av-special-heading-h2 custom-color-heading blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Benefits<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-1bpi2li-8b6065ba71aabc6d3715a78603860a19\">\n#top .hr.av-1bpi2li-8b6065ba71aabc6d3715a78603860a19{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-1bpi2li-8b6065ba71aabc6d3715a78603860a19 .hr-inner{\nwidth:50px;\nborder-color:#ffffff;\n}\n<\/style>\n<div  class='hr av-1bpi2li-8b6065ba71aabc6d3715a78603860a19 hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<div  class='flex_column av-19nwgsm-43382cd0ed05bce6b914e4b61106d74a av_one_half first flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9yrqq9-8f9f6016c6c5a33f84367c2dd5f189d4\">\n#top .avia-icon-list-container.av-lz9yrqq9-8f9f6016c6c5a33f84367c2dd5f189d4 .iconlist_icon{\ncolor:#ffffff;\n}\n#top #wrap_all .avia-icon-list-container.av-lz9yrqq9-8f9f6016c6c5a33f84367c2dd5f189d4 .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-lz9yrqq9-8f9f6016c6c5a33f84367c2dd5f189d4 .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-lz9yrqq9-8f9f6016c6c5a33f84367c2dd5f189d4'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-lz9yrqq9-8f9f6016c6c5a33f84367c2dd5f189d4 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-lz9yrha1-aa79381ce66f0a895f19d6fe5baee543 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p>Monthly technical availability is more than 98%.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lz9yt23m-5aa209e8b956f74a4e258ca8bffb7c59 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p>Monthly KPI, monthly audit vs. market performance report are now standardized and, available online in easily printable formats.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lz9ytauk-ff8abf71fa245166c28f6fcd0e85e837 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p>Analytical access to historical data for rigorous analysis and benchmarking with past.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div><\/div><div  class='flex_column av-17s06yu-1ed0d11105f25108973e866aa6c6b9bd av_one_half flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9yu0sn-e5417b082bb64022d8f9dca1dfbf7920\">\n#top .avia-icon-list-container.av-lz9yu0sn-e5417b082bb64022d8f9dca1dfbf7920 .iconlist_icon{\ncolor:#ffffff;\n}\n#top #wrap_all .avia-icon-list-container.av-lz9yu0sn-e5417b082bb64022d8f9dca1dfbf7920 .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-lz9yu0sn-e5417b082bb64022d8f9dca1dfbf7920 .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-lz9yu0sn-e5417b082bb64022d8f9dca1dfbf7920'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-lz9yu0sn-e5417b082bb64022d8f9dca1dfbf7920 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-lz9ytl68-605311fb1c99554dc7b53788ec88df29 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p>Complete set of data, functioning alarms in real-time.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lz9yts5l-82a8afe6a15c804ee5fb3c52c95e8d3d avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p>Ongoing operating costs at or lower than budget.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lz9ytzr5-eb3a014c91092feb1ee974ac070e6b5c avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p>Low system overhead and lower support costs.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div><\/div>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><\/div><div id='after_section_1'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-3846'><div class='entry-content-wrapper clearfix'>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='av_section_2'  class='avia-section av-2g9t46-13389aa8770c0306cc7ff634c33e9c89 main_color avia-section-default avia-no-border-styling avia-bg-style-scroll container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-3846'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9yu7cu-c5e4207fa62113c31768f8e204788cf9\">\n#top .av-special-heading.av-lz9yu7cu-c5e4207fa62113c31768f8e204788cf9{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lz9yu7cu-c5e4207fa62113c31768f8e204788cf9 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lz9yu7cu-c5e4207fa62113c31768f8e204788cf9 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lz9yu7cu-c5e4207fa62113c31768f8e204788cf9 av-special-heading-h2 blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Key Modules Developed<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-15auj4m-40959652d2e25ec88530f251a9501657\">\n#top .hr.av-15auj4m-40959652d2e25ec88530f251a9501657{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-15auj4m-40959652d2e25ec88530f251a9501657 .hr-inner{\nwidth:50px;\nborder-color:#8dc321;\n}\n<\/style>\n<div  class='hr av-15auj4m-40959652d2e25ec88530f251a9501657 hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-lz9yugak-1f57b1dad473af3affccbeb96444ecbf '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Developed charts, management dashboards, automatic data loading scripts, Jira Reports, Jobs to fetch Jira data etc. Operational Reports and KPIs for various projects broadcasted on a monthly basis to all the major stakeholders of the respective projects. Generate OLAP structures (Cubes and fact tables) for client database, Aggregate the data for various market places, ISOs and services, Developed Analytical reports and dashboards for the market pricing for Ancillary and Energy prices Developed the OLAP DB model, ETL and Analytical reports for Project\/Fleet data, Optimization of reporting and Analytical reports by improvising the performance across the different layers like DB optimization with buffering, query caching, partitioning, indexing, etc, Pentaho Mondrian cache optimization with smart refresh, Integration with 3rd party products or components.<\/p>\n<\/div><\/section>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_2'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-3846'><div class='entry-content-wrapper clearfix'>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='av_section_3'  class='avia-section av-12dyt7a-fb31da7e5da39bbc27fe948acfb7e6da main_color avia-section-default avia-no-border-styling avia-bg-style-scroll container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-3846'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9yonde-06667fe2c3a07cfeaa633cf62ead9949\">\n#top .av-special-heading.av-lz9yonde-06667fe2c3a07cfeaa633cf62ead9949{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lz9yonde-06667fe2c3a07cfeaa633cf62ead9949 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lz9yonde-06667fe2c3a07cfeaa633cf62ead9949 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lz9yonde-06667fe2c3a07cfeaa633cf62ead9949 av-special-heading-h2 blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Services <span class='special_amp'>&amp;<\/span> Technologies<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-11r4mfq-439dc9bad0b7d1a8973b95d86ebaa30f\">\n#top .hr.av-11r4mfq-439dc9bad0b7d1a8973b95d86ebaa30f{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-11r4mfq-439dc9bad0b7d1a8973b95d86ebaa30f .hr-inner{\nwidth:50px;\nborder-color:#8dc321;\n}\n<\/style>\n<div  class='hr av-11r4mfq-439dc9bad0b7d1a8973b95d86ebaa30f hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<div class='avia-data-table-wrap av-zta9gm-d65b86771e211f46385a098268fc5960 avia_responsive_table avia-table-1'><table  class='avia-table avia-data-table avia_pricing_default'  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/Table\" ><tbody><tr class=''><td class=''>Technology<\/td><td class=''>Services<\/td><\/tr><tr class=''><td class=''>Pentaho BI suite 3.6GA<\/td><td class=''>Pentaho<\/td><\/tr><tr class=''><td class=''>Pentaho Data Integration (earlier called Kettle)<\/td><td class=''><\/td><\/tr><tr class=''><td class=''>Mondrian Schema Workbench<\/td><td class=''><\/td><\/tr><tr class=''><td class=''>Crowd<\/td><td class=''><\/td><\/tr><tr class=''><td class=''>MySQL 5<\/td><td class=''><\/td><\/tr><\/tbody><\/table><\/div>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_3'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-3846'><div class='entry-content-wrapper clearfix'>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-4k0cza-363ee5c6300926984c06e2d0d31c8f1f\">\n.avia-section.av-4k0cza-363ee5c6300926984c06e2d0d31c8f1f{\nbackground-color:#f3f3f3;\nbackground-image:unset;\n}\n<\/style>\n<div id='av_section_4'  class='avia-section av-4k0cza-363ee5c6300926984c06e2d0d31c8f1f main_color avia-section-default avia-no-border-styling avia-bg-style-scroll container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-3846'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lz9yr0gr-2d5a0375a9dca205102fb0affaf00360\">\n#top .av-special-heading.av-lz9yr0gr-2d5a0375a9dca205102fb0affaf00360{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lz9yr0gr-2d5a0375a9dca205102fb0affaf00360 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lz9yr0gr-2d5a0375a9dca205102fb0affaf00360 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lz9yr0gr-2d5a0375a9dca205102fb0affaf00360 av-special-heading-h2 blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Build your success story with Sigma.<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<div  class='avia-button-wrap av-2vual2-c7136cce39f8f6cd130f8cacfeb278d3-wrap avia-button-center '>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-2vual2-c7136cce39f8f6cd130f8cacfeb278d3\">\n#top #wrap_all .avia-button.av-2vual2-c7136cce39f8f6cd130f8cacfeb278d3{\nfont-size:14px;\ntransition:all 0.4s ease-in-out;\n}\n<\/style>\n<a href='\/contact-us\/'  class='avia-button av-2vual2-c7136cce39f8f6cd130f8cacfeb278d3 av-link-btn avia-icon_select-yes-right-icon avia-size-large avia-position-center av-icon-on-hover avia-color-theme-color'  ><span class='avia_iconbox_title' >Connect with us<\/span><span class='avia_button_icon avia_button_icon_right' aria-hidden='true' data-av_icon='\ue87d' data-av_iconfont='entypo-fontello'><\/span><\/a><\/div>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_4'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-3846'><div class='entry-content-wrapper clearfix'>\n","protected":false},"excerpt":{"rendered":"<p>Sigma\u2019s web-based reporting solution, using Pentaho, helped in increasing portability, with over 5% saving in strategic analysis for a large energy company.<\/p>\n","protected":false},"author":28,"featured_media":44025,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3846","case-studies","type-case-studies","status-publish","has-post-thumbnail","hentry","case-studies-cat-bi-analytics","industries-oil-energy","casestudies-featured"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Energy Saving Management with Pentaho<\/title>\n<meta name=\"description\" content=\"Know how Sigma\u2019s web-based reporting solution pentaho increased portability of big energy company more than 5%. Read case study for complete solution!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/3846\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"opengraph-title\" \/>\n<meta property=\"og:description\" content=\"opengraph-description\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/\" \/>\n<meta property=\"og:site_name\" content=\"Sigma Infosolutions\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-10T11:37:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/06\/loading-image-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"twitter-title\" \/>\n<meta name=\"twitter:description\" content=\"twitter-description\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/06\/loading-image-1.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/\",\"url\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/\",\"name\":\"Energy Saving Management with Pentaho\",\"isPartOf\":{\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o.webp\",\"datePublished\":\"2019-10-18T11:01:55+00:00\",\"dateModified\":\"2025-06-10T11:37:17+00:00\",\"description\":\"Know how Sigma\u2019s web-based reporting solution pentaho increased portability of big energy company more than 5%. Read case study for complete solution!\",\"breadcrumb\":{\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#primaryimage\",\"url\":\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o.webp\",\"contentUrl\":\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o.webp\",\"width\":1200,\"height\":800,\"caption\":\"Energy Saving Management Pentaho\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Case Studies\",\"item\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"bctitle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/#website\",\"url\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/\",\"name\":\"Sigma Infosolutions\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-AU\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Energy Saving Management with Pentaho","description":"Know how Sigma\u2019s web-based reporting solution pentaho increased portability of big energy company more than 5%. Read case study for complete solution!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/3846","og_locale":"en_US","og_type":"article","og_title":"opengraph-title","og_description":"opengraph-description","og_url":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/","og_site_name":"Sigma Infosolutions","article_modified_time":"2025-06-10T11:37:17+00:00","og_image":[{"width":500,"height":500,"url":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/06\/loading-image-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_title":"twitter-title","twitter_description":"twitter-description","twitter_image":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/06\/loading-image-1.jpg","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/","url":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/","name":"Energy Saving Management with Pentaho","isPartOf":{"@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#primaryimage"},"image":{"@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#primaryimage"},"thumbnailUrl":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o.webp","datePublished":"2019-10-18T11:01:55+00:00","dateModified":"2025-06-10T11:37:17+00:00","description":"Know how Sigma\u2019s web-based reporting solution pentaho increased portability of big energy company more than 5%. Read case study for complete solution!","breadcrumb":{"@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#primaryimage","url":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o.webp","contentUrl":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/10\/15382148971_3050f4afa4_o.webp","width":1200,"height":800,"caption":"Energy Saving Management Pentaho"},{"@type":"BreadcrumbList","@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/energy-saving-management-pentaho\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sigma-ai.sigmainfo.net\/au\/"},{"@type":"ListItem","position":2,"name":"Case Studies","item":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/"},{"@type":"ListItem","position":3,"name":"bctitle"}]},{"@type":"WebSite","@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/#website","url":"https:\/\/sigma-ai.sigmainfo.net\/au\/","name":"Sigma Infosolutions","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sigma-ai.sigmainfo.net\/au\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-AU"}]}},"_links":{"self":[{"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/3846","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies"}],"about":[{"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/types\/case-studies"}],"author":[{"embeddable":true,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/comments?post=3846"}],"version-history":[{"count":11,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/3846\/revisions"}],"predecessor-version":[{"id":58374,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/3846\/revisions\/58374"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/media\/44025"}],"wp:attachment":[{"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/media?parent=3846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}