Save For Later

Data Analytics and Visualization with Excel and R

Save For Later

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.

Read More

OpenCourser is an affiliate partner of edX and may earn a commission when you buy through our links.

From IBM via edX
Hours 104
Instructors Sandip Sasha Joy, Steve Ryan, Sandip Saha Joy, Rav Ahuja, Gabriela de Queiroz, Tiffany Zhu, Yiwen Li, Saishruthi Swaminathan, Yan Luo, Jeff Grossman
Language English
Subjects Data Science

Similar Courses

Sorted by relevance

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

Professional Secretary $41k

Gifted Certificate Program Coordinator $48k

Instructor, Paralegal Certificate Program $52k

Instructor and Taskforce Committee Member for Certificate in Fundraising Operations $60k

Finance Professional 3 $65k

Certificate Analyst $67k

Continuing Education Professor/Apparel Certificate Program Advisor $68k

Instructor, Sustainability Leadership Certificate Program $79k

Vice Assistant President Certificate Specialist $120k

Product Manager - SUT Compliance and Certificate Management $131k

Assistant Professor, Bereavement Certificate Program $139k

Professional Partner $155k

Courses in this Professional Certificate

Listed in the order in which they should be taken

Starts Course Information

On Demand

Analyzing Data with Excel

Please Note: Learners who successfully complete this IBM course can earn a skill badge — a detailed, verifiable and digital credential that profiles the knowledge and skills...

edX | IBM

Save

On Demand

Data Visualization and Building Dashboards with Excel and Cognos

Please Note: Learners who successfully complete this IBM course can earn a skill badge — a detailed, verifiable and digital credential that profiles the knowledge and skills...

edX | IBM

Save

On Demand

Data Analytics Basics for Everyone

Please Note: Learners who successfully complete this IBM course can earn a skill badge —a detailed, verifiable and digital credential that profiles the knowledge and skills you’ve...

edX | IBM

Save

On Demand

SQL for Data Science with R

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...

edX | IBM

Save

On Demand

Analyzing Data with R

The R programming language is purpose-built for data analysis. R is the key that opens the door between the problems you want to solve with data and the answers you need to meet...

edX | IBM

Save

On Demand

Visualizing Data with R

In this course, you will learn about the Grammar of Graphics, a system for describing and building graphs, and how the ggplot2 data visualization package for R applies this...

edX | IBM

Save

On Demand

R Data Science Capstone Project

In this capstone course, you will apply various data science skills and techniques that you have learned as part of the previous courses in the IBM Data Science with R or IBM Data...

edX | IBM

Save

On Demand

R Programming Basics for Data Science

The R language plays a critical role in data analysis and a common programming language when working in the field of data science & analytics. This course will introduce you to R...

edX | IBM

Save

edX

&

IBM

From IBM via edX
Hours 104
Instructors Sandip Sasha Joy, Steve Ryan, Sandip Saha Joy, Rav Ahuja, Gabriela de Queiroz, Tiffany Zhu, Yiwen Li, Saishruthi Swaminathan, Yan Luo, Jeff Grossman
Language English
Subjects Data Science

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

Professional Secretary $41k

Gifted Certificate Program Coordinator $48k

Instructor, Paralegal Certificate Program $52k

Instructor and Taskforce Committee Member for Certificate in Fundraising Operations $60k

Finance Professional 3 $65k

Certificate Analyst $67k

Continuing Education Professor/Apparel Certificate Program Advisor $68k

Instructor, Sustainability Leadership Certificate Program $79k

Vice Assistant President Certificate Specialist $120k

Product Manager - SUT Compliance and Certificate Management $131k

Assistant Professor, Bereavement Certificate Program $139k

Professional Partner $155k

Similar Courses

Sorted by relevance