Database Reference
In-Depth Information
sure you know that you can start with a smaller set of data and then begin
working with larger sets once you're comfortable with the types of analysis
that you're performing.
FIguRe 4-2
Proper data formatting
AuToM ATE D DATA
If you have calculated values in your data, you need to make sure those are
identified. Spreadsheets and other data analysis tools can create powerful
calculations, but they may have some limitations as you begin to use them
for sourcing. For example, in some cases, drill-through functionality is limited
based on the type of calculation and where it is in your data source. If it is
coming from an OLAP cube, there will be limited functionality if it is being
calculated in the OLAP layer and not in the spreadsheet. In addition, data that
is autogenerated may have lots of repeated information that you don't need,
and importing it would only make your analysis tasks more cumbersome.
TyPeS oF DATA SeTS AnD SouRCeS
There are many different types of data, from lists of people and products to
financial documents and more. This section reviews some of the important
sources you will see most often in projects like those in this topic.
