Online Course – Certified Professional Certificate in Data Analysis with Excel and IBM R

Prepare for a career in data analytics. Gain the necessary skills and hands-on experience to be job-ready in less than 3 months. No prior experience required.

Suggested by: Coursera (What is Coursera?)

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Excel skills
  • Skills in Cognos Analytics
  • Skills in the R programming language
  • Data analysis using Excel sheets
  • Working with Jupyter Notebooks
  • Working with R Studio
  • Data preparation
  • Statistical analysis
  • Create data visualizations
  • Building predictive models
  • Create interactive dashboards
  • Communicating data findings
  • Preparing summary reports
  • Practical experience with SQL
  • Using Tidyverse, Tidymodels, R Shiny, ggplot2, Leaflet, and rvest libraries
  • Inventory data analysis
  • Create interactive dashboards
  • Identifying patterns in data
  • Building linear and polynomial regression models
  • Hypothesis testing
  • Exploring trends in census data
  • Researching the impact of weather on the demand for bike sharing

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • Business Analyst
  • Information Systems Analyst
  • Medical Data Analyst
  • Financial Data Analyst
  • Marketing Data Analyst
  • Predictive Model Developer
  • Interactive dashboard developer
  • Excel and R expert
  • Data analyst with SQL
## Professional Certificate – A 9-course course series to prepare you for the in-demand field of data analytics. In this program, you will learn valuable skills like Excel, Cognos Analytics, and the R programming language to **be job-ready in less than 3 months**. Data analytics is a strategy-based science where data is analyzed to find trends, answer questions, design business processes, and aid decision-making. This professional certificate focuses on data analysis **using Microsoft Excel and the R programming language**. If you are interested in Python, please check out the IBM Analyst Certificate. This program will teach you the fundamental data skills that employers are looking for in entry-level data analytics roles and provide you with a **project portfolio and professional certificate** from IBM to showcase your expertise to potential employers. You will learn the latest skills and tools used by professional data analysts, and upon successful completion of the program, you will be able to work with **Excel Sheets, Jupyter Notebooks, and R Studio** to analyze data and create visualizations. Additionally, you will use the R language to complete the entire data analysis process, including data preparation, statistical analysis, data visualizations, predictive modeling, and interactive dashboard creation. Finally, you will learn how to **communicate your data findings** and prepare a summary report. This program is recommended by ACE® and FIBAA—when you graduate, **you can earn up to 15 academic credits and 4 ECTS credits**. ### Hands-on Learning Project You will complete hands-on labs to build your portfolio and gain hands-on experience with Excel, Cognos Analytics, SQL, and the R language and data science-related libraries, including Tidyverse, Tidymodels, R Shiny, ggplot2, Leaflet, and rvest. Projects include: – Analyzing fleet inventory data using pivot tables. – Using KPI data from vehicle sales to create an interactive dashboard. – Identifying patterns in COVID-19 testing rates across countries using R. – Using SQL with the RODBC R package to analyze foreign grain markets. – Creating linear and polynomial regression models and comparing them with weather station data to predict precipitation. – Using the R Shiny package to create a dashboard that explores trends in census data. – Using hypothesis testing and predictive modeling skills to build an interactive dashboard with the R Shiny package and Leaflet’s dynamic map widget to explore how weather affects bike share demand.

Details of the courses that make up the specialization