This topic discusses the best way to import financial data for analysis in MBI.
A two-dimensional, cross-tab data table is often the format used for financial data. With values categorized by labels in both columns and rows, this type of layout might be easy to view with human eyes and spreadsheet tools, but it is not very friendly to databases.
To import and analyze this data in MBI, the table must be flattened into a one-dimensional list. When flattened, each data value is categorized by multiple labels that are all in a single row, where each row is unique or would have a unique identifier, for example a primary key column.
To flatten a two-dimensional table using an Excel pivot table:
Alt-D. In Mac OSX, enter
0is selected for the number of desired page fields and click Next.
That is it! The data table has been converted to a list format, preserving all of its original information, and can now be imported to MBI for analysis.