Pedro Innecco

Tag: Data Management

Data Management refers to the organisation and maintenance of data and its processes as a valuable resource. Topics in data management include: Data governance; data architecture, analysis and design; database management; data security management; data quality management; reference and master data management; data warehousing and business intelligence management; document, record and content management; metadata management; and contact data management. [Wikipedia]

  • Considerations when formatting phone numbers

    Considerations when formatting phone numbers

    If you ever read my post about considerations when customising address fields, I reckon you would know by now that I am all about consistency and standards. No, I am not aspy (my mother had me tested). But I could argue that computers are, which is why I am all for data quality and integrity.

    I reckon everyone reading this would agree that normally, the formatting of phone numbers is a minor issue. However when one is involved in a project as a solutions architect and a requirement arises asking for phone numbers to be ‘perfectly’ formatted on systems, I am sure they’ll beg to differ. In this post I’ll be going over misconceptions and considerations around phone numbers an the consequences it might have on computer systems.

    (more…)

  • Dynamics CRM: The importance of the Address entity

    Earlier this year I wrote an article about considerations when customising address fields. I was happy with the reception the article got, as it sparked some interesting discussions not only with some of my clients, but also with fellow Dynamics CRM consultants.

    Today I would like to expand further on that discussion and talk about an often neglected entity in Dynamics CRM: The Address entity and its importance in every single Dynamics CRM deployment out there (yes, including yours).

    (more…)

  • Dynamics CRM: Considerations when customising address fields

    The perceived issue on customising address fields and how to store addresses in computer systems always fascinated me. Not because of any apparent complexity one might believe that exists when handling addresses, but mostly because of people’s undeserved anxiety around the subject. And in Dynamics CRM it is no different.

    The issue tends to surround the myth that countries and regions with different subdivisions would require complex requirements for address handling. I came across a couple of clients who believe that they require such a complex solution that their Dynamics CRM deployments almost came onto a halt because of such hurdle. I the end, the solution relies not on complex customisation, but on standards compliance, a little bit of compromising, but most importantly: common sense.

    Please note that while this post relates to address fields in Dynamics CRM perspective, the data management considerations presented here should be taken into account regardless of the applications.

    (more…)