Before you can analyze and visualize data, you have to get that data into R. There are various ways to do this, depending on how your data is formatted and where it’s located. Usually, the function ...

Businesses often have to move data around the way construction companies move dirt. A tool like SSIS, designed to transfer and transform large amounts of data, helps take care of the heavy lifting.

The table below shows my favorite go-to R packages for data import, wrangling, visualization and analysis — plus a few miscellaneous tasks tossed in. The package names in the table are clickable if ...

See how to join two data sets by one or more common columns using base R’s merge function, dplyr join functions, and the speedy data.table package. R has a number of quick, elegant ways to join data ...

If you come across data you want to add to an Excel spreadsheet, but copying and pasting it doesn’t work (or seems like too much work), you can also take a screenshot of the table. Then, you can use a ...

Google Maps enables you to create your own maps including custom locations, for example a "Parks" map with marked locations for your favorite parks. The map can be exported to the Google KML format ...

What it does: Getting your data into analysis-ready format can be half the battle (or more) when using a spreadsheet. Microsoft Data Explorer Preview for Excel is designed to help by easing data ...