Bi-kipedia Data Masking Description du data masking Description du data masking Description du data masking Description du data masking Description du data masking Description du data masking Mardi, 27 septembre 2016
Recommended books Building the Data Warehouse Bill Inmon is one of the true pioneers of data warehousing and his "Building the Data Warehouse” is an absolute must read for every self-respecting data warehouse professional. Jeudi, 30 avril 2015
Bi-kipedia Denormalize This is the process of converting normalized tables again into a de-normalized form. Here, a table may contain redundant information. This is a common technique within data warehousing where star schemas are used to optimize performance. Denormalizing a database consumes more space and slows OLTP performance but improves query performance in a BI environment. Dimanche, 22 mars 2015
Bi-kipedia Change data capture (CDC) Change data capture (CDC) is the process of capturing changes made at the data source and applying them throughout the enterprise. CDC minimizes the resources required for ETL (extract, transform, load) processes because it only deals with data changes. The goal of CDC is to ensure data synchronicity. Dimanche, 22 mars 2015
Bi-kipedia Data Quality Data quality pertains to aspects such as availability, completeness, accuracy, consistency, relevance and timeliness of data. High data quality is essential to business intelligence’s role as a means of decisional support.Poor data quality examples: missing fields, old or inaccurate information, data conflicts, inaccessible data in legacy systems. Dimanche, 22 mars 2015
Insights Automate your ETL testing and deliver quicker and better results Testing ETL projects - used for Extracting data, Transforming it according to reporting requirements and Loading it into the data warehouse - is very complex because of many reasons. Typically huge amounts of data are handled and data comes often from multiple sources that need to be combined. Sometimes, the data is loaded incrementally, sometimes it needs to be reloaded in full. These ETL-flows can also apply all kinds of complex calculations and transformations on the data. Mercredi, 25 février 2015
Insights Master Data Management (MDM) : Architecture & Technology IntroductionGo to Google and type in the words "Why do BI projects fail ?". Vendredi, 17 octobre 2014
Recommended books Performance Management: Van Prestatiemeting naar prestatiemanagement door de toepassing van analytische intelligentie Dit recent gepubliceerd boek biedt een bijzonder volledig overzicht Mercredi, 20 août 2014
Bi-kipedia Microsoft SQL Server Data Quality Services - DQS SQL Server Data Quality Services (DQS), new since SQL Server 2012, is a knowledge-driven data quality product. Jeudi, 7 août 2014
Bi-kipedia Microsoft SQL Server Data Tools Microsoft SQL Server Data Tools is introduced with SQL Server 2012 and is the successor of the Business Intelligence Development Studio (BIDS). It is a, Visual Studio based, integrated development environment, used for all your BI-related development. Jeudi, 7 août 2014