Data sets are not static. They are constantly being updated, which can affect the quality of data. Data quality monitoring helps to resolve data issues quickly and also provides quality data. There are various ways we can resolve data issues in Tableau without changing the original data sources. Renaming We can rename fields in the Data pane […]
Posts Tagged ‘data quality’
Informatica Data Quality – Another Peek!
In my last blog, I presented a brief overview on Informatica Data Quality (IDQ) tools, the significance of Data Profiling and how to use the Analyst tool to profile data. In this second blog, I will introduce a few commonly used Informatica Developer tool Data Transformations. But, Why Data Transformations? Long story short, Data Quality […]
Data Profiling through IBM Quality Stage
Many of the assumptions we have about source data are probably not accurate. Today most organizations are facing a data quality problem. In this blog we will look how we can achieve Data Quality using IBM tools. We have a two step process to achieve Data Quality: 1) Data Profiling 2) Data Quality We can […]
Informatica Data Quality – A Peek Inside – Part 1
Data analytics, Master data management has been a top trending Business Intelligence implementation in last couple of years. One of the key success criteria for these programs is to maintain good quality data. Businesses also demand more value from the data that is maintained in the enterprise data repository. So there is a strong emphasis to […]
Three Words for Data Quality Initiatives
Today every business is taking more and more data from various and untrusted sources system and using it in more ways than ever before. Whether it may be a small organization or an enterprise environment, data quality management is both challenging and significantly important to every business. Despite the importance, Data Quality initiatives sometimes remain […]
Reasons for chronic Data Quality issues…
Many companies have invested millions in building a successful BI / EDW and are investing in advanced analytics for the future. But the mystery remains about the data quality. Though glaring DQ issues might be contained through constant backend data corrections or through exception handling, many organizations still faces the challenge of poor data quality. The reason Data […]
Data Quality – Don’t Fix It If It Ain’t Broke
What is broke? If I drive a pickup truck around that has a small, unobtrusive crack in the windshield and a few dings in the paint, it will still pull a boat and haul a bunch of lumber from Home Depot. Is the pickup broke if it still meets my needs? So, when is data […]
Think Better Business Intelligence
by jDevaun.Photography Everyone is guilty of falling into a rut and building reports the same way over and over again. This year, don’t just churn out the same old reports, resolve to deliver better business intelligence. Think about what business intelligence means. Resolve, at least in your world, to make business intelligence about helping organizations […]
Key strategies for Data Quality
In numerous client engagements, we have witnessed that Data Quality (DQ) is a never-ending battle. At many companies, IT fixes and re-fixes the data rather than develop solutions and manage applications. DQ is not confined to IT, but maintaining that quality requires effort from all data users, especially those at the business end. Building a […]
Bootstrapping Data Governance – Part I
A lot has been said and written about Data Governance (DG) and the importance of having one. However it is still a mystery for many companies to create an effective DG. Based on our experience majority of the companies in their early stages of DG fall into one of these areas: Had too many false […]
Is IT ready for Innovation in Information Management ?
Information Technology (IT) has come a long way from being a delivery organization to an organization part of business innovation strategy, though a lot has to change in the coming years. Depending on the industry and the company culture, IT organization will mostly fall in the operational spectrum and a lot of progressive ones are […]
Primary Practices for Examining Data
SPSS Data Audit Node Once data is imported into SPSS Modeler, the next step is to explore the data and to become “thoroughly acquainted” with its characteristics. Most (if not all) data will contain problems or errors such as missing information and/or invalid values. Before any real work can be done using […]