In the life of a modern company, the collection, storage and use of data can play a key role in creating a lasting competitive advantage. For this, solutions covering the entire data lifecycle are essential, the two main pillars of which are data warehouse and analytics solutions.
In our experience, users of systems that process and use large amounts of data need to automatically analyze, report, and report the data stored in the system. To serve the BI layer, we build targeted data markets that directly serve data warehouses, reports, and analytics. In order to properly handle unstructured data generated in large quantities, we use Big Data tools, and we load the results of the processing into data warehouses and data markets. In addition, we provide the possibility of live processing and analysis of large amounts of data (stream analysis). In this case, the data is transferred directly from the source to the analysis tool (e.g. Power BI).
Our data warehouse solutions
Data warehouses need to provide a stable and secure source of data for business decisions for a longer period of time. Therefore, we use a classical data warehouse model in accordance with professional standards to implement the data warehouse and within it to integrate the data.
From the initial consultations to the full audit of the already completed data warehouses, we cover the entire life cycle with our specialists. Following the same principles, we design and implement data warehouses from the smallest data warehouses (with a self-developed toolkit) to the largest data warehouses (with large enterprise assets).
Our technology repertoire is extensive, we use both Oracle and Microsoft SQL Server databases, Big Data solutions , cloud-based environments (eg MS Azure or Google ) as well as native cloud-based service-based implementations that make the most of the cloud environment. . We also offer hybrid solutions that retain the ability to store and analyze any structured or unstructured data, while building a well-scalable relational data warehouse and easy-to-query analytical data markets.
Building on the consultations, we provide our customers with Power BI dashboards and complete solutions that meet their specific needs. With these solutions, our customers can enjoy all the benefits of Power BI.
With the Power BI analysis tool, you can gain insight into the data stored in your systems in an instant through informative graphs and diagrams. With constantly updated professionally designed dashboards, you can track the results of your results independently, even live, helping you make the best decisions anywhere, anytime.
Efficiency and quality are the two areas where the Power BI application is making the most progress. With automatically updated and shareable reports, you can access the information you need more efficiently and save time. While the outstanding quality and detail of the reports should not be compromised.
In addition, Power BI is not only an excellent tool for analyzing past data, but also allows you to make additional forecasts for your reports thanks to advanced algorithms.
Traditional and cloud-data storage
Flexibility - Stability - Cost - effectiveness
Flexibility - Stability - Cost - effectiveness
Due to flexibility, cost-effectiveness, and more industry-wide demands, in addition to data warehouses based on infrastructure and platform services, native cloud-based, service-based architecture is becoming increasingly popular among our customers for building new data warehouses and migrating old ones. High stability, wide connectivity and flexible application costs make it an ideal architecture. However, its use is less optimal below a certain amount of data. In such cases it might be substituted, e.g. with Azure SQL Database, which offers similar flexibility, but is a more cost-effective solution for smaller amounts of data.
After its implementation, both solutions are also suitable for further expansion and integration of new source systems and data sets. Data extraction (reports, analysis) can be done with market-leading tools, but it also provides data mining, less structured data processing, and easy-to-incorporate machine learning models or automated interventions.
MiniDW - We are big even when mini
With our data warehouse services, we provide a solution not only for medium and large companies!
With our data warehouse services, we provide a solution not only for medium and large companies, but also for those who are considering implementing their first data warehouse. We have developed our MiniDW data warehouse solution for them, which is an ideal start-up data warehouse for those who would prefer a solution that can be put into operation, easily expanded, modified and managed in a week, instead of a multi-year data warehouse development.
The structure of our data warehouses
However, it is true for all solutions that we follow a uniformized, well-thought-out structure during the construction of data warehouses!
However, it is true for all solutions that we follow a unified, well-thought-out structure during the construction of data warehouses, which facilitates design, development, subsequent expansion and guarantees constant quality.
In most cases, we use the classical data warehouse model to implement the data warehouse, including integrating the data and building the data markets. When using the classic, layered model, data cleaning and integration can be performed in well-controlled and manageable steps. Based on the data of the data warehouse layer, the most suitable data markets and data market tables are built. In addition to the strict relational model of the data warehouse layer, the data market layer is optimized specifically for query performance, respectively. objects created in a form that facilitates the query can be created. Modifying them, uploading the data after the modification can be easily solved from the historical data warehouse. This type of layering ensures easy and reliable connectivity of BI and analytics tools.
METADATA MANAGED DATABASE - ALLIANZ HUNGÁRIA ZRT.
Introduction of a metadata-controlled data warehouse, establishment of data markets related to the processes of different fields. Ad-hoc query and analysis BI systems have been adapted to the data markets. To properly handle unstructured, large amounts of data, we built a Big Data cluster and integrated it with the central data warehouse using an ETL control tool.
REGISTER OF PUBLIC CREDIT REGISTRY - MINISTRY OF THE INTERIOR
The aim of the KCR project was to implement a unified legal environment, administrative processes and a complete, publicly registered address register for address management in Hungary. Our task was to implement the integration between the Personal Data and Address Registration System and the Public Address Register System, during which we used data warehouse technologies and methods to implement the transformation between data structures, with the logical separation of functions (STAGE, PREPOCESS, DW layers).
DATA PROCESSING AND ANALYSIS - BANK360 ZRT.
Live and scheduled Big Data data processing and analysis based on lambda architecture based on Microsoft Azure cloud technology. All components are cloud-based, eliminating the need to build local hardware resources and creating a flexibly scalable, highly-reliable, and disaster-tolerant solution in the cloud. Data analysis and visualization takes place in PowerBI, where live events and recent events can be tracked and analyzed. Azure Stream Analytics handles and branches out large amounts of data to live view (PowerBI) and archive storage (Azure Blob Storage). All business events are archived in the cloud at low cost, allowing data to be freely analyzed later. The large amount of archive data is processed by Azure Data Factory and then the processed data is transferred to Azure SQL Database for easy analysis. Analysis and visualization is performed by PowerBI.