Database Reference
In-Depth Information
dATA CleAnsIng
The process of data cleansing can often be messier than this: when pull-
ing from sources such as those used for the topic, data will often need to
be pivoted (the rows and columns swapped) and headings repeated, and
this will often be a manual process when working in tools such as Excel.
Integration tools such as SQL Server Integration Services are commonly
used when this needs to be automated.
MoVING your DATA INTo A GooD ForMAT For VISuALIzATIoN
Now that you have your data in a good clean layout, you can format it as a
pivot table, which is a basic type of visualization but is very powerful within
Excel. After you've formatted your data as a pivot table (as shown in Figure 4-7),
you can begin to do some nice drag-and-drop analysis on the data, as shown
in Figure 4-8.
FIguRe 4-7
Create a pivot table
