{"id":3850,"date":"2019-07-25T11:58:44","date_gmt":"2019-07-25T11:58:44","guid":{"rendered":"https:\/\/sigma-redesign.sigmainfo.net\/?case-studies=pentaho-web-based-reporting-system"},"modified":"2025-06-10T11:50:21","modified_gmt":"2025-06-10T11:50:21","slug":"pentaho-web-based-reporting-system","status":"publish","type":"case-studies","link":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/","title":{"rendered":"Pentaho Web Based Reporting System"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lzawdwq3-574085e706cc2c7d5ac98993e9b05323\">\n#top .av-special-heading.av-lzawdwq3-574085e706cc2c7d5ac98993e9b05323{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lzawdwq3-574085e706cc2c7d5ac98993e9b05323 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lzawdwq3-574085e706cc2c7d5ac98993e9b05323 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lzawdwq3-574085e706cc2c7d5ac98993e9b05323 av-special-heading-h1 blockquote modern-quote modern-centered'><h1 class='av-special-heading-tag'  itemprop=\"headline\"  >Pentaho Web Based Reporting System<\/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-10ou8iy-501b371495b4007abb959a97b45cce0e\">\n#top .hr.av-10ou8iy-501b371495b4007abb959a97b45cce0e{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-10ou8iy-501b371495b4007abb959a97b45cce0e .hr-inner{\nwidth:50px;\nborder-color:#8dc321;\n}\n<\/style>\n<div  class='hr av-10ou8iy-501b371495b4007abb959a97b45cce0e 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-zs11dm-ca93762fc06f5a3226804c5065257f7c av_one_half first flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lzawhqnr-cae888d1f55e47de347a06a4811c8c22\">\n.avia-image-container.av-lzawhqnr-cae888d1f55e47de347a06a4811c8c22 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-lzawhqnr-cae888d1f55e47de347a06a4811c8c22 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-lzawhqnr-cae888d1f55e47de347a06a4811c8c22 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-44136 avia-img-lazy-loading-not-44136 avia_image ' src=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1.webp\" alt='Pentaho Web Based Reporting System' title='Pentaho Web Based Reporting System'  height=\"1200\" width=\"1200\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1.webp 1200w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1-300x300.webp 300w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1-1030x1030.webp 1030w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1-80x80.webp 80w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1-768x768.webp 768w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1-36x36.webp 36w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1-180x180.webp 180w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1-705x705.webp 705w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/div><\/div><\/div><\/div>\n<div  class='flex_column av-xw74fe-fb42f06bc6e6f3776a3314dd8bfe28d1 av_one_half flex_column_div  '     ><p><section  class='av_textblock_section av-lzawhyas-68a19c2fd666af2888b784c864b480cb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Improved customer convenience through Sigma\u2019s web based reporting system.<\/p>\n<\/div><\/section><br \/>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lzawi6jh-46f61e4d7d2250838374cfe1f6ed0976\">\n#top .av-special-heading.av-lzawi6jh-46f61e4d7d2250838374cfe1f6ed0976{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lzawi6jh-46f61e4d7d2250838374cfe1f6ed0976 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lzawi6jh-46f61e4d7d2250838374cfe1f6ed0976 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lzawi6jh-46f61e4d7d2250838374cfe1f6ed0976 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-lzawiegj-ac3b8526cd4fe3a6ee80fa6a97922064 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>The client has been a leading provider of information on crude oil and natural gas prices to customers, ranging from industrial consumers, marketers, oil and gas operators, investors, litigation support, etc. The client combines multiple data sources into a single repository system.<\/p>\n<p>Due to the scale of the client\u2019s information sources, the database exponentially grew to a size of more than 100 million records. Since, the client never organized the database, Pentaho\u2019s reporting tool took 15-20 minutes to compile one report. However, conditioning the database to improve search results, while reducing the report compilation time to a few seconds was challenging. Adding to this, Pentaho\u2019s pagination functionality was not serving the client\u2019s business need. Therefore, this system could not give real-time information to the users, thereby impacting the business.<\/p>\n<\/div><\/section><\/p><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lzawip5k-3df132826884269275dcfaf45c08d7bd\">\n#top .av-special-heading.av-lzawip5k-3df132826884269275dcfaf45c08d7bd{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lzawip5k-3df132826884269275dcfaf45c08d7bd .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lzawip5k-3df132826884269275dcfaf45c08d7bd .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lzawip5k-3df132826884269275dcfaf45c08d7bd av-special-heading-h3 blockquote modern-quote'><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >Client Journey<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<section  class='av_textblock_section av-lzawj9sp-23a4f18012ad0509f3f7f783ae70323d '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Experts from Sigma worked closely with the client organization to develop, integrate, and test a comprehensive\u00a0<a href=\"https:\/\/www.sigmainfo.net\/bi-analytics\/\">BI solution<\/a>. Sigma\u2019s team understood the system requirements and functionalities of the new system. Post this,<br \/>\nthe team migrated the database from Foxpro to MySQL and then started developing the reporting tool using Pentaho and BIRT. The new system now:<\/p>\n<\/div><\/section>\n<div  class='avia-icon-list-container av-lzawlyth-b6aa72c7a9fa350219e59eafa4134bf4'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-lzawlyth-b6aa72c7a9fa350219e59eafa4134bf4 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-lzawju2q-a65b0f07a14ba05b7c9c7597ad4e9583 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 '  itemprop=\"text\" ><p>Provides role-based access to business users.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lzawk55n-0205d52834b524b9fa6f4f6e99f1f015 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 '  itemprop=\"text\" ><p>Generates big and complex cross-tabbed reports in a few seconds.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lzawke3c-1d6d41bbe657b99f1716b4fcd3dee0e1 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 '  itemprop=\"text\" ><p>Executes complex conditional column computations.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lzawkqyx-41c74b1516e209aabc15c1b0d9ec4fc8 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 '  itemprop=\"text\" ><p>Extends the ability to export the report in MS Excel and PDF format.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lzawl48t-76766f723641c0d9bee4baea053485a3 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 '  itemprop=\"text\" ><p>Paginates the results of a report by page(s).<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lzawlgwk-9c95c17b7539ca6d603d26f6dcd551a4 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 '  itemprop=\"text\" ><p>Generate more than 13 reports including 4 Ad Valorem reports.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lzawlx2p-bc76ba7f50bcb81e0ab350234330a19b 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 '  itemprop=\"text\" ><p>Generates analytic reports which show index comparisons, well head comparisons of multiple leases and their prices, pricing data required for annual Ad Valorem tax preparations.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div>\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-vplwkq-908b1a4b394c4f677980922ca0731b5d\">\n.avia-section.av-vplwkq-908b1a4b394c4f677980922ca0731b5d{\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-vplwkq-908b1a4b394c4f677980922ca0731b5d .av-section-color-overlay{\nopacity:0.9;\nbackground-color:#35383c;\n}\n<\/style>\n<div id='av_section_1'  class='avia-section av-vplwkq-908b1a4b394c4f677980922ca0731b5d 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-3850'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-uphyqi-4e06e3f108fad263f414df7ff2d04170\">\n#top .av-special-heading.av-uphyqi-4e06e3f108fad263f414df7ff2d04170{\npadding-bottom:10px;\ncolor:#ffffff;\n}\nbody .av-special-heading.av-uphyqi-4e06e3f108fad263f414df7ff2d04170 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-uphyqi-4e06e3f108fad263f414df7ff2d04170 .special-heading-inner-border{\nborder-color:#ffffff;\n}\n.av-special-heading.av-uphyqi-4e06e3f108fad263f414df7ff2d04170 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-uphyqi-4e06e3f108fad263f414df7ff2d04170 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-t63d6i-03709cacc0308ffbfc0ab51e127b4b96\">\n#top .hr.av-t63d6i-03709cacc0308ffbfc0ab51e127b4b96{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-t63d6i-03709cacc0308ffbfc0ab51e127b4b96 .hr-inner{\nwidth:50px;\nborder-color:#ffffff;\n}\n<\/style>\n<div  class='hr av-t63d6i-03709cacc0308ffbfc0ab51e127b4b96 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-rmd6yi-16e589441fb9b04f12c375c30a42887b av_one_half first flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lzawmxfq-a9059f0c2a339acd939428af1ed97c32\">\n#top .avia-icon-list-container.av-lzawmxfq-a9059f0c2a339acd939428af1ed97c32 .iconlist_icon{\ncolor:#ffffff;\n}\n#top #wrap_all .avia-icon-list-container.av-lzawmxfq-a9059f0c2a339acd939428af1ed97c32 .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-lzawmxfq-a9059f0c2a339acd939428af1ed97c32 .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-lzawmxfq-a9059f0c2a339acd939428af1ed97c32'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-lzawmxfq-a9059f0c2a339acd939428af1ed97c32 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-lzawmord-80df02e7ab96006ef3424f9b813487ed 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>Gave customers 24\/7 access to information.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-lzawmvx6-176fe14b12f9f86ac3a773b69590f3a0 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>Reduced turnaround time for sign ups from few days to a few seconds.<\/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-p8vchm-124b02fc9395e256d3c9e29943503715 av_one_half flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lzawnd5l-d952d2c3e9808e9b48c59589af8a4162\">\n#top .avia-icon-list-container.av-lzawnd5l-d952d2c3e9808e9b48c59589af8a4162 .iconlist_icon{\ncolor:#ffffff;\n}\n#top #wrap_all .avia-icon-list-container.av-lzawnd5l-d952d2c3e9808e9b48c59589af8a4162 .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-lzawnd5l-d952d2c3e9808e9b48c59589af8a4162 .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-lzawnd5l-d952d2c3e9808e9b48c59589af8a4162'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-lzawnd5l-d952d2c3e9808e9b48c59589af8a4162 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-lzawnbl7-27ace6c09617e053f8749eea27d0463c 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>Saved overheads on CD procurement, management and distribution.<\/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-3850'><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-o36czu-32b05586d4c6f81ebdb821687d4d7ba0 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-3850'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lzawnlgt-1c60f40523b48d072e740064726db364\">\n#top .av-special-heading.av-lzawnlgt-1c60f40523b48d072e740064726db364{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lzawnlgt-1c60f40523b48d072e740064726db364 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lzawnlgt-1c60f40523b48d072e740064726db364 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lzawnlgt-1c60f40523b48d072e740064726db364 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-m58zzu-48f8378bc84edf56d9f764199f77300b\">\n#top .hr.av-m58zzu-48f8378bc84edf56d9f764199f77300b{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-m58zzu-48f8378bc84edf56d9f764199f77300b .hr-inner{\nwidth:50px;\nborder-color:#8dc321;\n}\n<\/style>\n<div  class='hr av-m58zzu-48f8378bc84edf56d9f764199f77300b 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-kdwwnu-95ff73b4f85fa720db3abd4b7499186c 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=''>Pentaho Data Integration<\/td><td class=''>Pentaho 3.5 Reporting<br \/>\n<\/td><\/tr><tr class=''><td class=''>BIRT<\/td><td class=''>BIRT Reporting Tool<br \/>\n<\/td><\/tr><tr class=''><td class=''>Business Intelligence<br \/>\n<\/td><td class=''>Pentaho Data Integration<br \/>\n<\/td><\/tr><\/tbody><\/table><\/div>\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-3850'><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-4y8emi-20f179f27fd485cea9633a815b021287\">\n.avia-section.av-4y8emi-20f179f27fd485cea9633a815b021287{\nbackground-color:#f3f3f3;\nbackground-image:unset;\n}\n<\/style>\n<div id='av_section_3'  class='avia-section av-4y8emi-20f179f27fd485cea9633a815b021287 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-3850'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-lzawgnco-5cf9f050290d4fb0d9ee30ce4640a972\">\n#top .av-special-heading.av-lzawgnco-5cf9f050290d4fb0d9ee30ce4640a972{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-lzawgnco-5cf9f050290d4fb0d9ee30ce4640a972 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-lzawgnco-5cf9f050290d4fb0d9ee30ce4640a972 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-lzawgnco-5cf9f050290d4fb0d9ee30ce4640a972 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-24gcre-8561720a1c3ccebb6021e10271c2042a-wrap avia-button-center '>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-24gcre-8561720a1c3ccebb6021e10271c2042a\">\n#top #wrap_all .avia-button.av-24gcre-8561720a1c3ccebb6021e10271c2042a{\nfont-size:14px;\ntransition:all 0.4s ease-in-out;\n}\n<\/style>\n<a href='\/contact-us\/'  class='avia-button av-24gcre-8561720a1c3ccebb6021e10271c2042a 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_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-3850'><div class='entry-content-wrapper clearfix'>\n","protected":false},"excerpt":{"rendered":"<p>Improved customer convenience through Sigma\u2019s web based reporting system.The client has been a leading provider of information on crude oil and natural gas prices to customers, ranging from industrial consumers, marketers, oil and gas operators, investors, litigation support, etc. The client combines multiple data sources into a single repository system.<\/p>\n","protected":false},"author":28,"featured_media":44136,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3850","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>Web-Based Reporting with Pentaho<\/title>\n<meta name=\"description\" content=\"Explore How Pentaho Web Based Reporting System was created by Sigma team. Experts from Sigma worked closely with the client organization to develop, integrate, and test a comprehensive BI solution. Learn more.\" \/>\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\/3850\" \/>\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\/pentaho-web-based-reporting-system\/\" \/>\n<meta property=\"og:site_name\" content=\"Sigma Infosolutions\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-10T11:50:21+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\/pentaho-web-based-reporting-system\/\",\"url\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/\",\"name\":\"Web-Based Reporting with Pentaho\",\"isPartOf\":{\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1.webp\",\"datePublished\":\"2019-07-25T11:58:44+00:00\",\"dateModified\":\"2025-06-10T11:50:21+00:00\",\"description\":\"Explore How Pentaho Web Based Reporting System was created by Sigma team. Experts from Sigma worked closely with the client organization to develop, integrate, and test a comprehensive BI solution. Learn more.\",\"breadcrumb\":{\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#primaryimage\",\"url\":\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1.webp\",\"contentUrl\":\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1.webp\",\"width\":1200,\"height\":1200,\"caption\":\"Pentaho Web Based Reporting System\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#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":"Web-Based Reporting with Pentaho","description":"Explore How Pentaho Web Based Reporting System was created by Sigma team. Experts from Sigma worked closely with the client organization to develop, integrate, and test a comprehensive BI solution. Learn more.","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\/3850","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\/pentaho-web-based-reporting-system\/","og_site_name":"Sigma Infosolutions","article_modified_time":"2025-06-10T11:50:21+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\/pentaho-web-based-reporting-system\/","url":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/","name":"Web-Based Reporting with Pentaho","isPartOf":{"@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#primaryimage"},"image":{"@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#primaryimage"},"thumbnailUrl":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1.webp","datePublished":"2019-07-25T11:58:44+00:00","dateModified":"2025-06-10T11:50:21+00:00","description":"Explore How Pentaho Web Based Reporting System was created by Sigma team. Experts from Sigma worked closely with the client organization to develop, integrate, and test a comprehensive BI solution. Learn more.","breadcrumb":{"@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#primaryimage","url":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1.webp","contentUrl":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2019\/07\/web-based-reporting1.webp","width":1200,"height":1200,"caption":"Pentaho Web Based Reporting System"},{"@type":"BreadcrumbList","@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/pentaho-web-based-reporting-system\/#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\/3850","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=3850"}],"version-history":[{"count":5,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/3850\/revisions"}],"predecessor-version":[{"id":58379,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/3850\/revisions\/58379"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/media\/44136"}],"wp:attachment":[{"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/media?parent=3850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}