Enterprise Data Management Free-Samples for Students-Myassignment

Question: Design a high level Enterprise Data Architecture for a nominated enterprise. Include recommendations of which EDM technologies and methodologies should be used and why. Answer: Introduction Information and data that the organizations handle and deal with on a per day basis is massive in terms of volume. With the increase in volume and variety of data, it has become extremely difficult to manage this data efficiently without any errors and mistakes. It is therefore necessary to have a discipline that may suggest the measures to successfully manage and handle the data that is associated with the organization. Enterprise Data Management which is usually abbreviated as EDM is a discipline that that includes a number of different concepts and methodologies such as enterprise integration along with content management, business intelligence and many more for the streamlining, handling and storage of information (Lam and Taylor, 2017). Organization Background Bunnings hardware is an organization that is based out of Australia and also operates in New Zealand. It is an online retailer of several products in the categories such as home improvement, outdoor living and many more. The organization also acts as a supplier for project builders along with people in commercial trades and housing industry. With the expansion of business and services, the organization has also entered in the markets of Ireland and United Kingdom. There are wide varieties of products that are offered by the organization and the pricing of these products is also adequately done. There are retail customers as well as commercial customers associated with Bunnings and the overall operating network for the organization is therefore classified in various categories such as Bunnings, Warehouse and Trade Centre which are spread over 339 locations globally (Bunnings, 2017). Business Need Bunnings has operational network in three different areas as described above. Also, it is spread over 339 locations and has a collection of over 45,000 products. The information that is associated with all of these activities is huge and it is therefore necessary to develop and implement a system that has the potential to streamline all of the information in an efficient manner. Also, there are many errors and delays that take place due to different sources of information and vastness of the business operations that also leads to some of the operational and technical issues. The organization therefore requires a mix of methodologies with latest technologies implemented to manage and store the data associated with the enterprise. Business Operations There are wide varieties of products that are offered by the organization and the pricing of these products is also adequately done. There are retail customers as well as commercial customers associated with Bunnings and the overall operating network for the organization is therefore classified in various categories such as Bunnings, Warehouse and Trade Centre which are spread over 339 locations globally. The business operations are primarily associated with online retailing, housing services, workshops and other operational and managerial activities. Information Sources There are several sources of information that are associated with Bunnings and these sources comprise of sensitive, private, confidential, critical and public information. Sensitive and confidential information is associated with the data sources as the organization owner, partners and the stakeholders such as associated agencies and suppliers. The information around the customers and the employees along with their personal details is stored in the company database which is the internal source of information. There is certain critical information that is present with the external sources such as suppliers and vendors engaged with the organization. EDM Technologies and Methodologies Multi-enterprise Master Data Management for EDM Master Data alludes to the center elements of a specific endeavor, for example, client, providers, accounts and some more. Master Data Management (MDM) is an umbrella that coordinates business and IT to keep up the precision, consistency and coherence of master data that is related with a specific association (Gartner, 2012). One specific point of master data includes three noteworthy capacities viz. a validated connection of data, capacity to make utilization of the data in a reliable way and the capacity to be at standard with the changing business necessities as far as the master data management is concerned. A coordinated accumulation of administrations can then be produced around the specific data piece regarding the business forms and diagnostic applications. Effective business execution is additionally empowered with the three abilities that have been depicted. The definitive and verified source of data guarantees that the data is free from excess and repetitions of any sorts and is institutionalized in its structure (Dreibelbis, 2017) Denodo has been used as an additional technology. However, it can be removed also How it works Identification of the data sources is the first step that is executed in case of Master Data Management. There are several sources of data that are present in Bunnings Hardware that may be internal or external in nature. The entities that are associated with these data sources are also analyzed in this step. There are also a number of attributes that are related to the data that are required to be studied and these attributes are studied with the aid of metadata that is related to the master data. Operators and experts of the data are also appointed to make sure that complete analysis of the data is done. There are a number of governance programs that are related with the data that is associated with the enterprise in terms of the legal and administrative data and components. Master data model is required to be set up at the enterprise level which is based upon the consent that is provided by all the parties involved and also includes the analytics results. There are a number of tools that play an important role in association with the master data management and these tools are as listed below. Customer Data Integration (CDI) Product Information Management (PIM) Testing is an essential activity that is required to be carried out and the same is done with recording of the defects. Infrastructure is then set up once testing activities are completed. Rest of the activities is maintained and managed with the aid of maintenance activities involved (Wolter and Haselden, 2017). Multi-Enterprise MDM - EDM Essentials Data Migration It becomes essential for the master data to be migrated and collected at a common location instead of keeping the data distributed in several different locations. Cleansing of the data is performed thereafter so that the duplications and all the repetitions are removed. Data Integration Integration of the data is also very essential for master data and the data is integrated so that a single unit of the data associated with the organization can be created. Data Maintenance Data definitions that are set up are matched with the objectives and goals of the organization to make sure that there are no loopholes involved in the consistency of the data. Data Quality Assurance Quality is an essential property that is extremely necessary to be delivered and the same is done with the aid of data quality assurance Data Retention There are certain data pieces and data sets that become obsolete or lose their value over the period of time. Such data sets are removed and the ones that are essential are kept through MDM Key Benefits Redundancy Elimination There is a huge volume of data that is associated with Bunnings hardware as stated in the organization background and business operations sections above. It leads to the occurrence of redundancy at various levels which is removed with the process of master data management which comes up as one of the major benefits of the same. Master Data Edits Integrity of the data and information is often violated in case of enterprise data because of the location of the data and multiple data sources along with volumes of data associated with enterprise. The same would be avoided in case of Bunnings with the aid of MDM as it allows master data edits to be performed in one go. Useful and Effective Data Analysis There is a streamlined data made available with this particular technology of Enterprise Data Management which would allow the analytics processes to be carried out easily and in a more efficient manner. Key Data Goes In There is a mix of necessary and unnecessary data that is associated with the organization and MDM allows the identification and selection of only the necessary data sets. Authoritative Data One of the characteristic benefits of this technology is that the data sources that are present with this particular technology are authoritative in nature which enhances the data authenticity. Multiple Platforms There are various platforms that are associated with Bunnings with the varying classes of products and categories that are associated with it. The data in case of Bunnings can be accessed from numerous sources which make it easily accessible and available to the end users. Flexibility There are several operations on data that are present and are required to be performed at Bunnings. These operations can be easily performed with a great degree of flexibility provided to each one of them. Easy Backup Central data repositories are used for the storage of the data and there are several manual and automatic back up options that are provided to the users to make sure that the data is protected at all times. Increased Usability and Business Efficiency There are two of the very significant system qualities that are offered by MDM which are usability along with the business efficiency. Access Based On Roles Access management along with the identity management in case of master data management is done on the basis of roles which make it easy to implement the access control and privileges (Flatworldsolutions, 2017). Logical Data Warehouse Another Enterprise Data Management (EDM) methodology that would find application in case of Bunnings is logical data warehouse. It is an EDM methodology in which an extra layer is present over the regular warehouse of the data that is present in the organization. The data present in Bunnings and all of its related business activities will be presented to the stakeholders and the owners from the logical perspective and from any location as well. The conventional data centres are therefore being replaced by the logical data warehouses to make sure that the data can be viewed easily (Russom, 2017). Components of Logical Data Warehouse Repository Management This is the element which makes sure that the data is kept in to several repositories and each of the repositories is managed correctly. Data Virtualization Virtual integration of the data is also very essential for data and the data is integrated so that a single unit of the data associated with the organization can be created. Distributed Processes Business processes associated with the organizations such as that of Bunnings are distributed in nature and are brought together with the aid of technology such as logical DW. Auditing Services Governance and evaluation activities in association with data and data operations is carried out with this one Metadata Management are also a number of attributes that are related to the data that are required to be studied and these attributes are studied with the aid of metadata that is related to the overall data (Compositesw, 2017). Logical Data Warehouse Demands for EDM Enterprise Agility There is a great degree of flexibility and agility that is offered with the inclusion and implementation of logical DW. Real Time On demand analytics is supported by logical data warehouse that provides real time context to the organizations. Single View Logical data warehouse fulfills the organization need to view the entire data sets as a single unit instead of the data being distributed across several channels. Customer Satisfaction The major of goal of any organization such as Bunnings is to make sure that the level of customer satisfaction that is attained is very high and also that the customer expectations are met at all times (Hensley, 2017). Benefits of Logical Data Warehouse There is a streamlined data made available with this particular technology of Enterprise Data Management which would allow the analytics processes to be carried out easily and in a more efficient manner. One of the characteristic benefits of this technology is that the data sources that are present with this particular technology are authoritative in nature which enhances the data authenticity There are various platforms that are associated with Bunnings with the varying classes of products and categories that are associated with it. The data in case of Bunnings can be accessed from numerous sources which make it easily accessible and available to the end users. There are several operations on data that are present and are required to be performed at Bunnings. These operations can be easily performed with a great degree of flexibility provided to each one of them. Central data repositories are used for the storage of the data and there are several manual and automatic back up options that are provided to the users to make sure that the data is protected at all times (Marklogic, 2014). Conclusion Enterprise Data Management which is usually abbreviated as EDM is a discipline that that includes a number of different concepts and methodologies such as enterprise integration along with content management, business intelligence and many more for the streamlining, handling and storage of information. Bunnings hardware is an organization that is based out of Australia and also operates in New Zealand. It is an online retailer of several products in the categories such as home improvement, outdoor living and many more. The information that is associated with all of these activities is huge and it is therefore necessary to develop and implement a system that has the potential to streamline all of the information in an efficient manner. References Bunnings. (2017). Home. [online] Available at: https://www.bunnings.com.au/ [Accessed 2 May 2017]. Compositesw, (2017). Logical Data Warehouse | Cisco. [online] Compositesw.com. Available at: https://www.compositesw.com/solutions/logical-data-warehouse/ [Accessed 22 May 2017]. Dreibelbis, A. (2017). Enterprise Master Data Management. [online] Available at: https://cdn.ttgtmedia.com/searchDataManagement/downloads/MasterDataManagementSOA1.pdf [Accessed 2 May 2017]. Flatworldsolutions, (2017). The Benefits of Master Data Management - Flatworld Solutions. [online] Flatworldsolutions.com. Available at: https://www.flatworldsolutions.com/data-management/articles/master-data-management-benefits.php [Accessed 2 May 2017]. Gartner, (2012). Master Data Management (MDM) - Gartner IT Glossary. [online] Gartner IT Glossary. Available at: https://www.gartner.com/it-glossary/master-data-management-mdm/ [Accessed 2 May 2017]. Hensley, N. (2017). The logical data warehouse: The new secret weapon for leading. [online] IBM Big Data Analytics Hub. Available at: https://www.ibmbigdatahub.com/blog/logical-data-warehouse-new-secret-weapon-leading-businesses [Accessed 02 May 2017]. Lam, V. and Taylor, J. (2016). Enterprise Information Management (EDM): The Hidden Secret to Peak Business Performance. [online] Available at: https://www.umsl.edu/~sauterv/DSS4BI/links/EDM_Final.pdf [Accessed 2 May 2017]. Marklogic, (2014). Increase Agility and Reduce Costs with a Logical Data Warehouse. [online] Available at: https://www.marklogic.com/wp-content/uploads/2014/02/Increase-Agility-and-Reduce-Costs-with-a-Logical-Data-Warehouse.pdf [Accessed 2 May 2017]. Russom, P. (2017). The Logical Data Warehouse: What it is and why you need it. [online] Available at: https://tdwi.org/webcasts/2015/06/the-logical-data-warehouse-what-it-is-and-why-you-need-it.aspx [Accessed 2 May 2017]. Wolter, R. and Haselden, K. (2017). The What, Why, and How of Master Data Management. [online] Msdn.microsoft.com. Available at: https://msdn.microsoft.com/en-us/library/bb190163.aspx [Accessed 2 May 2017].