Data Analysis, Migration and Conversion with MS Access Excel

Learn how to extract the data from one application, modify and process it using business rules and load it to another
3.7 (8 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
144 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 17
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2014 English

Course Description

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 Microsoft Access 2010. You will learn how to use Microsoft 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.

Microsoft 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. Microsoft Access also allows analyst to normalize the data, reorganize the data, do queries to the data after importing and/or before exporting. Microsoft 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.

Source files for the course are available here:

http://www.howtoanalyzedata.net/basics-of-enterprise-data-conversion/

What are the requirements?

  • Basic knowledge of Windows based PC Systems
  • Basic knowledge of Microsoft Excel
  • Basic knowledge of Microsoft Access
  • Installed and configured Microsoft Access 2010 software
  • Installed and configured Microsoft Excel 2010 software

What am I going to get from this course?

  • Understand basics of the Enterprise Data Conversion process
  • Learn how to gather business requirements for the Enterprise Data Conversion
  • Describe key tools and utilities used in the data conversion process
  • Learn the key features of Microsoft Access for Enterprise Data Conversion
  • Import text data into Microsoft Access
  • Import xml, excel data into Microsoft Access
  • Import or link data from External Databases
  • Describe key steps involved in the data conversion
  • Apply filtering to the data and select the required values
  • Prepare the data for exporting for the target system

What is the target audience?

  • Data Analysts
  • Beginner computer users looking to convert the data
  • Beginner and intermediate computer users looking to analyze the data
  • Business owners looking to answer business questions with data
  • Consultants
  • Small business owners
  • Enterprenuers

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Summary and Overview
Course Overview
Preview
02:50
Who would benefit from taking this course. Why take it?
Preview
08:08
How to use material in this course and access the source files
Preview
01:45
Additional Helpful Information
Preview
01:32
Section 2: Microsoft Access Overview
What is Microsoft Access and 7 most useful features of the product for beginners
29:09
Section 3: Data Conversion process major steps
Data Conversion Process overview
04:52
Key features of Microsoft Access used for Data Analysis and Data Conversion
18:28
Data file formats basics
12:38
Exporting data from Microsoft Access
09:06
Creating scripts to process the data using VBA (Visual Basic for Applications)
12:36
Data Privacy and security concerns
03:39
Section 4: Completing Step by Step hands on data conversion
Gathering Business Requirements and loading source data into Microsoft Access
12:01
Building required output queries
16:11
Exporting the data in the required format
08:20
Section 5: Conclusion
Slides files used in the course
19 pages
Source Files used in the course
Article
Conclusion
02:09

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Vadim Mikhailenko, Enterpreneur, Consultant, Public Speaker, Educator

Hi, I am Vadim, and I am here to help you solve your problems. I am enterprenuer, family man and experienced educator. I have been and experienced consultant, for more than 20 years and I am also a professional educator and share my knowledge with college students. I hold MBA and Master in Computer Science degrees and excel in using technology to solve business problems

I have created this site to share with you how to reach your family goals by saving money and making make smart decisions to take you life to the next level. I’m always trying different things in my life and capture what works (and what doesn’t). I am excited to teach you my thought process, how I analyzed the data and tried different things to find the most effective approach. This site is organized as a set of training courses, which will teach you different tool, tricks and techniques of smart family decision making.

Ready to start learning?
Take This Course