IBM Data Analytics with Excel and R Professional Certificate
Course Features
Partner
Level
Start Date
Duration
Access
Certificate
IBM Data Analytics with Excel and R Professional Certificate
About this 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.
Applied Learning Project
Throughout this Professional Certificate, you will 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 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
Instructors
About the instructor
Rav Ahuja is a Global Program Director at IBM. Rav leads growth strategy, curriculum creation, and partner programs for the IBM Skills Network. He is the architect for the IBM Data Science Professional Certificate and instructor for the Databases & SQL for Data Science course on Coursera. Rav co-founded Cognitive Class, an IBM led initiative to democratize skills for in demand technologies. He is based out of the IBM Canada Lab in Toronto and specializes in instructional solutions for AI, Data Science, Cloud and Blockchain. Rav presents at events worldwide and has authored numerous papers, articles, books and courses on subjects in managing and analyzing data. Rav holds B. Eng. from McGill University and MBA from University of Western Ontario.
