R Tidyverse Reporting and Analytics for Excel Users free ebook download.

Home : Book details

R Tidyverse Reporting and Analytics for Excel Users free ebook download

Category:
Video (tutorials, how-to, etc.)

Views: 45
Likes: 104

Catalogue

Author(s):	Jonathan Ng

Date:	2020	Format:	MP4	Language:	English	ISBN/ASIN:	0000000000
Pages:		OCR:		Quality:		ISBN13:
Uploader:	oblivion	Upload Date:	2/13/2021 7:42:41 PM

To download click on link in the Links Table below

Description: Click to see full description

R Tidyverse Reporting and Analytics for Excel Users
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 5h 15m | 2.84 GB
Instructor: Jonathan Ng

From Excel To Big Data and Interactive Dashboard Visualizations in 5 Hours
Requirements
You should be comfortable with vlookups, if statements and pivot tables in Excel
Description
If you use Excel for any type of reporting or analytics then this course is for you. There are a lot of great courses teaching R for statistical analysis and data science that can sometimes make R seem a bit too advanced for every day use. Also since there are many different ways of using R that can often add to the confusion. The reality is that R can be used to make your every day reporting analytics that you do in Excel much faster and easier without requiring any complex statistical techniques while at the same time giving you a solid foundation to expand into those areas if you so wish. This course uses the Tidyverse standards for using R which provides a single, comprehensive and easy to understand method for using R without complicating things via multiple methods. It's designed to build upon the the skills you are already familiar with in Excel to shortcut your learning journey.
When I first started using R I thought that it could be a good replacement for the automation type processes I used to write in VBA. This can be quite off putting for a lot of Excel users as VBA often adds an extra layer of complexity to your work and is often only something which is done to automate a process which has already been established in Excel. One of the key benefits of Excel is that you are working directly with the data without having to go through the complexity and overhead of using a programming language.
Programming languages such as VBA are actually very difficult for working with data as there isn't even any concise way of referencing common data elements such as named table columns. To carry out an operation on every row would take several lines of code which runs slow and ends up hiding your formula which actually contains your business logic.

Since I've started using R people have asked me when it would be beneficial to use R instead of Excel. Here are some examples
1. vlookups and sumifs on large datasets can run very slowly in Excel. I've helped people to replace multiple lines of vlookups that take 80 minutes to run in Excel with a single function in R that takes less than 1/10th of a second.

3. Dashboards and visualisations are much richer and easier to construct than in Excel
4. Distributing your work in Excel can be beneficial since almost everyone has Excel installed. The problems with this are that not everyone always has the same version of Excel or addins installed which means your work might not be compatible. Also files are usually emailed around which can very quickly lead to hundreds of untracked copies of your Excel files with slight variations in them. The outputs from R can be simple Excel or csv files however your output can also be a web app that can be centrally stored and tracked on a server compatible with any web browser on your computer or smart phone.
5. Team collaboration and version control in Excel is done via shared workbooks and track changes. Turning on these features in Excel disables some of Excels best features and still results in file locking. Team collaboration in R is done on github which allows you to easily work across teams without file locking issues and full audit histories of your work.
The beauty of R is that once you start using it you will no longer have to make a special investment of time to automate your processes after your analysis is done. Practically anything that you can do in Excel you'll be able to do faster and better for even your first round of analysis and will leave you with an script which means your work is reproducible and automated from the very beginning.

Who this course is for:
If you are currently using Excel to deliver a regular reporting requirement this course will be a good fit for you. This course is designed to introduce R to non programmer Excel users who are already familiar with Pivot Tables, vlookups ,if statements and charts.

Links Table

	Title	Link	Size (MB)	Thank to
2963920	Part 1	http://www.nitroflare.com/view/D27434B59...	1024.00	oblivion
2963921	Part 2	http://www.nitroflare.com/view/FCC27456C...	1024.00	oblivion
2963923	Part 3	http://www.nitroflare.com/view/B8E41E50B...	864.42	oblivion

Tags: Analytics Excel Reporting Tidyverse Users

Title	Link	Password	Size	Reason

Those who downloaded this book also downloaded the following books:
Comments

New comment: