MIS 3537
Hyun Ju Lee, Zach Hodowanec, Chris Parsia, Sarah Tuchinsky
Professor Wattal
23 April 2013

Wal-Mart Case Study

1. Indexed to Sales Sales COGS Op Expenses Net Income Inventories Total […]

Username: cparsia16
Email: tuc29378@temple.edu
Team Members: Chris Parsia and Zach Hodowanec

C. The tag’s power source.

RFID tags don’t know the difference between any readers, and they can be read from a distance. Anyone with malicious intent can easily learn valuable information about what you have on you, and even go deeper and […]

1. RFID tags allow you to be more concise about your inventory.
2. RFID tags are much faster and more efficient than barcodes and their scanners.
3. RFID tags present the opportunity to have a more independent […]

Christopher Parsia
MIS/Senior
Likely working for insurance company in Spring 2013

Classification helps you sort out information by categorizing groups or sets.
Clustering helps you connect entities together based upon their relationship to one another.
Association rule is used to determine […]

1. There are many uses for data mining to help us solve problems and issues. A very useful way to use data mining is to determine the demographics of customers, or past purchases, or something like that. By […]

1. Clustering and classification is when you sort data into different groups. Clustering is when you put the data into thought out groups, and can be ambiguous. Classification is when you put the items into categories.

1.

Data mining has a few issues associated with it. There is a privacy issue, because you can use data mining to analyze routine business transactions and learn a lot about someone’s spending habits and […]

2.
Data mining is extracting the useful parts of databases. It is finding information that was not previously used but could be useful in the present and future. Data mining is not anything like analyzing sales or profits.

The key objectives include extracting data from the operational data store, then transform and load it into the dimensional database.

The key issues are data consistency and quality. There are plenty of errors that could be made, such as not having everything done complete and in the right format, etc.

Kimball’s 4 step process includes… a- Choosing a business process, which is figure out what you need to answer by using the cube. b- Decide the level of granularity, basically just deciding how much detail you want for each event in the cube. c- Identify the dimensions to figure out what data to use to [...]

2. The SUM() function is very simple, because it just returns the added values of an expression.

1. What SQL command is used to retrieve unique values?

The DISTINCT command is the necessary tool to display unique values.

3. What is business intelligence?

Business intelligence is the use of technology to identify, extract, and analyze business data. Sales revenue, costs, and incomes are the most common information found. Using technology to do the process of forecasting is also a very common occurrence used by businesses as well.

1. The primary key is a very specific way (generally numerical) to tell different entries apart. A good example is using an order number, instead of the recipient’s first and last name. The foreign key helps sort out primary keys and is used to link tables together. It is basically a cross reference with primary [...]

1. Transactional data is information that is real-time, and is constantly updating. It is information that is changing and being added to everyday from constant changes in regards with sales, orders, payments…etc. Analytical data is information that is from previous periods of times. It is used to help figure out things that went right or [...]