{"id":1651,"date":"2025-09-17T09:30:00","date_gmt":"2025-09-17T09:30:00","guid":{"rendered":"https:\/\/iwis.io\/results\/bat-data-always-at-hand-transforming-reporting-from-instability-to-control\/"},"modified":"2026-02-17T18:39:22","modified_gmt":"2026-02-17T18:39:22","slug":"bat-data","status":"publish","type":"portfolio","link":"https:\/\/iwis.io\/en\/results\/bat-data\/","title":{"rendered":"BAT Data Always at Hand: Transforming Reporting from Instability to Control"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"","protected":false},"featured_media":0,"template":"","meta":{"_acf_changed":false,"footnotes":""},"portfolio_category":[112],"portfolio_tag":[114,113],"class_list":["post-1651","portfolio","type-portfolio","status-publish","hentry","portfolio_category-business-intelligence-bi","portfolio_tag-business-intelligence-bi","portfolio_tag-data-engineering"],"acf":{"portfolio_project_image":5493,"portfolio_project_description":"British American Tobacco (BAT) is a global giant operating in 180 countries.","portfolio_project_tags":[114,113],"portfolio_project_url":"","portfolio_categories":[112],"portfolio_featured_project":false,"portfolio_about_label":"About the project","portfolio_about_title":"New Data Structure for BAT \u2013 Clearing the Smoke for Transparent Numbers","portfolio_about_description":"British American Tobacco (BAT) is a global giant operating in 180 countries. The company, uniting over 50,000 people, is known for its brands: Dunhill, Lucky Strike, Pall Mall, and Vuse. Today, BAT is undergoing a massive transformation from traditional tobacco industry to electronic cigarettes and tobacco heating systems. The leader actively invests, develops technologies, and supports sustainable development.   ","portfolio_about_problem_title":"Client Challenges and Needs:","problem_item_text_default":"The client faced difficulties with reporting. The system was unstable:","portfolio_about_problem_items":[{"portfolio_about_problem_item_text":"metrics were calculated with delays or inaccurately"},{"portfolio_about_problem_item_text":"performance was suboptimal"},{"portfolio_about_problem_item_text":"reports periodically became inaccessible"}],"problem_item_text_default_second":"This created risks for operational processes and complicated decision-making.\r\n\r\nThe client needed a reliable tool that would provide stable, continuous access to accurate data in a business-friendly format.","portfolio_about_problem_image":5493,"portfolio_details_label":"Project details","portfolio_details_title":"Key facts about the project","portfolio_details_cards":[{"portfolio_details_card_type":"text","portfolio_details_card_title":"12 months","portfolio_details_card_image":null,"portfolio_details_card_text":"Project duration"},{"portfolio_details_card_type":"text","portfolio_details_card_title":"Medium","portfolio_details_card_image":null,"portfolio_details_card_text":"Project size"},{"portfolio_details_card_type":"image","portfolio_details_card_title":"","portfolio_details_card_image":5492,"portfolio_details_card_text":"Project complexity"},{"portfolio_details_card_type":"text","portfolio_details_card_title":"Completed","portfolio_details_card_image":null,"portfolio_details_card_text":"Project status"}],"portfolio_team_label":"Our team:","portfolio_team_members":[{"portfolio_team_member_text":"Project Manager"},{"portfolio_team_member_text":"Business Analyst"},{"portfolio_team_member_text":"2 Data Engineers"},{"portfolio_team_member_text":"Data Analyst"}],"portfolio_solution_items":[{"media_type":"gif","gif_image":2098,"static_image":null,"solution_label":"How we solved the client's problem","solution_title":"Analytical reporting at BAT no longer brings chaos, as information is stored and processed in a multi-level system.","solution_points":[{"point_text":"Dispatching mechanisms ensure reliable control and instant notifications in case of failures.","point_has_bullet":false},{"point_text":"<strong>Our approach: <\/strong>We began with a detailed analysis of existing Power BI reports. We implemented initial corrections and partially stabilized the system's operation. Key issues were identified in data sources and their transportation process to Power BI. Our specialists developed several solution options with data warehouse implementation using various tools.","point_has_bullet":false}],"button_text":"","button_url":""},{"media_type":"gif","gif_image":2099,"static_image":null,"solution_label":"","solution_title":"Work results:","solution_points":[{"point_text":"Reporting became accessible, comprehensible, and reliable, while data ceased to be a problem \u2013 now it works for the business, not against it.","point_has_bullet":false},{"point_text":"Optimized Power BI: conducted an audit of existing reports, corrected calculation logic, improved performance.","point_has_bullet":false},{"point_text":"Built Data Warehouse architecture: implemented a multi-level model with Bronze and Silver layers for efficient data storage and processing.","point_has_bullet":false},{"point_text":"Set up ETL processes: automated data collection, cleaning, and transfer, minimizing risks of manual errors.","point_has_bullet":false},{"point_text":"Implemented dispatching: created a mechanism for data quality control and loading stability with automatic notifications in case of failures.","point_has_bullet":false},{"point_text":"Formed an infological model: clearly described all entities, their relationships, and analytics usage logic.","point_has_bullet":false}],"button_text":"","button_url":""}],"portfolio_results_slider_type":"desktop","portfolio_results_mobile_images":null,"portfolio_results_desktop_images":[{"portfolio_results_desktop_image":2102},{"portfolio_results_desktop_image":2100},{"portfolio_results_desktop_image":2103},{"portfolio_results_desktop_image":2101},{"portfolio_results_desktop_image":2102},{"portfolio_results_desktop_image":2100},{"portfolio_results_desktop_image":2103},{"portfolio_results_desktop_image":2101}],"portfolio_show_feedback_button":false,"portfolio_feedback_preview_image":null,"portfolio_feedback_video_url":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Case Study - Bat Data | IWIS<\/title>\n<meta name=\"description\" content=\"Discover how we helped bat data achieve their digital transformation goals\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/iwis.io\/en\/results\/bat-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Case Study - Bat Data | IWIS\" \/>\n<meta property=\"og:description\" content=\"Discover how we helped bat data achieve their digital transformation goals\" \/>\n<meta property=\"og:url\" content=\"https:\/\/iwis.io\/en\/results\/bat-data\/\" \/>\n<meta property=\"og:site_name\" content=\"iwis\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/IWIS.UKRAINE\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-17T18:39:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/iwis.io\\\/en\\\/results\\\/bat-data\\\/\",\"url\":\"https:\\\/\\\/iwis.io\\\/en\\\/results\\\/bat-data\\\/\",\"name\":\"Case Study - Bat Data | IWIS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/iwis.io\\\/en\\\/#website\"},\"datePublished\":\"2025-09-17T09:30:00+00:00\",\"dateModified\":\"2026-02-17T18:39:22+00:00\",\"description\":\"Discover how we helped bat data achieve their digital transformation goals\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/iwis.io\\\/en\\\/results\\\/bat-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/iwis.io\\\/en\\\/results\\\/bat-data\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/iwis.io\\\/en\\\/results\\\/bat-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/iwis.io\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BAT Data Always at Hand: Transforming Reporting from Instability to Control\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/iwis.io\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/iwis.io\\\/en\\\/\",\"name\":\"IWIS\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/iwis.io\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/iwis.io\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/iwis.io\\\/en\\\/#organization\",\"name\":\"IWIS\",\"url\":\"https:\\\/\\\/iwis.io\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/iwis.io\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/iwis.io\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/cropped-main-favicon.png\",\"contentUrl\":\"https:\\\/\\\/iwis.io\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/cropped-main-favicon.png\",\"width\":512,\"height\":512,\"caption\":\"IWIS\"},\"image\":{\"@id\":\"https:\\\/\\\/iwis.io\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/IWIS.UKRAINE\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/iwis-ukraine\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Case Study - Bat Data | IWIS","description":"Discover how we helped bat data achieve their digital transformation goals","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:\/\/iwis.io\/en\/results\/bat-data\/","og_locale":"en_US","og_type":"article","og_title":"Case Study - Bat Data | IWIS","og_description":"Discover how we helped bat data achieve their digital transformation goals","og_url":"https:\/\/iwis.io\/en\/results\/bat-data\/","og_site_name":"iwis","article_publisher":"https:\/\/www.facebook.com\/IWIS.UKRAINE\/","article_modified_time":"2026-02-17T18:39:22+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png","type":"image\/png"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/iwis.io\/en\/results\/bat-data\/","url":"https:\/\/iwis.io\/en\/results\/bat-data\/","name":"Case Study - Bat Data | IWIS","isPartOf":{"@id":"https:\/\/iwis.io\/en\/#website"},"datePublished":"2025-09-17T09:30:00+00:00","dateModified":"2026-02-17T18:39:22+00:00","description":"Discover how we helped bat data achieve their digital transformation goals","breadcrumb":{"@id":"https:\/\/iwis.io\/en\/results\/bat-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/iwis.io\/en\/results\/bat-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/iwis.io\/en\/results\/bat-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/iwis.io\/en\/"},{"@type":"ListItem","position":2,"name":"BAT Data Always at Hand: Transforming Reporting from Instability to Control"}]},{"@type":"WebSite","@id":"https:\/\/iwis.io\/en\/#website","url":"https:\/\/iwis.io\/en\/","name":"IWIS","description":"","publisher":{"@id":"https:\/\/iwis.io\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/iwis.io\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/iwis.io\/en\/#organization","name":"IWIS","url":"https:\/\/iwis.io\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/iwis.io\/en\/#\/schema\/logo\/image\/","url":"https:\/\/iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png","contentUrl":"https:\/\/iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png","width":512,"height":512,"caption":"IWIS"},"image":{"@id":"https:\/\/iwis.io\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/IWIS.UKRAINE\/","https:\/\/www.linkedin.com\/company\/iwis-ukraine\/"]}]}},"_links":{"self":[{"href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/1651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/types\/portfolio"}],"version-history":[{"count":1,"href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/1651\/revisions"}],"predecessor-version":[{"id":1718,"href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/1651\/revisions\/1718"}],"acf:term":[{"embeddable":true,"taxonomy":"portfolio_category","href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/portfolio_category\/112"},{"embeddable":true,"taxonomy":"portfolio_tag","href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/portfolio_tag\/113"},{"embeddable":true,"taxonomy":"portfolio_tag","href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/portfolio_tag\/114"}],"wp:attachment":[{"href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/media?parent=1651"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/portfolio_category?post=1651"},{"taxonomy":"portfolio_tag","embeddable":true,"href":"https:\/\/iwis.io\/en\/wp-json\/wp\/v2\/portfolio_tag?post=1651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}