IBM Data Analytics with Excel and R Professional Certificate

This Professional Certificate 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. Through these eight online courses, 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, towards becoming a data driven practitioner, and gaining a competitive edge in the job market.
By the end of this Professional Certificate, you will be able to explain the data analyst and data scientist roles. You will work with Excel spreadsheets and utilize them for data analysis to create charts and plots. You will utilize Cognos Analytics to create interactive dashboards. You will work with relational databases and query data using SQL statements. You will use the R programming language to complete the entire data analysis process - including data preparation, statistical analysis, data visualization, predictive modeling, and creating interactive data applications. You will also communicate your data findings and learn to prepare a report for stakeholders.
This program is suitable for anyone with a passion for learning and does not require any prior data analysis, statistics, or programming experience.
WHAT YOU WILL LEARN
- Utilize Excel spreadsheets to perform a variety of data analysis tasks like data wrangling, using pivot tables, data mining, & creating charts
- Complete the data analysis process, including data preparation, statistical analysis, 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 your data findings using various data visualization techniques including, charts, plots & interactive dashboards with Cognos and R Shiny

Sort options

Data Visualization with R (Coursera)

Oct 25th 2021
Data Visualization with R (Coursera)
Course Auditing
Categories
Effort
Languages
In this course, you will learn the Grammar of Graphics, a system for describing and building graphs, and how the ggplot2 data visualization package for R applies this concept to basic bar charts, histograms, pie charts, scatter plots, line plots, and box plots. You will also learn how to [...]
0
No votes yet

Introduction to Data Analytics (Coursera)

This course presents a gentle introduction into the concepts of data analysis, the role of a Data Analyst, and the tools that are used to perform daily functions. You will gain an understanding of the data ecosystem and the fundamentals of data analysis, such as data gathering or data [...]
0
No votes yet

Excel Basics for Data Analysis (Coursera)

This course is designed to provide you with basic working knowledge for using Excel spreadsheets for Data Analysis. It covers some of the first steps for working with spreadsheets and their usage in the process of analyzing data. It includes plenty of videos, demos, and examples for you [...]
0
No votes yet

Data Science with R - Capstone Project (Coursera)

Oct 18th 2021
Data Science with R - Capstone Project (Coursera)
Course Auditing
Categories
Effort
Languages
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 Specialization or IBM Data Analytics with Excel and R Professional Certificate. For this project, you will assume the role [...]
0
No votes yet