Data Visualization and Dashboards with Excel and Cognos

Instructor: Sandip Saha Joy , Kevin McFaul , Steve Ryan

Beginner Level • 5 hours to complete • Flexible Schedule

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

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

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • 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

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.

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.

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.

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.