R Tidyverse Reporting and Analytics for Excel Users
R Tidyverse Reporting and Analytics for Excel Users, available at $109.99, has an average rating of 4.35, with 45 lectures, 1 quizzes, based on 759 reviews, and has 6732 subscribers.
You will learn about How R implements common Excel functions and how it can actually be faster, easier and more flexible than the familiar Excel methods. By the end of this course you will have the knowledge to work with large sets of data faster and easier than you ever thought possible. This course uses the tidyverse libraries in R which provide an elegant solution for solving 99% of our reporting requirements. Tidyverse is incredibly well supported and by focusing solely on this one set of libraries we can massively shortcut the amount of time that is required to get up and running with R. Many beginner courses in R will start teaching what is known as base R which covers the original methods for working with R that have been enhanced and simplified through the tidyverse. Although it maybe useful to have some understanding of base R it is neither a requirement of this course or a requirement to becoming really productive in the R language. As we go through the exercises we are going to be comparing to the most common way that processes are typically carried out in Excel. This course is ideal for individuals who are 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. It is particularly useful 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.
Enroll now: R Tidyverse Reporting and Analytics for Excel Users
Summary
Title: R Tidyverse Reporting and Analytics for Excel Users
Price: $109.99
Average Rating: 4.35
Number of Lectures: 45
Number of Quizzes: 1
Number of Published Lectures: 42
Number of Curriculum Items: 46
Number of Published Curriculum Objects: 42
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- How R implements common Excel functions and how it can actually be faster, easier and more flexible than the familiar Excel methods. By the end of this course you will have the knowledge to work with large sets of data faster and easier than you ever thought possible. This course uses the tidyverse libraries in R which provide an elegant solution for solving 99% of our reporting requirements. Tidyverse is incredibly well supported and by focusing solely on this one set of libraries we can massively shortcut the amount of time that is required to get up and running with R. Many beginner courses in R will start teaching what is known as base R which covers the original methods for working with R that have been enhanced and simplified through the tidyverse. Although it maybe useful to have some understanding of base R it is neither a requirement of this course or a requirement to becoming really productive in the R language. As we go through the exercises we are going to be comparing to the most common way that processes are typically carried out in Excel.
Who Should Attend
- 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.
Target Audiences
- 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.
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.
Despite all of this people use VBA anyway as once you invest the time to setup your processes you can run the exact same steps thousands of times with a click of a button.
What if there were a way to work directly with your data as simply as Excel but also have more programming power than VBA? That’s what R can do for you.
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.
2. Exploring and analysing your data in R can be Viewed in a simple table like Excel but also has a wide range of other methods which can be more effective.
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.
Even though your existing Excel skills will help you to pick up R one of the hardest things is that you’re so familiar with Excel that it’s too easy to keep on using it. I used Excel for years and spent thousands of hours studying how to use it more efficiently, I even taught advanced courses in it. It seemed obvious to me at the time that it was one of the most efficient ways to work with data. Even though working with a programming language might be more powerful it often had too much over head and was too removed from the actual data analysis. R is the programming language I wish I learnt 20 years ago. Perhaps somewhat counter intuitively you’ll end up spending less time thinking about how to put a piece of work together than Excel and more time looking at your data in new ways that you’ve probably never even thought of.
Course Curriculum
Chapter 1: R Tidyverse Reporting and Analytics for Excel Users
Lecture 1: Intro
Lecture 2: About Your Instructor & How This Course Came to Be
Lecture 3: Why Use R?
Lecture 4: How to Get the Most out of this Course
Lecture 5: Accelerated Learning Techniques for Using The Example Files
Lecture 6: Setting up R
Lecture 7: Setting up R Extra Points
Lecture 8: Foundations
Lecture 9: Loading Data
Lecture 10: R Projects and Working Directories
Lecture 11: Loading Data Extra Points
Lecture 12: Calculated Columns
Lecture 13: Filtering
Lecture 14: Pivoting with R for data science vs Pivoting with Excel
Lecture 15: Vlookups to Joins
Lecture 16: Getting Data Into Excel with Power Query
Lecture 17: Data Visualisation Libraries to Install for this section
Chapter 2: Data Visualisation
Lecture 1: Data Visualisation Options
Lecture 2: GGPlot Intro and Setting Aesthetic Properties
Lecture 3: GGPlot Geoms (aka Chart types)
Lecture 4: GGPlot Layering Multiple Charts and Text
Lecture 5: GGPlot Creating Multiple Charts with Facets
Lecture 6: Plotly
Lecture 7: Highcharter
Lecture 8: Data Tables
Lecture 9: RMarkdown
Lecture 10: Flexdashboards
Chapter 3: Best Practice, Troubleshooting and Debugging
Lecture 1: Fixing Errors
Chapter 4: FAQ
Lecture 1: FAQ Intro
Lecture 2: R vs Python
Lecture 3: Fill Missing Values
Lecture 4: NA Values and Bulk Column Operations
Lecture 5: Email Marketing Analysis with R
Lecture 6: R Script into Dashboards
Lecture 7: Load R Shiny Flexdashboards Faster
Lecture 8: Load 1000 CSV Files in 3 Seconds to Dataframe
Lecture 9: Combine Excel Files Fast
Lecture 10: R Shiny Flexdashboard Export Data
Lecture 11: Dynamic Dashboard Filters
Lecture 12: Dynamic Column Selector
Chapter 5: Archive – Legacy Code
Lecture 1: Pivoting
Chapter 6: Bonus Lecture: More Resources to Reach Your Goals Faster
Lecture 1: Bonus Lecture: More Resources to Reach Your Goals Faster
Instructors
-
Jonathan Ng
Data Science and BI Strategy
Rating Distribution
- 1 stars: 10 votes
- 2 stars: 15 votes
- 3 stars: 68 votes
- 4 stars: 277 votes
- 5 stars: 389 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024