Professional Certificate in Data Analytics and Visualization with Excel and R

Offered byedX

Professional Certificate in Data Analytics and Visualization with Excel and R
at
edX
Overview

Gain a robust foundation in data analytics and visualization to harness the power of data for informed decision-making and strategic insights in various professional contexts

Duration	10 months
Total fee	₹59,540
Mode of learning	Online
Official Website	Go to Website
Credential	Certificate

Professional Certificate in Data Analytics and Visualization with Excel and R
at
edX
Highlights

Earn a certificate after completion of the course
Capstone projects for real world scenarios

Professional Certificate in Data Analytics and Visualization with Excel and R
at
edX
Course details

Who should do this course?

For aspirants who is seeking to develop the job-ready skills, tools, and portfolio for an entry-level data analyst or data scientist position

What are the course deliverables?

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

More about this course

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.

Professional Certificate in Data Analytics and Visualization with Excel and R
at
edX
Curriculum

Data Analytics Basics for Everyone

Learn the fundamentals of Data Analytics and gain an understanding of the data ecosystem, the process and lifecycle of data analytics, career opportunities, and the different learning paths you can take to be a Data Analyst

Analyzing Data with Excel

Build the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis. The course covers the basic workings and key features of Excel to help students analyze their data

Data Visualization and Building Dashboards with Excel and Cognos

Build the fundamental knowledge necessary to use Excel and IBM Cognos Analytics to create data visualizations and to create dashboards containing those visualizations to help tell a lucid story about data

R Programming Basics for Data Science

This course introduces you to R language fundamentals and covers common data structures, programming techniques, and how to manipulate data all with the help of the R programming language

SQL for Data Science with R

Build a baseline understanding about relational database concepts and learn how to apply foundational knowledge of the SQL and R languages through a series of hands-on labs to practice building and running SQL queries

Analyzing Data with R

R is the key that opens the door between the problems you want to solve with data and the answers you need. This course walks you through the process of answering questions through data

Visualizing Data with R

Learn about the ggplot2 data visualization package for R, creating map plots with geolocation data using Leaflet, and interactive dashboards to display your work on the web using the R Shiny package!

R Data Science Capstone Project

Apply various data analysis and visualization skills and techniques you have learned by taking on the role of a data scientist working with real-world data sets

Professional Certificate in Data Analytics and Visualization with Excel and R
at
edX
Faculty details

Gabriela de Queiroz

Gabriela de Queiroz is a Program Director at IBM where she manages and leads a team of developers working on Data & AI Open Source projects. She works to democratize AI by building tools and launching new open source projects.

Saishruthi Swaminathan

Saishruthi Swaminathan is a data scientist and developer advocate in the IBM CODAIT team whose main focus is to democratize data and AI through open source technologies. She has a Masters in Electrical Engineering specializing in Data Science and a Bachelor degree in Electronics and Instrumentation.