{"id":3458,"date":"2025-11-05T10:42:17","date_gmt":"2025-11-05T10:42:17","guid":{"rendered":"https:\/\/iwis.io\/results\/avtochernetka-3\/"},"modified":"2025-11-10T14:54:49","modified_gmt":"2025-11-10T14:54:49","slug":"interactive-analytics-for-swiss-krono","status":"publish","type":"portfolio","link":"https:\/\/iwis.io\/en\/results\/interactive-analytics-for-swiss-krono\/","title":{"rendered":"Interactive analytics for Swiss Krono: production control not in Excel, but in real time"},"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-3458","portfolio","type-portfolio","status-publish","hentry","portfolio_category-business-intelligence-bi","portfolio_tag-business-intelligence-bi","portfolio_tag-data-engineering"],"acf":{"portfolio_project_image":3459,"portfolio_project_description":"Swiss Krono is not just a brand, but one of the world leaders in the production of wood-based building materials.","portfolio_project_tags":[114,113],"portfolio_project_url":"","portfolio_categories":[112],"portfolio_featured_project":false,"portfolio_about_label":"About the project","portfolio_about_title":"The centralized model brought all of the company's data together into a single structure.","portfolio_about_description":"Swiss Krono is not just a brand, but one of the world leaders in the production of wood-based building materials. The company owns factories in Ukraine and more than 10 countries around the world. They provide a full cycle of production of laminate, chipboard, and OSB boards. Swiss Krono successfully combines technology with natural raw materials and shapes the future of construction and design. ","portfolio_about_problem_title":"The client's problem","problem_item_text_default":"The company used Excel-based reports, but this approach made it difficult to get a clear and timely view of production processes.
Manual data updates were time-consuming, and KPI analysis required constant clarifications and cross-checks.\n

Core issues:<\/strong><\/p>","portfolio_about_problem_items":[{"portfolio_about_problem_item_text":"no unified source of truth for data;"},{"portfolio_about_problem_item_text":"difficulty in tracking the actual status of production processes;"},{"portfolio_about_problem_item_text":"delays in creating and verifying reports."}],"problem_item_text_default_second":"Swiss Krono needed a modern solution to automate data processing, simplify analysis, and give management real-time visibility into production performance.","portfolio_about_problem_image":3459,"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":"1 month","portfolio_details_card_image":null,"portfolio_details_card_text":"Project duration"},{"portfolio_details_card_type":"text","portfolio_details_card_title":"Small","portfolio_details_card_image":null,"portfolio_details_card_text":"Project size:"},{"portfolio_details_card_type":"image","portfolio_details_card_title":"","portfolio_details_card_image":3539,"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":"Data Analyst"}],"portfolio_solution_items":[{"media_type":"image","gif_image":null,"static_image":3622,"solution_label":"Case information","solution_title":"The model built in Power BI has increased the efficiency of management decisions.","solution_points":[{"point_text":"The adaptive dashboard shows the actual state of production, identifies deviations, and helps you take action before problems arise.","point_has_bullet":false},{"point_text":"Our approach:<\/strong>","point_has_bullet":false},{"point_text":"IWIS specialists began working on the project by defining key production metrics and KPIs. These most accurately reflect production volumes, defect rates, equipment productivity, etc. Next, we structured the indicators for reporting, agreed on the logic of calculations, the level of detail, and the frequency of data updates. After agreeing on the model, we created a solution in Power BI based on it. It is capable of transforming complex tables into visual, understandable analytics for quick management decisions. <\/span>","point_has_bullet":false}],"button_text":"","button_url":""},{"media_type":"image","gif_image":null,"static_image":3461,"solution_label":"","solution_title":"Work results:","solution_points":[{"point_text":"Our collaboration with the customer transformed manual reporting into convenient digital management. Key implementation steps: <\/span>","point_has_bullet":false},{"point_text":"introduced an adaptive dashboard with filters by date, line, workshop, and shift;<\/span>","point_has_bullet":true},{"point_text":"