How would you organize this flat file for the collection of data?
Do you run your own business or have access to business data? If yes let’s brainstorm about data you would want to collect. Store daily sales in a table like below.
|
Observation |
Date |
Sales In Dollars |
|
1 |
6/30/2021 |
2512.30 |
|
2 |
7/1/2021 |
2945.12 |
Etc. This works if you are selling a single product, or if you want to aggregate all products into one. Aggregation is useful in analysis, but personally I believe it is better to gather data at its lowest form and then aggregate.
Suppose you are doing analysis for a simple bakery. By simple I mean a small menu of items, see the table below.
|
Product |
Acronym |
|
Large Loaf (Swiss bread 2 lb. loaf) |
LL |
|
Small Loaf (Swiss bread 1 lb. loaf) |
SL |
|
Banana Bread |
BB |
|
Banana Nut Bread |
BNB |
|
Oatmeal raisin Cookies (1 dozen) |
OR |
|
Chocolate Chip Cookies (1 dozen) |
CCC |
|
Cinnamon Roll (each) |
CR |
Relevant information, to start, would include. Product sold (prod), price of the product (p), quantity sold (q), date and time sold (t). Before you can do any analysis of this businesses data you need a method to collect, organize, and store data. The storage format should be the simplest possible format. For now, create a flat file that will contain the pertinent information in a user-friendly format. Things to remember. Data storage in a computer friendly format will get your data to an analysis tool quickly and easily.
How would you organize this flat file for the collection of data?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
