We may earn an affiliate commission when you visit our partners.
Course image
Rav Ahuja, Steve Ryan, Sandip Saha Joy, Sandip Sasha Joy, Yan Luo, Saishruthi Swaminathan, Tiffany Zhu, Yiwen Li, Gabriela de Queiroz, and Jeff Grossman

This Professional Certificate program is intended for anyone who is seeking to develop the job-ready skills, tools, and portfolio for an entry-level data analyst or data scientist position. No prior knowledge of R, or programming is required to get you started!

Read more

This Professional Certificate program is intended for anyone who is seeking to develop the job-ready skills, tools, and portfolio for an entry-level data analyst or data scientist position. No prior knowledge of R, or programming is required to get you started!

In this Data Analytics and Visualization with Excel and R Professional Certificate Program, you will dive into the role of a data analyst or data scientist and develop the essential skills you need work with a range of data sources and apply powerful tools, including Excel, Cognos Analytics, and the R programming language (including: ggplot2, Leaflet and R Shiny), towards becoming a data driven practitioner, and gaining a competitive edge in the job market.

By the end of this program, you will be able to explain the data analyst and data scientist roles. Skills you will developer and tools you will be exposed to in this program include:

Throughout this Professional Certificate, you will also complete hands-on labs and projects to help you gain practical experience with Excel, Cognos Analytics, SQL, and the R programing language and related libraries for data science, including Tidyverse, Tidymodels, R Shiny, ggplot2, Leaflet, and rvest.

In the final course in this Professional Certificate, you will complete a capstone project that applies what you have learned to a challenge that requires data collection, analysis, basic hypothesis testing, visualization, and modelling to be performed on real-world datasets.

What you'll learn

  • Use Excel spreadsheets to perform data analysis tasks such as data preparation (wrangling), creating pivot tables, data mining, & plotting charts.
  • Complete the data analysis process, from data preparation to statistical analysis and predictive modeling using R, R Studio, and Jupyter.
  • Create relational databases and tables, query data, sort, filter and aggregate result sets using SQL and R from JupyterLab.
  • Communicate data findings with various data visualization techniques including, charts, plots & interactive dashboards such as Cognos and R Shiny.

Share

Help others find this collection page by sharing it with your friends and followers:

What's inside

Eight courses

Analyzing Data with Excel

(12 hours)
This course provides students with the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis. The course consists of several videos, demos, examples, and hands-on labs to help you learn, and ends with a final assignment project which will help you put what you have learned into practice.

Data Visualization and Building Dashboards with Excel and Cognos

(10 hours)
This course provides students with the basics required to create data visualizations and dashboards using both Microsoft Excel and IBM Cognos Analytics. You begin the process of telling a story about your data by creating several basic and advanced charts in Excel and learning how to add them to a digital dashboard.

Data Analytics Basics for Everyone

(12 hours)
In this course, you will learn about the various components of a modern data ecosystem and the role Data Analysts, Data Scientists, and Data Engineers play in this ecosystem. You will gain an understanding of data structures, file formats, sources of data, and data repositories. You will understand what Big Data is and the features and uses of some of the Big Data processing tools.

SQL for Data Science with R

(15 hours)
A majority of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language for communicating with and extracting data from databases. A working knowledge of databases and the SQL language is a must if you want to become a data scientist. This course introduces relational database concepts and helps you learn and apply foundational knowledge of the SQL and R languages.

Analyzing Data with R

(15 hours)
The R programming language is purpose-built for data analysis. This course starts with a question, and then walks you through the process of answering it through data. You will first learn important techniques for preparing your data for analysis. Then you will learn how to gain a better understanding of your data through exploratory data analysis.

Visualizing Data with R

(6 hours)
In this course, you will learn the Grammar of Graphics, a system for describing and building graphs. You will also learn how to use the ggplot2 data visualization package for R to create basic bar charts, histograms, pie charts, scatter plots, line plots, and box plots. You will then learn how to use the Leaflet package for R to create map plots. Finally, you will learn about creating interactive dashboards using the R Shiny package.

R Data Science Capstone Project

(6 hours)
In this capstone project, you will apply data science skills and techniques to real-world datasets. You will collect and analyze data, perform hypothesis testing, and create visualizations. The project culminates in a presentation of your data analysis report.

R Programming Basics for Data Science

(7 hours)
The R language plays a critical role in data analysis and is a common programming language in data science & analytics. This course will introduce you to R language fundamentals like data types, techniques for manipulation, and how to implement fundamental programming tasks. We’ll also cover common data structures and programming fundamentals.

Save this collection

Save Data Analytics and Visualization with Excel and R to your list so you can find it easily later:
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser