Data Cleansing

Don’t be mislead by dirty, error-prone data

What is Data Cleansing?
Techopedia describes data cleansing as, “The process of altering data in a given storage resource to make sure that it is accurate and correct. There are many ways to pursue data cleansing in various software and data storage architectures; most of them center on the careful review of data sets and the protocols associated with any particular data storage technology. Data cleansing is sometimes compared to data purging, where old or useless data will be deleted from a data set. Although data cleansing can involve deleting old, incomplete or duplicated data, data cleansing is different from data purging in that data purging usually focuses on clearing space for new data, whereas data cleansing focuses on maximizing the accuracy of data in a system. A data cleansing method may use parsing or other methods to get rid of syntax errors, typographical errors or fragments of records. Careful analysis of a data set can show how merging multiple sets led to duplication, in which case data cleansing may be used to fix the problem.”
Why do I need to cleanse my data?
TechRepublic explains, “Poor data quality adversely affects your organization in three key ways:
  1. Poor data quality causes inefficiencies in those business processes which depend on data—reports, ordering products, voter registration, and just about everything else for which facts are required. These inefficiencies result in very expensive rework efforts to “fix” the data in order to meet the requirements of various processes.
  2. Poor data quality gives rise to poor decisions. A decision can be no better than the information upon which it’s based, and critical decisions based on poor-quality data can have very serious consequences. This is another reason why you should make sure that your data actually represents reality.
  3. Poor data quality creates mistrust. Poor data quality can reflect adversely on your organization, lowering customer confidence. If the data’s wrong, time, money, and reputations can be lost.
As the usefulness of data extends beyond ordinary business transactions to the support of business-intelligence initiatives, data-quality issues are going to become increasingly evident.”
Why choose Competitive Analytics to clean my data?
Competitive Analytics’ advanced techniques and unique methodologies transform the normally extremely labor intensive and time consuming task of cleaning data into an efficient, faster, and systematic process. For analysts, Competitive Analytics eliminates the “janitorial” tasks of cleaning dirty, error-prone, and misleading data and frees up your time to actually analyze the data and produce precise results for management and decision makers.
  • Thank you for another informative forecast session. We find it provides an excellent perspective. Many thanks for the invaluable insights. Given the outstanding feedback from clients and caliber of your lecture, I would like to extend you through the next 6 months. Please let me know if you can accommodate.

    Director, The Landing For Men of Newport Beach
  • One of the high points of my job is from time to time having the good fortune to experience phenomenal business structures and intellectually driven individuals. You definitely fit both of these in spades.

    General Manager, South Coast Plaza/C.J. Segerstrom
  • Thank you again for presenting at our council meeting. We were all very impressed by you and your company’s service.

    Executive Director, IREM Orange County
  • Simply stated, CA exceeded our expectations on all projects. With CA’s passion for accuracy, obsession with using the latest cutting-edge technology, and devotion to client service, I strongly recommend without hesitation the selection of CA as the top choice among market consultants in business today.

    VP Sales and Marketing, SunCal Companies
  • A few weeks ago I sent our friends at Competitive Analytics our monthly report to import into a new iPad tool they created. WOW! It is amazing how they turned an almost impossible collection of data into an intuitive one with built-in analyzers for your iPad!

    Director of Sales & Technology, NES Rentals
  • Competitive Analytics’ approach and methodology is well beyond any firm we experienced. They utilize advanced mathematics and proprietary software in order to assist us with specifically identifying revenue maximization and product optimization. Needless to say, they were worth their fee.

    Chief Financial Officer, Boeing Realty Corp.
  • We use a company called Competitive Analytics to provide projections, trends and metrics based on the information from our own actual results as well as other companies. We have found that this firm is significantly more accurate than any of the other “Economic Forecast” that are done in Southern California.

    Vice President, Business Development, Western National Group
  • When I need comprehensive economic analysis, precision market research, and strategic advice with measurable results, I call David Savlowitz at Competitive Analytics. Competitive Analytics has completed an array of demand studies, pricing studies, forecasting, and qualitative research for our company; and on each and every occasion CA provided phenomenal deliverables that added much insight and value to our business.

    Division President, KB Home
  • Since early 2000, Western National Property Management has engaged Competitive Analytics to assist in developing quantitative and qualitative forecasts specific to the Southern California apartment market, and to assist in forecasting strategic and tactical plans for our clients’ properties. The information garnered from this annual analysis is an integral component of our annual budgeting and business plan process. Due to the proven track record of Competitive Analytics with regard to our portfolio, we have come to rely on their insights and observations about the economic climate that directly impacts how we do business. Competitive Analytics is an intelligence firm that conducts comprehensive market research and precision analytics.  They employ a myriad of innovative methodologies and technology to produce objective, evidence-based market knowledge to assist companies to reach higher levels of performance and profitability.

    President, Western National Group