IBM
IBM Data Analytics with Excel and R Professional Certificate
IBM

IBM Data Analytics with Excel and R Professional Certificate

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

Taught in English

Some content may not be translated

IBM Skills Network Team
Rav Ahuja
Saishruthi Swaminathan

Instructors: IBM Skills Network Team

23,804 already enrolled

Professional Certificate - 9 course series

Earn a career credential that demonstrates your expertise

4.7

(1,949 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

  • Master the most up-to-date practical skills and knowledge data analysts use in their daily roles

  • Learn how to perform data analysis, including data preparation, statistical analysis, and predictive modeling using R, R Studio, and Jupyter

  • Utilize Excel spreadsheets to perform a variety of data analysis tasks like data wrangling, using pivot tables, data mining, & creating charts

  • Communicate your data findings using various data visualization techniques including, charts, plots & interactive dashboards with Cognos and R Shiny

Details to know

Shareable certificate

Add to your LinkedIn profile

Professional Certificate - 9 course series

Earn a career credential that demonstrates your expertise

4.7

(1,949 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

Prepare for a career in Data Analytics

  • Receive professional-level training from IBM
  • Demonstrate your proficiency in portfolio-ready projects
  • Earn an employer-recognized certificate from IBM
  • Qualify for in-demand job titles: Data Analyst, Associate Data Analyst, Business Analyst
Placeholder
$90,000+
median U.S. salary for Data Analytics
¹
82,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, 7/1/22-6/30/23. ²Based on program graduate survey responses, United States 2021.

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

Professional Certificate - 9 course series

Introduction to Data Analytics

Course 110 hours4.8 (14,356 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: Linear Regression
Category: Data Visualization
Category: R Programming
Category: Exploratory Data Analysis

Excel Basics for Data Analysis

Course 211 hours4.8 (7,246 ratings)

What you'll learn

  • Display 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 filter, sort, look-up functions, as well as pivot tables.

Skills you'll gain

Category: Data Science
Category: Spreadsheet
Category: Data Analysis
Category: Microsoft Excel
Category: Data Visualization

Data Visualization and Dashboards with Excel and Cognos

Course 314 hours4.7 (3,370 ratings)

What you'll learn

  • Create basic visualizations such as line graphs, bar graphs, 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: Data Science
Category: R Programming

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.

Skills you'll gain

Category: Data Analysis
Category: Microsoft Excel
Category: IBM Cognos Analytics
Category: Dashboard
Category: Data Visualization

Introduction to R Programming for Data Science

Course 510 hours4.5 (412 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: Data Analysis
Category: Statistical Analysis
Category: Data Visualization
Category: R Programming

SQL for Data Science with R

Course 627 hours4.3 (117 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 Structure
Category: Data Analysis
Category: Microsoft Excel
Category: cognos analytics
Category: Pivot Charts

Data Analysis with R

Course 716 hours4.7 (263 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: Data Analysis
Category: Data Visualization
Category: R Programming

Data Visualization with R

Course 812 hours4.6 (202 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: Select (Sql)
Category: Relational Databases (RDBMS)
Category: R Programming

Data Science with R - Capstone Project

Course 924 hours4.5 (62 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: Spreadsheet
Category: Data Analysis
Category: Microsoft Excel
Category: Pivot Table

Instructors

IBM Skills Network Team
IBM
52 Courses725,951 learners
Rav Ahuja
IBM
52 Courses2,308,120 learners
Saishruthi Swaminathan
IBM
2 Courses277,807 learners

Offered by

IBM

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."

New to Data Analysis? Start here.

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