These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 16, 2013

Business Intelligence Data Getter

Executive Summary

The purpose of this system is to assist in a project for ISYS 555 Data Mining for Business Intelligence (BI). The objective of the BI project is to determine which indicators/variables have the greatest impact on a country’s GDP. The data will be gathered from the World Bank’s website found out To assist in the gathering and formatting of the data, I have written a program in VBA that will automate this process, saving many hours of tedious work for my group. The program will receive an input from the user of the variables the user wishes to gather data for from the World Bank. The program will download this data in an excel workbook format (.xls) and put the files in a location chosen by the user. The next part of the program will take all of the data from the downloaded files and put them into one “Master” excel file that will format all of the data in an easy-to-read format. This Master spreadsheet will then be sent on to other members of the BI project team for data scrubbing/cleansing, and analysis.

No comments:

Post a Comment

Blog Archive