Besides the basis skills and understandings for data analysis, I gain the carefulness and strictness when analyzing data. Data have real applications fro directory function for real life. However, it should […]

Your Uncle Bob’s store sells food, magazines, cleaning supplies, and toys. Bob knows nothing about technology, but he knows you do! He’s asked you for help, but you want to keep it simple for him. Choose the […]

Cluster is used to analyze customer segmentation. An example would be airline tickets. We could study the purchase time, purchase method, destination and the reasons for purchases by using cluster analysis. […]

SpotCrime is an OLAP. It provides a historical view of data, which is crime have happened at these areas. OLAP, Online Analytical Processing, are being used aggressively by organizations to discover valuable […]

On Friday we did an in-class activity highlighting potential data quality issues resulting from poorly worded questions. Describe a situation where poor data quality can result in poor information and bad […]

Let’s say you were asked to help design a data mart for Target that captures sales data. For the fact, you can choose a granularity of hourly, daily, weekly, or monthly. What questions (and who) would you ask in order to gather the information required to make this decision? Sales Department — Statistics of the [...]

The the question #2: ERD is a data model which explicitly determines the structure of data or structured data. However, the schema consists of a few tables referencing any number of fields. ERD is an overall demonstration of the detailed and historical data in schema. When conducting analyzing, people could exact data according to cordiality [...]

First of all, you need to take costumers’ privacy into serious consideration before making this decision. Though they are the same business at different locations, costumers usually choose one business over another due to certain reasons, besides locations. Business ethics is really important. If we do not need to consider the privacy issue, we…[Read more]

i paid my due here, however, i did not receive any type of confirmation. would you please check this for me? thanks.

2. Based on our discussion in class, would your TUID number make a good primary key for a student database? How about your AccessNet ID? The primary key of a relational table uniquely identifies each record in the table. I think that TUID number is a good primary key, because one student is assigned with [...]

I think that Excel could store data with the dimensional diagrams. Because in Excel, though one data is represented by the attribution from one row and one line, however,one can create several sheets in a file. These sheets can be combine together during analyzing. Also, Excel has the pivot table function, which transfers or discover [...]

As far as I concerned, data is more important than information. First of all, what we see from the past can be the prediction for the future. Data represent the past, and information are the signs and instructions for future. Information is processed data, which aims to help people make decisions, creates values and form [...]