Data Manipulation with R and SQLMP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 46M | 384 MBGenre: eLearning | Language: EnglishR is the tool of choice for the business analyst faced with the daunting task of analyzing huge datasets.

Unlike traditional analysis tools like Excel, R offers the flexibility to structure large datasets in a manner suitable for robust analysis.

It also provides the speed and capacity necessary to run computations in a fast and efficient manner.

This video teaches you how to use R and SQL to manipulate densely populated datasets for business analytics.

You'll learn how to connect R to a SQL database, import data, commit queries from R, and how to replicate Excel functions like VLOOKUP and SUMIF to conduct advanced manipulation methods.

Participants should be familiar with SQL databases and have some prior experience manipulating databases using Excel type software.

Acquire the R skills that make it possible to effectively structure and analyze huge data setsLearn how to connect R to a SQL database, import data, and commit queries from RUnderstand how to use R to replicate Excel's traditional data structuring functionsPick up the best ways to categorize, plot, subset, and combine datasets in RDiscover techniques for manipulating data inside R using dplyr, data.table, and tidyr