Buy Now AED 170.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Data Visualization and Dashboards with Excel and Cognos
  • Level Foundation
  • Duration 24 hours
  • Course by IBM
  • Offered by

About

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.

Modules

Welcome to the course

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Course Intro

2 Readings

  • Helpful Tips for Course Completion
  • Syllabus

Creating Charts

    • 5 Videos
    • 2 Readings
    • 1 Quiz
    • 2 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz: Visualizing Data using Spreadsheets

5 Videos

  • Introduction to Charts
  • Interview: Using Visualizations to Tell a Data Story
  • Creating Basic Charts in Excel (Line, Pie, and Bar Charts)
  • Introduction to Creating Pivot Tables in Excel
  • Using the Excel PivotChart Feature

2 Readings

  • Optional Hands-on Labs on Excel Basics
  • Summary and Highlights

1 Quiz

  • Graded Quiz : Visualizing Data using Spreadsheets

Creating Advanced Charts

    • 2 Videos
    • 1 Readings
    • 1 Quiz
    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz: Creating Advanced Charts

2 Videos

  • Creating Treemaps, Scatter Charts, and Histograms
  • Creating Filled Map Charts and Sparklines

1 Readings

  • Summary and Highlights

1 Quiz

  • Graded Quiz: Updating Advanced Charts

Creating Dashboards Using Spreadsheets

    • 3 Videos
    • 1 Readings
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Creating Dashboards using Spreadsheets
  • Graded Quiz: Creating Dashboards using Spreadsheets

3 Videos

  • Introduction to Dashboards
  • Interview: Using Dashboards to Present Data Results
  • Creating a Simple Dashboard using Excel

1 Readings

  • Summary and Highlights

Getting Started with IBM Cognos Analytics

    • 2 Videos
    • 1 Readings
    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz: Getting Started with IBM Cognos Analytics

2 Videos

  • Cognos Analytics: Introduction and How to Sign Up
  • Navigating in Cognos Analytics

1 Readings

  • Summary and Highlights

Creating Dashboards Using IBM Cognos Analytics

    • 2 Videos
    • 1 Readings
    • 2 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz: Creating Dashboards with Cognos Analytics

2 Videos

  • Creating a Simple Dashboard in Cognos Analytics
  • Advanced Capabilities in Cognos Analytics Dashboards

1 Readings

  • Summary and Highlights

[OPTIONAL] Using Google Looker Studio for Creating Visualizations

    • 4 Readings
    • 3 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz: Creating and Configuring Visualizations with Google Looker Studio

4 Readings

  • About this optional lesson with Looker Studio
  • (Optional) : Getting Started with Google Looker Studio
  • Creating Visualizations in Reports using Looker Studio
  • Summary and Highlights

Module Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Graded Quiz: Creating Visualizations and Dashboards with Cognos Analytics

Final Project - Creating Visualizations and Dashboards

    • 1 PeerReview
    • 4 Plugin
Show info about module content

1 Peer Review

  • Final Assignment-Part 3: Peer-graded Assignment

Course Wrap-Up

    • 2 Readings
Show info about module content

2 Readings

  • Congratulations and Next Steps
  • Course Credits and Acknowledgements

Auto Summary

Discover the art of data storytelling with "Data Visualization and Dashboards with Excel and Cognos." This foundational course in Data Science & AI, taught by Coursera, equips you with the skills to create compelling charts, graphs, and interactive dashboards without coding. You'll explore Excel's visualization tools, including PivotCharts and advanced chart types, and learn to craft dynamic dashboards using IBM Cognos Analytics. Ideal for beginners, this 24-hour course offers hands-on labs and a final project to build your portfolio, making it perfect for aspiring data analysts and business intelligence professionals. Available through a Starter subscription.

Sandip Saha Joy
Instructors

Sandip Saha Joy

Kevin McFaul
Instructors

Kevin McFaul

Steve Ryan
Instructors

Steve Ryan