A 10 minute thought on your Data Governance Strategy
“Data Governance is too expensive and highly complex which might not give us a good ROI, so we should probably wait a few more years.“ [/et_pb_text][et_pb_text _builder_version=”4.8.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”]
Hold that thought immediately because no! If you weigh returns in saved time and mitigated risks, it is not expensive! It is only complex if planned with a framework unsuitable for your business model. Lastly, no, definitely don’t wait! Do your company’s future a favour and start now because you might be willing to wait for your decision on DG but your Data will definitely not. It will keep on growing and become more complex whilst also becoming more valuable.
[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
But why should you bother?[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Digital Transformation is on everyone’s agenda and data is that core asset which will allow you to achieve your Digital Transformation goals. This makes it crucial to deploy a data governance framework that will also suit your business objectives. It is more of a strategic tool that ensures that your organizational data assets are managed in the right manner, and also create policies and roles in the organization to ensure those policies are implemented. In short it means higher data quality standard, better analytics, accurate business decisions!
[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Is it relevant for Small Businesses?[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
As mentioned before, data is growing for everyone. Even for smaller businesses data will continue to grow and be more complex but valuable, and that makes it more exposed to risks due to privacy, security and compliance. However smaller businesses are more agile in implementing new methodologies and would face less integration challenges that huge organizations would normally face.
[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Implementation seems too complex, so how do you achieve it?[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
The scope of a complete Data Governance project is indeed huge and cannot be implemented right away across all data so the best practise is to take small steps by identifying main KPIs and the critical data assets required. For example if you are the Owner of a manufacturing plant and wish to include Carbon Emission as your KPI. Of all the data available in the company the data related to this KPI (Data from Energy, Production shop, Chemical Incineration) becomes your Critical Data Assets.
Remind you that the context here is not operational i.e. to reduce your Carbon Emission, but to ensure that the data collected every day for this KPI is accurate, consistent, complete and as per the defined policies.
[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Okay. So what does the framework do?[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
An effective DG framework includes the following pillars as the scope. But the most important ones are Meta Data Management, Data Quality and Data Ownership. The others can be achieved separately under the scope of Data Management.
[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Metadata is the data of your data. It should include the details about the flow of every data as per Business definition (Business Lineage) and also actual flow in the enterprise level (Data Lineage). It also serves an important function of having Business Glossary and Data Dictionary.
Let us assume an Auditor wants to check the correctness of the PBT of your Finance report. First she would have to access the Business Glossary in Finance cluster and find PBT and what it stands for (here Profit Before Tax). She then can access the definition and also see the actual flow of that PBT value (how it was calculated, aggregated and transformed) throughout the organization. Transparent and all in one view![/et_pb_text][et_pb_image src=”https://hubsters.de/wp-content/uploads/2021/03/Bild1.png” title_text=”Bild1″ _builder_version=”4.8.1″ _module_preset=”default”][/et_pb_image][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Data Ownership includes roles and responsibilities assigned to the people in the organization, who will be accountable for the set principles for the data cluster assigned to them. Let us say a Finance data owner is given a Power BI report which has their New Business Volume as KPI and it needs his approval. He has to approve the Business lineage for all the data. To reduce it to one data point let us consider PBT again. The data owner will only approve a Power BI report if there is a traceability of this PBT to the very first level as per the Business Lineage.[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Similarly, Data Quality framework also sets KPIs based on the defined terms. If there the quality KPI alarm is set off, the Owner can quickly view the related metadata information and find the person responsible (Data Stewards) and contact them.[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Overwhelming right? But this method of accountability ensures the correctness and standards. It may seem like a time exhaustive tasks at first but if you consider the time wasted in finding an issue without a proper governance, you tend to comprehend the benefits it brings.
[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Is Tool selection or Budget your concern?[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
There are DG tools available but with high Operational costs. But the introduction of cloud solutions and integration with services can reduce the operational costs by significant levels. Also you do not do DG over everything but rather focus first only on those assets which are of critical value. A good DG solution must gather metadata from different sources, manage a Data Dictionary and Organization’s business glossaries, enforce procedures and policies. Microsoft’s ‘Azure Purview’ is one such tool that can provide seamless integration across many data sources. One can quickly find a data asset through the Purview catalogue and go through the definitions, glossary, the hierarchy of that particular data throughout the system and additional details of the person responsible for those data assets, all under one single view. In addition it also identifies sensitivity labels which help the Data Owners to have a quick glance at the location of their sensitive data (like Credit card information) and take actions accordingly. An effective Data Governance tool should ensure highest Data Quality through reduced effort and time taken, to scan across data assets or in creating lineage. Purview lets you can scan your Power BI workspaces and auto generate list of data assets and their data lineage. Your KPI data assets can be automatically listed and published in the Purview catalogue.
[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
Are you still hesitant to implement your Data Governance Strategy?[/et_pb_text][et_pb_text _builder_version=”4.8.1″ header_2_font_size=”22px”]
We can help you achieve them based upon on your Business Models & Objectives. Our employees are experts in Business Intelligence, Data Analytics, Data Warehousing, Machine Learning, Production Management, Finance and Controlling. If you need support in the implementation of your Data Strategy, please contact us at any time![/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”4.8.1″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.8.1″ _module_preset=”default”][et_pb_button button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjIwOTQifX0=@” url_new_window=”on” button_text=”Zur Newsletter-Subscription” button_alignment=”center” _builder_version=”4.8.1″ _dynamic_attributes=”button_url” button_text_color=”#303344″ button_bg_color=”#efd430″ button_border_color=”rgba(0,0,0,0)” button_border_radius=”30px” button_letter_spacing=”2px” button_font=”Poppins|600|||||||” button_use_icon=”off” custom_padding=”16px|32px|16px|32px|true|true” animation_style=”slide” animation_direction=”right” animation_intensity_slide=”5%” button_text_size__hover_enabled=”off” button_text_color__hover_enabled=”off” button_bg_color__hover_enabled=”off” button_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”off” button_letter_spacing__hover=”2px” button_letter_spacing__hover_enabled=”on” button_border_width__hover_enabled=”off”][/et_pb_button][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”4.4.8″][et_pb_column type=”4_4″ _builder_version=”4.4.8″][et_pb_divider color=”#74c2d2″ _builder_version=”4.4.8″][/et_pb_divider][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.4.8″][et_pb_row column_structure=”1_3,2_3″ _builder_version=”4.4.8″ max_width=”862px” max_width__hover_enabled=”on|desktop”][et_pb_column type=”1_3″ _builder_version=”4.4.8″ custom_padding=”0px||0px|27px|false|false”][et_pb_image src=”https://hubsters.de/wp-content/uploads/2021/01/BIld2.jpg” alt=”Linus Trips HUBSTER.S” title_text=”BIld2″ _builder_version=”4.8.1″ max_width_tablet=”30%” custom_margin=”|||0px|false|false” custom_margin_tablet=”” custom_margin_phone=”||-26px|0px|false|false” custom_margin_last_edited=”on|phone” custom_padding=”|||0px|false|false” module_alignment_tablet=”left”][/et_pb_image][/et_pb_column][et_pb_column type=”2_3″ _builder_version=”4.4.8″][et_pb_blurb title=”Tushar Poojary” _builder_version=”4.8.1″ custom_margin=”36px||||false|false” hover_enabled=”0″ sticky_enabled=”0″]
Tushar Poojary ist Solution Architect bei den HUBSTER.S[/et_pb_blurb][et_pb_blurb use_icon=”on” font_icon=”%%153%%” icon_color=”#303344″ icon_placement=”left” use_icon_font_size=”on” icon_font_size=”20px” _builder_version=”4.8.1″ header_text_align=”left” custom_margin=”||30px||false|false” animation=”off” link_option_url=”mailto:christoph.monzel@hubsters.de” body_text_align_tablet=”center” body_text_align_phone=”center” body_text_align_last_edited=”on|phone” text_orientation_tablet=”left” text_orientation_phone=”left” text_orientation_last_edited=”on|tablet” module_alignment_tablet=”center” module_alignment_phone=”” module_alignment_last_edited=”on|tablet”]
tushar.poojary@hubsters.de[/et_pb_blurb][/et_pb_column][/et_pb_row][/et_pb_section]