• For Individuals
  • For Businesses
  • For Universities
  • For Governments
Coursera
Online Degrees
Careers
Log In
Join for Free
Coursera
IBM
Data Visualization and Dashboards with Excel and Cognos
  • About
  • Outcomes
  • Modules
  • Recommendations
  • Testimonials
  • Reviews
  1. Browse
  2. Data Science
  3. Data Analysis
IBM

Data Visualization and Dashboards with Excel and Cognos

This course is part of multiple programs.

This course is part of multiple programs

IBM Business Analyst Professional Certificate
IBM Business Intelligence (BI) Analyst Professional Certificate
IBM Systems Analyst Professional Certificate
IBM Data Analytics with Excel and R Professional Certificate
Data Analysis and Visualization Foundations Specialization
IBM Data Analyst Professional Certificate
IBM Data Management Professional Certificate
Sandip Saha Joy
Kevin McFaul
Steve Ryan

Instructors: Sandip Saha Joy

Instructors

Instructor ratings

We asked all learners to give feedback on our instructors based on the quality of their teaching style.

4.7 (1,279 ratings)
Sandip Saha Joy
Sandip Saha Joy
IBM
5 Courses•592,147 learners
Kevin McFaul
Kevin McFaul
IBM
2 Courses•198,321 learners
Steve Ryan
Steve Ryan
IBM
12 Courses•659,120 learners

196,228 already enrolled

Included with Coursera Plus

•Learn more
4 modules
Gain insight into a topic and learn the fundamentals.
4.7

(4,248 reviews)

Beginner level

Recommended experience

Recommended experience

Beginner level

Basic familiarity using spreadsheets like Excel and working with data sets.

Flexible schedule
Approx. 15 hours
Learn at your own pace
94%
Most learners liked this course

4 modules
Gain insight into a topic and learn the fundamentals.
4.7

(4,248 reviews)

Beginner level

Recommended experience

Recommended experience

Beginner level

Basic familiarity using spreadsheets like Excel and working with data sets.

Flexible schedule
Approx. 15 hours
Learn at your own pace
94%
Most learners liked this course
  • About
  • Outcomes
  • Modules
  • Recommendations
  • Testimonials
  • Reviews

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

  • Data Visualization
  • Scatter Plots
  • Histogram
  • Dashboard
  • Data Visualization Software
  • IBM Cognos Analytics
  • Tree Maps
  • Data Analysis
  • Microsoft Excel
  • Pivot Tables And Charts
  • Data Storytelling

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

2 quizzes, 8 assignments

Taught in English

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

Learn more about Coursera for Business
 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is available as part of
When you enroll in this course, you'll also be asked to select a specific program.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 4 modules in this course

Learn how to create data visualizations and dashboards using spreadsheets and analytics tools. This course covers some of the first steps for telling a compelling story with your data using various types of charts and graphs. You'll learn the basics of visualizing data with Excel and IBM Cognos Analytics without having to write any code.

You'll start by creating simple charts in Excel such as line, pie and bar charts. You will then create more advanced visualizations with Treemaps, Scatter Charts, Histograms, Filled Map Charts, and Sparklines. Next you’ll also work with the Excel PivotChart feature as well as assemble several visualizations in an Excel dashboard. This course also teaches you how to use business intelligence (BI) tools like Cognos Analytics to create interactive dashboards. By the end of the course you will have an appreciation for the key role that data visualizations play in communicating your data analysis findings, and the ability to effectively create them. Throughout this course there will be numerous hands-on labs to help you develop practical experience for working with Excel and Cognos. There is also a final project in which you’ll create a set of data visualizations and an interactive dashboard to add to your portfolio, which you can share with peers, professional communities or prospective employers.

In this module, you will be introduced to the basics of charts and the Excel functions that are used to create basic charts and pivot chart visualizations. By learning how to manipulate these features and creating visualizations, you will begin to understand the important role charts play in telling a data-driven story.

What's included

6 videos4 readings1 quiz1 assignment2 plugins

6 videos•Total 31 minutes
  • Course Intro•3 minutes•Preview module
  • Introduction to Charts•4 minutes
  • Interview: Using Visualizations to Tell a Data Story•3 minutes
  • Creating Basic Charts in Excel (Line, Pie, and Bar Charts)•5 minutes
  • Introduction to Creating Pivot Tables in Excel•7 minutes
  • Using the Excel PivotChart Feature •6 minutes
4 readings•Total 62 minutes
  • Helpful Tips for Course Completion•2 minutes
  • Syllabus•10 minutes
  • Optional Hands-on Labs on Excel Basics•40 minutes
  • Summary and Highlights•10 minutes
1 quiz•Total 21 minutes
  • Graded Quiz : Visualizing Data using Spreadsheets•21 minutes
1 assignment•Total 12 minutes
  • Practice Quiz: Visualizing Data using Spreadsheets•12 minutes
2 plugins•Total 30 minutes
  • Reading: Excel Keyboard Shortcuts•10 minutes
  • Hands-on Lab 1: Creating Basic Charts•20 minutes

In this module, you will learn about creating advanced charts and visualizations and learn about the basics of dashboarding and how to create a simple dashboard using a spreadsheet.

What's included

5 videos2 readings1 quiz3 assignments2 plugins

5 videos•Total 31 minutes
  • Creating Treemaps, Scatter Charts, and Histograms•7 minutes•Preview module
  • Creating Filled Map Charts and Sparklines•6 minutes
  • Introduction to Dashboards•3 minutes
  • Interview: Using Dashboards to Present Data Results•5 minutes
  • Creating a Simple Dashboard using Excel•7 minutes
2 readings•Total 20 minutes
  • Summary and Highlights•10 minutes
  • Summary and Highlights•10 minutes
1 quiz•Total 12 minutes
  • Graded Quiz: Updating Advanced Charts•12 minutes
3 assignments•Total 32 minutes
  • Graded Quiz: Creating Dashboards using Spreadsheets •12 minutes
  • Practice Quiz: Creating Advanced Charts•8 minutes
  • Practice Quiz: Creating Dashboards using Spreadsheets •12 minutes
2 plugins•Total 40 minutes
  • Hands-on Lab 2: Creating Advanced Charts•20 minutes
  • Hands-on Lab 3: Creating a Simple Dashboard with Excel•20 minutes

In this module, you will be introduced to another dashboarding solution called Cognos Analytics. After registering with Cognos Analytics, you will then explore the platform capabilities by creating visualizations, building a simple dashboard, and discovering its advanced features. Optionally, you can explore Google Looker Studio to create visualizations and build dashboards.

What's included

4 videos6 readings4 assignments6 plugins

4 videos•Total 25 minutes
  • Cognos Analytics: Introduction and How to Sign Up•3 minutes•Preview module
  • Navigating in Cognos Analytics•7 minutes
  • Creating a Simple Dashboard in Cognos Analytics•7 minutes
  • Advanced Capabilities in Cognos Analytics Dashboards•6 minutes
6 readings•Total 43 minutes
  • Summary and Highlights•1 minute
  • Summary and Highlights•10 minutes
  • About this optional lesson with Looker Studio•2 minutes
  • (Optional) : Getting Started with Google Looker Studio•10 minutes
  • Creating Visualizations in Reports using Looker Studio•10 minutes
  • Summary and Highlights•10 minutes
4 assignments•Total 38 minutes
  • Graded Quiz: Creating Visualizations and Dashboards with Cognos Analytics •12 minutes
  • Practice Quiz: Getting Started with IBM Cognos Analytics•8 minutes
  • Practice Quiz: Creating Dashboards with Cognos Analytics•10 minutes
  • Practice Quiz: Creating and Configuring Visualizations with Google Looker Studio•8 minutes
6 plugins•Total 250 minutes
  • Hands-on Lab: Getting Started with Cognos Analytics•40 minutes
  • Hands-on Lab: Different Methods for Creating Dashboard Visualizations with Cognos Analytics •45 minutes
  • Hands-on Lab: Advanced Dashboard Capabilities in Cognos Analytics•30 minutes
  • (Optional):Hands-on Lab: Getting Started with Google Looker Studio•60 minutes
  • (Optional): Hands-on Lab: Creating and Configuring Visualizations in Reports with Google Looker Studio•60 minutes
  • (Optional) Hands-on Lab: Advanced charts in Looker Studio•15 minutes

Congratulations! You have now completed the modules for this course. In this module, you will complete the final assignment that will be graded by your peers. In the first part of the final assignment, you will use provided sample data to create some visualizations using Excel for the web. In the second part of the final assignment, you will create some visualizations and add them to a dashboard using Cognos Analytics or Google Looker Studio.

What's included

2 readings1 peer review4 plugins

2 readings•Total 11 minutes
  • Congratulations and Next Steps•10 minutes
  • Course Credits and Acknowledgements•1 minute
1 peer review•Total 45 minutes
  • Final Assignment-Part 3: Peer-graded Assignment•45 minutes
4 plugins•Total 205 minutes
  • Final Project Overview•10 minutes
  • Final Assignment - Part 1: Creating Visualizations Using Excel•45 minutes
  • Final Assignment - Part 2a: Creating Visualizations Using Cognos Analytics•75 minutes
  • Final Assignment - Part 2b: Creating Visualizations Using Google Looker Studio•75 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

Instructor ratings

Instructor ratings

We asked all learners to give feedback on our instructors based on the quality of their teaching style.

4.7 (1,279 ratings)
Sandip Saha Joy
Sandip Saha Joy
IBM
5 Courses•592,147 learners

Instructors

Instructor ratings

We asked all learners to give feedback on our instructors based on the quality of their teaching style.

4.7 (1,279 ratings)
Sandip Saha Joy
Sandip Saha Joy
IBM
5 Courses•592,147 learners
Kevin McFaul
Kevin McFaul
IBM
2 Courses•198,321 learners
Steve Ryan
Steve Ryan
IBM
12 Courses•659,120 learners

Offered by

IBM

Offered by

IBM

At IBM, we know how rapidly tech evolves and recognize the crucial need for businesses and professionals to build job-ready, hands-on skills quickly. As a market-leading tech innovator, we’re committed to helping you thrive in this dynamic landscape. Through IBM Skills Network, our expertly designed training programs in AI, software development, cybersecurity, data science, business management, and more, provide the essential skills you need to secure your first job, advance your career, or drive business success. Whether you’re upskilling yourself or your team, our courses, Specializations, and Professional Certificates build the technical expertise that ensures you, and your organization, excel in a competitive world.

Explore more from Data Analysis

  • Status: Free Trial
    Free Trial
    M

    Macquarie University

    Data Visualization in Excel

    Course

  • Status: Free Trial
    Free Trial
    I

    IBM

    BI Dashboards with IBM Cognos Analytics and Google Looker

    Course

  • Status: Free
    Free
    C

    Coursera Project Network

    Create Charts and Dashboards Using Microsoft Excel

    Guided Project

  • Status: Free
    Free
    C

    Coursera Project Network

    Create Charts and Dashboard using Google Sheets

    Guided Project

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

Learner reviews

4.7

4,248 reviews

  • 5 stars

    77.73%

  • 4 stars

    17.46%

  • 3 stars

    2.80%

  • 2 stars

    1.05%

  • 1 star

    0.94%

Showing 3 of 4248

O
OC
4

Reviewed on Aug 10, 2022

Having taking the tutorial class, i can say it enriched me with alot of information about Data Analytics. Tools for visualization such as Excel and Cognos, gives important clearity about data.

B
BF
5

Reviewed on Jan 20, 2022

Familiarity with the powerful Cognus program was very good. If you continue this course, good things will surely happen to you. This was the third course I took and it was really great

C
CV
4

Reviewed on Mar 18, 2024

In general the course was great. The only thing is that for very beginners is really difficult to grasp even after a few attempts, therefore instructions should be broken down more in detail.

View more reviews
Coursera Plus

Open new doors with Coursera Plus

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

Learn more

Advance your career with an online degree

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

Explore degrees

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

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

  • The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

  • The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policyOpens in a new tab.

More questions

Visit the learner help center

Financial aid available,

Coursera Footer

Technical Skills

  • ChatGPT
  • Coding
  • Computer Science
  • Cybersecurity
  • DevOps
  • Ethical Hacking
  • Generative AI
  • Java Programming
  • Python
  • Web Development

Analytical Skills

  • Artificial Intelligence
  • Big Data
  • Business Analysis
  • Data Analytics
  • Data Science
  • Financial Modeling
  • Machine Learning
  • Microsoft Excel
  • Microsoft Power BI
  • SQL

Business Skills

  • Accounting
  • Digital Marketing
  • E-commerce
  • Finance
  • Google
  • Graphic Design
  • IBM
  • Marketing
  • Project Management
  • Social Media Marketing

Career Resources

  • Essential IT Certifications
  • High-Income Skills to Learn
  • How to Get a PMP Certification
  • How to Learn Artificial Intelligence
  • Popular Cybersecurity Certifications
  • Popular Data Analytics Certifications
  • What Does a Data Analyst Do?
  • Career Development Resources
  • Career Aptitude Test
  • Share your Coursera Learning Story

Coursera

  • About
  • What We Offer
  • Leadership
  • Careers
  • Catalog
  • Coursera Plus
  • Professional Certificates
  • MasterTrack® Certificates
  • Degrees
  • For Enterprise
  • For Government
  • For Campus
  • Become a Partner
  • Social Impact
  • Free Courses
  • ECTS Credit Recommendations

Community

  • Learners
  • Partners
  • Beta Testers
  • Blog
  • The Coursera Podcast
  • Tech Blog

More

  • Press
  • Investors
  • Terms
  • Privacy
  • Help
  • Accessibility
  • Contact
  • Articles
  • Directory
  • Affiliates
  • Modern Slavery Statement
  • Do Not Sell/Share
Learn Anywhere
Download on the App Store
Get it on Google Play
Logo of Certified B Corporation
© 2025 Coursera Inc. All rights reserved.
  • Coursera Facebook
  • Coursera Linkedin
  • Coursera Twitter
  • Coursera YouTube
  • Coursera Instagram
  • Coursera TikTok
Coursera

Sign up

Learn on your own time from top universities and businesses.

​
​
Between 8 and 72 characters
Your password is hidden
​

or

Already on Coursera?


Having trouble logging in? Learner help center

This site is protected by reCAPTCHA Enterprise and the Google Privacy Policy and Terms of Service apply.