Download Now

Data Analysis, Migration and Conversion with MS Access Excel

Data Analysis, Migration and Conversion with MS Access Excel
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | 463 MB
Genre: eLearning | Language: English

Learn how to extract the data from one application, modify and process it using business rules and load it to another
This course will teach you how to extract the data from different applications, analyze and manage extracted data and migrate and load it into another solution. How is this useful? This is done almost as part of any software implementation project where one system replaces another one, but organization would like to keep historical data.

Main tool we use as part of this course is WeiRuan-->WeiRuan Access 2010. You will learn how to use WeiRuan-->WeiRuan Access to do data analysis and data conversions. Enterprise data conversion is the process of transforming of computer data from one format to another with the intention of loading transformed data into the target system. Data in organizations is stored in the different formats and might be hosted in the different applications. When applications get replaced or upgraded, data needs to be extracted, re-organized, reprocessed and reloaded from the source system into the target system. As part of the transformation different business rules would need to be applied to make data compatible with the target system.

WeiRuan-->WeiRuan Access allows you to work with the different file formats: text, Excel and XML formats and also allows import/export data from other databases. Using Access you can import the data to access or link and reference production databases and always get access to the live data. You can also connect to the databases and other sources, built by the different vendors and using different technologies. WeiRuan-->WeiRuan Access also allows analyst to normalize the data, reorganize the data, do queries to the data after importing and/or before exporting. WeiRuan-->WeiRuan Access can also be used as the database engine for data analytics and help uses answer business questions. Learn all of this and more as part of this course.

Data Analysis, Migration and Conversion with MS Access Excel

Direct Download

Tags: Analysis, Migration, Access

Add Comments:
Enter Code: *