Walk-through Steps: I’m New to BI, Where to Start? – Part 3 : Data Governance

bag-and-hands_w

Data Governance is one of the most important aspects of BI systems, that unfortunately seen less important in many organizations. All usefulness and gratefulness of BI system will only be seen if there is a good data governance in place. If you build superb dashboards and data visualizations it won’t help until the quality of data is high. your ETL scenario won’t be so much great when there are more than one source for the same data but with different versions of it.

Data Governance and Enterprise Information Management (EIM) are concepts that needs to be covered in every organization working with the data, despite the fact that they use BI system or not. So in nutshell EIM and Data Governance are not components of BI system, they are separate systems, that can be used side by side of a BI system. However because of their very close relationship with BI system (especially because BI system is based on the data and information) we would cover them here. I would like to comment here that there won’t be a good BI system without good EIM or data governance in place.

[…]

Presentation files for Hong Kong TechDays 2013 : Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012

Thank you all for attending at my presentation in TechDays 2013 Hong Kong at evening of 3rd day of conference. here you can find presentation file of my speaking session about Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012 Title:  Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012 Description: Read more about Presentation files for Hong Kong TechDays 2013 : Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012[…]

DQS Error : Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo

If you faced this error when you want to connect Data Quality Services (from Data Quality Client or from SSIS DQS Cleansing component); Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo You can fix it in following way; Why this happens: When .NET Framework Read more about DQS Error : Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo[…]