IBM
IBM Data Analytics with Excel and R Professional Certificate
IBM

IBM Data Analytics with Excel and R Professional Certificate

Kickstart Your Data Analytics Career w/ Excel & R. Master the data analysis and visualization tools to transform data into information and insights.

Rav Ahuja
Sandip Saha Joy
Steve Ryan

Instructors: Rav Ahuja

13,714 already enrolled

Professional Certificate - 9 course series

Earn a career credential that demonstrates your expertise

4.7

(1,542 reviews)

Beginner level

Recommended experience

3 months at 10 hours a week
Flexible schedule
Learn at your own pace
Earn degree credit

What you'll 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

Skills you'll gain

  • Category: Microsoft Excel
  • Category: Relational Databases (RDBMS)
  • Category: R Programming
  • Category: Data Analysis
  • Category: Data Visualization (DataViz)

Details to know

Shareable certificate

Add to your LinkedIn profile

English
Subtitles: English, Arabic,

Professional Certificate - 9 course series

Earn a career credential that demonstrates your expertise

4.7

(1,542 reviews)

Beginner level

Recommended experience

3 months at 10 hours a week
Flexible schedule
Learn at your own pace
Earn degree credit

See how employees at top companies are mastering in-demand skills

Placeholder

Advance your career with in-demand skills

  • Receive professional-level training from IBM
  • Demonstrate your technical proficiency
  • Earn an employer-recognized certificate from IBM
Placeholder
$81,000+
median U.S. salary for Data Analytics
¹
107,000+
U.S. job openings in Data Analytics
¹

Get exclusive access to career resources upon completion

  • Soft skills training

    Get free access to IBM’s People and Soft Skills Specialization

  • Resume review

    Improve your resume and LinkedIn with personalized feedback

  • Interview prep

    Practice your skills with interactive tools and mock interviews

  • Career support

    Plan your career move with Coursera’s job search guide

¹Lightcast™ Job Postings Report, United States, 1/1/22-12/31/22. ²Based on program graduate survey responses, United States 2021.

Professional Certificate - 9 course series

Introduction to Data Analytics

Course 110 hours4.8 (11,481 ratings)

What you'll learn

  • Explain what Data Analytics is and the key steps in the Data Analytics process

  • Differentiate between different data roles such as Data Engineer, Data Analyst, Data Scientist, Business Analyst, and Business Intelligence Analyst

  • Describe the different types of data structures, file formats, and sources of data

  • Describe the data analysis process involving collecting, wrangling, mining, and visualizing data

Skills you'll gain

Category: Data Science
Category: Spreadsheet
Category: Microsoft Excel
Category: Data Analysis
Category: Data Visualization (DataViz)

Excel Basics for Data Analysis

Course 213 hours4.8 (5,667 ratings)

What you'll learn

  • Gain working knowledge of Excel for Data Analysis

  • Perform basic spreadsheet tasks including navigation, data entry, and using formulas.

  • Employ data quality techniques to import and clean data in Excel.

  • Analyze data in spreadsheets by using filtering, sorting, look-up functions, and pivot tables.

Skills you'll gain

Category: Data Science
Category: Spreadsheet
Category: Microsoft Excel
Category: Data Analysis
Category: Pivot Table

Data Visualization and Dashboards with Excel and Cognos

Course 310 hours4.7 (2,716 ratings)

What you'll learn

  • Create basic graphs such as line, bar, and pie charts using Excel spreadsheets.

  • Explain the important role charts play in telling a data-driven story. 

  • Construct advanced charts and visualizations such as Treemaps, Sparklines, Histogram, Scatter Plots, and Filled Map Charts.

  • Build and share interactive dashboards using Excel and Cognos Analytics.

Skills you'll gain

Category: Microsoft Excel
Category: Data Analysis
Category: Data Visualization (DataViz)
Category: IBM Cognos Analytics
Category: Dashboard

What you'll learn

  • Demonstrate readiness for performing foundational data analysis and data visualization tasks and key steps in the Data Analytics process.

  • Differentiate between the roles different data professionals play in a modern data ecosystem.

  • Perform basic Excel tasks for Data Analysis including data quality and data preparation skills.

  • Exhibit abilities in visualizing data using Excel and proficiency in creating dashboards using Excel and Cognos Analytics.

Introduction to R Programming for Data Science

Course 510 hours4.5 (297 ratings)

What you'll learn

  • Manipulate primitive data types in the R programming language using RStudio or Jupyter Notebooks.

  • Control program flow with conditions and loops, write functions, perform character string operations, write regular expressions, handle errors.

  • Construct and manipulate R data structures, including vectors, factors, lists, and data frames.

  • Read, write, and save data files and scrape web pages using R.

Skills you'll gain

Category: Data Science
Category: R Programming

SQL for Data Science with R

Course 628 hours4.2 (83 ratings)

What you'll learn

  • Create and access a database instance on the cloud

  • Compose and execute basic SQL statements - SELECT, INSERT, UPDATE, DELETE, CREATE, DROP

  • Construct SQL statements to filter, sort, group results, use built-in functions, compose nested queries, access multiple tables

  • Analyze data from Jupyter using R and SQL by combining SQL and R skills to query real-world datasets

Skills you'll gain

Category: Data Science
Category: Select (Sql)
Category: Relational Databases (RDBMS)
Category: R Programming
Category: Data Analysis

Data Analysis with R

Course 716 hours4.7 (204 ratings)

What you'll learn

  • Prepare data for analysis by handling missing values, formatting and normalizing data, binning, and turning categorical values into numeric values.

  • Compare and contrast predictive models using simple linear, multiple linear, and polynomial regression methods.

  • Examine data using descriptive statistics, data grouping, analysis of variance (ANOVA), and correlation statistics.

  • Evaluate a model for overfitting and underfitting conditions and tune its performance using regularization and grid search.

Skills you'll gain

Category: Data Science
Category: Statistical Analysis
Category: R Programming
Category: Data Analysis
Category: Data Visualization (DataViz)

Data Visualization with R

Course 811 hours4.6 (155 ratings)

What you'll learn

  • Create bar charts, histograms, pie charts, scatter plots, line graphs, box plots, and maps using R and related packages.

  • Design customized charts and plots using annotations, axis titles, text labels, themes, and faceting.

  • Create maps using the Leaflet package for R.

  • Create interactive dashboards using the Shiny package for R.

Skills you'll gain

Category: Data Science
Category: Data Analysis
Category: Data Visualization (DataViz)
Category: R Programming

Data Science with R - Capstone Project

Course 926 hours4.5 (34 ratings)

What you'll learn

  • Write a web scraping program to extract data from an HTML file using HTTP requests and convert the data to a data frame.

  • Prepare data for modelling by handling missing values, formatting and normalizing data, binning, and turning categorical values into numeric values.

  • Interpret datawithexploratory data analysis techniques by calculating descriptive statistics, graphing data, and generating correlation statistics.

  • Build a Shiny app containing a Leaflet map and an interactive dashboard then create a presentation on the project to share with your peers.

Skills you'll gain

Category: Data Science
Category: R Programming
Category: Data Visualization (DataViz)
Category: Linear Regression
Category: Exploratory Data Analysis

Instructors

Rav Ahuja
IBM
39 Courses1,673,968 learners
Sandip Saha Joy
IBM
5 Courses242,518 learners
Steve Ryan
IBM
5 Courses235,395 learners

Offered by

IBM
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions