Article

DATA-DRIVEN SOLUTIONS

3 min read

  • Vágólapra másolva

Can you understand a table without headers?

The key to successful data warehouse integration projects: effective collaboration with source system Stakeholders. Many tend to focus only on business stakeholders during data warehouse integration projects, yet source system stakeholders are just as critical. Their involvement (securing their “buy-in”) is a key prerequisite for a successful integration - whether it’s about data loading or understanding the data itself. Effective collaboration with source system stakeholders in the assessment phase determines the success of a project through three key factors.

Shutterstock 2510417095

1. Response Time

Fast and efficient communication is essential for smooth project progress. If response times are slow, or there is no expert available for direct clarification, delays can occur as early as the assessment phase, jeopardizing the overall project timeline.

2. Source System Documentation

Well-documented source systems help in understanding data flows. Incomplete or inaccurate documentation can lead to misleading conclusions during the assessment phase, potentially resulting in data loss or faulty integration later.

For example, if the source system doesn’t provide data types, you’re left with two bad options:

  • Play it safe, increasing database size and reducing performance, or

  • Make assumptions, risking data flow interruptions and availability issues.

3. Data Quality

Data accuracy and reliability are fundamental, and poor quality can create roadblocks from the very beginning of an integration project. This applies not only to business data but also to metadata, which is equally crucial in integration projects.


For instance, can you determine exactly what data a table contains without headers?
Such data quality issues don’t just complicate the assessment phase—they also hinder data transfers.

For a project to truly succeed, source system stakeholders must actively participate, making integration a shared goal. But what if that ideal level of cooperation isn’t possible?

There are still ways to move forward: analyzing existing reports based on the source system and gaining direct access to the system’s user interface can be invaluable in uncovering hard-to-find answers.

About author

Zsofi
Zsófi Udvardi

BI Analyst

Analytics - BI Solution Delivery

As a BI Analyst, Zsófi Udvardi focuses on assessing business processes and reporting needs, as well as designing, implementing, and operating data warehouse solutions that align with business requirements. She has experience in the commercial, energy, telecommunications, and financial sectors. Her successful project management is supported by her diverse IT project experience as a senior consultant.

What business problem
can we help you solve?

Left hand art Right hand art
Contact us!

You may also like these

adat-az-uj-olaj

Article

DATA-DRIVEN SOLUTIONS

"Data is the new oil!" - The motto of today's IVSZ Data Economy Conference claims

Our Senior Data Scientist demonstrated the implementation and operation of cloud-based data warehouses and a recommendation engine based on machine learning within the framework of a case study.

1 min read

section-3

Article

DATA-DRIVEN SOLUTIONS

Drag race on the data highway

An interview with our Analytics BU Director, János Fazekas, was published in the February issue of Computerworld.

1 min read

IMG_2642_

Article

DATA-DRIVEN SOLUTIONS

Budapest BI Forum presentation

MOL Group's consumer services: Evolution towards a world-class data-driven operation and culture.

1 min read

Miért jó nekünk az IOT? – 1. rész

Article

DATA-DRIVEN SOLUTIONS

Why IoT is good for us - Part 1

In this forum, we already superficially touched on what exactly the Internet of Things (IoT) is, so before we dive into explaining the benefits of IoT, let us refresh our knowledge.

1 min read

Miért jó nekünk az IOT? – 2. rész

Article

DATA-DRIVEN SOLUTIONS

Why IoT is good for us - Part 2

In the previous part of this article, we described the benefits and areas of use of the Internet of Things, and now it's time to get down to specifics! The best and most instructive way to describe how IoT works is by following through our joint work with FF-tech, so without further ado, let's get started!

1 min read

Modern ellátási láncok, avagy kereslet előrejelzés és tervezés adat alapokon

Article

DATA-DRIVEN SOLUTIONS

Modern supply chains, or demand forecasting and planning based on data

Even before the global supply problems of the past two years emerged, it was clear that companies needed to modernise their supply chains and the IT systems that support them. In international sales and distribution, the problems created by the epidemic and increasingly complex supply systems are actually forcing companies to reformulate the tools they use to forecast and plan demand. Modernisation is therefore inevitable, but companies are often finding it difficult to take the first step. What is the reason for this? McKinsey dedicated an entire stand-alone study to this topic in 2021; the results obtained and the conclusions drawn from them are summarised below in this article.

6 min read

Hogyan mérjük fel a kereset várható mértékét?

Article

DATA-DRIVEN SOLUTIONS

4 min read

Hogyan mérjük fel a kereset várható mértékét? – 2. rész

Article

DATA-DRIVEN SOLUTIONS

How to measure the expected level of demand? - Part 2

In the previous part of this article, we investigated the role of data in forecasting demand, and described our previous project where we built a model to forecast sales for nearly a month ahead. In today's article, we summarise the lessons we learned to see if it worked!

4 min read

egy-okosgyar-szamokban-48-kal-kevesebb-hiba-es-67-kal-gyorsabb-mukodes

Article

DATA-DRIVEN SOLUTIONS

A smart factory in numbers: 48% fewer errors and 67% faster operation

In a previous article, we analysed in detail the concept of the smart factory. In this blog post, we present a successful production environment where data helped to improve competitiveness and sustainability. Let's take a closer look at two of Schneider Electric's top-performing intelligent factories!

4 min read

Futuristic,Concept:,Blurry,Factory,Digitalization,With,Information,Showing,Efficiency,Percentage

Article

DATA-DRIVEN SOLUTIONS

Case study: Anomaly detection, predictive maintenance

The state-of-the-art solution for anomaly detection rests on an AI system solution based on unsupervised learning that, by learning past usage patterns and general operational routines, continuously monitors unexpected, out-of-the-ordinary events in the system by forming user or operational groups, so-called clusters, from these patterns. It then determines the severity grade of the event compared to predefined standard levels and sends out a corresponding alert. In the following article, we analyse an applied case of this technology:

3 min read

Hatékony hibafeltárás a mesterséges intelligencia alkalmazásával

Article

DATA-DRIVEN SOLUTIONS

Effective anomaly detection using artificial intelligence

Automation significantly increases productivity, but unprecedented failures in - often complex - systems that provide automation result in significant financial losses. - Your choice?

5 min read

Stratis - Újít a Lidl: megváltozik az árufeltöltés a boltok polcainál

Article

DATA-DRIVEN SOLUTIONS

Lidl innovates: Changes to shelf-stocking

Lidl Hungary is going to stock its shelves with world-class, cutting-edge technology: The supermarket chain is introducing an internet-based automated ordering system called Auto Dispo, which allows for the optimal determination and automatic ordering of the quantities needed for running daily sales. The latest innovation not only supports more efficient daily operations, optimum product availability, and smooth inbound deliveries, but also allows a further reduction of generated food surpluses.

5 min read

A közösen kidolgozott digitalizációs fejlesztési tervre épülő projektek már önállóan is jó eséllyel sikeresek lesznek

Article

DATA-DRIVEN SOLUTIONS

Data-driven operation in industry

Data create communication not only between machines, but also between people and machines. Already in 2017, I came across the opinion that data analysis is no longer just a good option, but should be a ‘must’, a core activity of a company. It's industry branch-dependent, I used to add at the time, and I still believe that a manufacturing company should first and foremost produce good quality products on time. However, there is no doubt that business management and production information can and should be turned into business value through analytics. The ‘how’ was explained by Sándor Gáspár, Head of Data Solutions Competence Center at Stratis, and Péter Géró, founding partner of the company, to curious Factory of the Future readers.

12 min read

Stratis - “MERT AZ ADATOKON ALAPULÓ DÖNTÉSEK JOBBAK" – A STRATIS otthonosan mozog az iparban is!

Article

DATA-DRIVEN SOLUTIONS

"BECAUSE DATA-BASED DECISIONS ARE BETTER" - STRATIS is also at home in industry!

STRATIS was delighted to be a participant in the 10th AUTOMOTIVE HUNGARY / MACHTECH / INDUSTRY DAYS International Suppliers' Exhibition at HUNGEXPO in May 2022. The exhibition was held in the spirit of the fourth industrial revolution. AUTOMOTIVE has always been committed to showcasing the latest technologies and trends. One of the key messages of this year's AUTOMOTIVE exhibition was that manufacturing companies have come to recognise that they can gain a competitive advantage by consciously exploiting the data assets they have accumulated over the years. STRATIS' more than 20 years of experience and its outstanding experts can support you in this.

3 min read

Folyamatbányászat, azaz egy vállalat működésének megértése az adatokon keresztül

Article

DATA-DRIVEN SOLUTIONS

Process mining - Understanding through data how a company works

In our previous article, we wrote about optimisation - the process of revealing and exploiting the available reserves inherent in the production environment through the analysis of our performance and the data and information that describe it.

3 min read

Esettanulmány: hogyan csökkentette költségeit egy gyártó vállalat a folyamatbányászat során feltárt insight-ok alapján

Article

DATA-DRIVEN SOLUTIONS

Case study: How a manufacturing company reduced its costs based on insights gained during process mining

Process mining helps companies to collect and analyse the information they need to optimise their processes.

3 min read

stratis-blog-magyar-ipari-celgep

Article

DATA-DRIVEN SOLUTIONS

Successful Stratis participation at the Hungarian Special Industrial Machine Grand Prix

Along with more than 60 other special custom-made machines, Stratis Ltd. also competed in the 2022 Hungarian Special Industrial Machine Grand Prix. The Grand Prix was organized for the second time by the Scientific Association for Mechanical Engineering (GTE) in cooperation with Chemplex Kft. Like the organisers, we also believe that the development, production, and application of special machines can offer numerous opportunities and significant financial benefits, save working time and labour force, but also improve quality.

5 min read

A szoftver, ami előre szól, ha el fog romlani valami – bevásárolt a Siemens

Article

DATA-DRIVEN SOLUTIONS

The software that warns you in advance when something is about to go wrong - Siemens has bought it

Siemens has acquired Senseye, a developer of preventive maintenance solutions. The value of the deal was not disclosed, but it is known that the acquisition will strengthen the German technology company's position in a dynamic and growing market.

3 min read

Stratis_Gartner-BI-erettseg_1200x630px-100percent

White paper

DATA-DRIVEN SOLUTIONS

BI Maturity Assessment Model

Every company possesses a vision, preferably in a written form, and an idea of how to achieve it. This is its strategy. One of today's professional truism is that data is the new corporate asset. Accordingly, the corporate strategy should cover this as well. A data strategy - or as it is often called, a BI strategy - helps you understand how your use of data assets supports the achievement of your company's strategic objectives.

2 min read

Stratis prediktív analitika

Article

DATA-DRIVEN SOLUTIONS

Predictive analytics - Looking into the future through data

"Data is the new oil in the 21st century!" A quote by British mathematician Clive Humby coined in 2006 has become a veritable buzzword in recent years. However, we should add that, like oil, data only has real value if we can make good use of the amount of information we gather. One of these uses is forecasting, a methodology known collectively as predictive analytics. In this article, we review what is worth knowing about predictive analytics and why it is important for companies.

5 min read

stratis-kiskereskedelmi-ertekesites-teljesitmeny-menedzsment-adat-alapokon

Article

DATA-DRIVEN SOLUTIONS

Data-based retail sales performance management

Data-driven business operations, data-based decision-making. More and more companies adopt this approach, as using artificial intelligence and properly collected, processed and analysed information enables, for example, more efficient, profit-oriented operation for a commercial network. However, retail sales performance management also poses a number of challenges. In today's article, we set out to explore these and show how our data-based solutions can deliver tangible business performance improvements.

3 min read

Predektiv Analitika

Article

DATA-DRIVEN SOLUTIONS

Application areas of predictive analytics

In our previous article, we introduced the concept of predictive analytics and highlighted the benefits that forecasts can bring to companies. Now we give an overview of the sectors and areas where the use of predictive models has proven useful for data-driven operations and improving business performance.

5 min read

Kereslet előrejelzés, a Stratis megoldásaként

Article

DATA-DRIVEN SOLUTIONS

Demand forecasting with a Stratis solution

As the saying goes, “So many houses, so many customs”. This is no different for demand forecasting. However, it can be unanimously stated that a reliable demand planning solution is essential for successful business operation. Below, we justify this statement and, what is more, show how Stratis' solution can help you to plan ahead in practice.

4 min read

Beszerzési stratégiák adatokra építve

Article

DATA-DRIVEN SOLUTIONS

Data-driven Procurement strategies

As technology and data analytics capabilities continue to evolve, procurement departments in large companies are increasingly able to make more informed decisions than ever before. By analysing their data, companies can develop data-driven sourcing strategies that can revolutionise their procurement processes. In this article, we will walk you through what a data-driven procurement strategy is, illustrated with real-life examples and best practices. We will explore how companies can leverage their data assets to make more effective purchasing decisions and improve their bottom line.

9 min read

Shutterstock 1809827683

Article

DATA-DRIVEN SOLUTIONS

Driven by data: the new era of the energy sector

Discover how data-driven approach can revolutionise DSOs and other operators of energy systems of large size and cost, optimising operations and reducing costs. The proliferation and deployment of new generation renewable energy generation alongside traditional assets has triggered a major transformation process within the energy sector, where the technology is changing, as is the business case.

8 min read

Shutterstock 2503694117

Article

DATA-DRIVEN SOLUTIONS

Leveraging corporate data assets is key to achieve strategic goals

It's a cliché to say that the oil of the age is data, yet there is an ever-increasing amount of data being generated at every point in business, and by characterising it, we can find, if not oil, then gold. In our country, we can observe that the maturity of IT systems supporting managers varies from sector to sector, with infocommunication, financial and logistics companies generating an incredible amount of data, but often the synthesis of information that can be easily used by managers is not, or only partially, done. In the case of agricultural and manufacturing companies, we see a generally lower level of development, with the exception of a few innovative companies, the development of data-driven management has only started in recent years.

8 min read

Qergafr

Article

DATA-DRIVEN SOLUTIONS

Technical data warehouses

Technical data warehouses, especially in the energy sector, play a critical role in data collection and management. These data warehouses are systems that collect, store and analyse large amounts of data from different energy sources. Energy technical data warehouses have many technical features and complex architectures.

11 min read

Pexels Weekendplayer 132340

Article

DATA-DRIVEN SOLUTIONS

The Data Middle Ages: When Electricity Is Here, but Data Still Flickers by Candlelight

Some Hungarian companies are still living in the "Data Middle Ages." Although the word digitalisation appears in their business plans, data management practices often remain stuck in the early stages.

5 min read

View All