Training --- Data quality in business
The increasing volume of data in organisations is in most cases not matched by its quality. Different data sources, different formats, different owners, inconsistent data management processes, all generate a growing problem with the quality of information and the quality of decisions based on it. As part of the training, participants will learn about the business processes involved in managing data, establishing responsibility for data and measuring the quality of information presented on reports.
The training is planned in the form of a workshop (theoretical lectures combined with practical exercises). Duration: 2 days of 8 lessons of 45 minutes each.
In the case of dedicated training, it is possible to extend or shorten the content.
During the training, participants will be introduced to the theoretical underpinnings of each section of the training and most of these sections will allow them to consolidate the acquired knowledge in the form of exercises.
Filling in the form is a preliminary declaration of participation, i.e. it does not oblige you to do anything until the final arrangements have been made.
The first part of the training will present the assumptions of information theory in describing business processes through data; the definition of data; its relevance to the realisation of current and future business needs.
The origin of data by source (manual entry, import (push vs pull), integration with other systems, internal transformations, business and technical inventory (metadata) and data usability assessment vs business requirements will also be discussed.
The first section will conclude with an overview of data storage systems: local and distributed databases, text files, spreadsheets, XML, Big Data, relational, multidimensional and document databases, EAV.
During this section, participants will learn the basics about data description procedures in relation to the information they are supposed to store:
This section will conclude with exercises in presenting data types and each of the data error types discussed.
This section will give participants a broader view of data quality as part of the data management process by working with entire data sets (compared to the previous section focused on single attributes). Its topic will cover:
With the knowledge of how to create a data quality analysis, participants will build a sample data quality report.
In this short section, the basics of building data management processes from the business side will be presented
Finally, participants will be introduced to examples of data classification sheets as tools to assist in information management.
Due to the fact that the possibility of correcting data in the source systems is sometimes limited, this operation must be performed during data processing. This part of the training will focus on methods to enhance data quality. These will include:
Participants will also have the opportunity to look at an example of a tool themselves, which allows for the provision of comprehensive data information, including data quality.
In this practical part, students will become familiar with the practical impact of a data steward’s work on the quality of data presented on management reports. In particular, exercises will be conducted using:
The final part of the training will cover questions and practical approaches to data quality in different types of organisations (including financial institutions).
We ensure practitioners, not theoreticians.
Hubert Kobierzewski Hubert works at Cogit as BI Practice Lead and helps clients to collect their data and convert it into valuable information. For years he has been involved in the subject of Business Intelligence solutions in the broadest sense – from integration, data quality, data warehousing to advanced analytical and reporting systems. He has carried out projects for a number of films in Poland, Ireland, UK or Switzerland. Outside of work, Hubert runs two community groups: the Warsaw branch of Data Community Poland and the Warsaw Power BI User Group. |
Training price: 1600 pln + VAT. (Price includes: participation in on-line classes, training materials).
CONTACT US: +48 22 496 60 00 info@cogit.pl Contact form