Explore

Data Visualization and Dashboards with Excel and Cognos

Approx. 10 hours to complete

Save Course

Go to Course

Course Summary

Learn how to create effective data visualizations and dashboards using Excel and Cognos in this course. You'll gain valuable skills in data analysis and presentation that can be applied in a variety of industries and job positions.

Key Learning Points

Learn how to create interactive dashboards and visualizations using Excel and Cognos
Gain skills in data analysis and presentation
Apply your new skills to a variety of industries and job positions

Learning Outcomes

Create interactive dashboards and visualizations using Excel and Cognos
Analyze and present data effectively
Apply your skills in a variety of industries and job positions

Prerequisites or good to have knowledge before taking this course

Basic knowledge of Excel
Familiarity with data analysis concepts

Course Difficulty Level

Beginner

Course Format

Self-paced
Online

Similar Courses

Data Visualization Essentials
Data Analysis and Presentation Skills: the PwC Approach

Related Education Paths

Notable People in This Field

Stephen Few
Nathan Yau

Related Books

Description

This course covers some of the first steps in the development of data visualizations using spreadsheets and dashboards. Begin the process of telling a story with your data by creating the many types of charts that are available in spreadsheets like Excel. Explore the different tools of a spreadsheet, such as the important pivot function and the ability to create dashboards and learn how each one has its own unique property to transform your data. Continue to gain valuable experience by becoming familiar with the popular analytics tool - IBM Cognos Analytics - to create interactive dashboards.

By completing this course, you will have a basic understanding of using spreadsheets as a data visualization tool. You will gain the ability to effectively create data visualizations, such as charts or graphs, and will begin to see how they play a key role in communicating your data analysis findings. All of this can be accomplished by learning the basics of data analysis with Excel and IBM Cognos Analytics, without having to write any code. By the end of this course you will be able to describe common dashboarding tools used by a data analyst, design and create a dashboard in a cloud platform, and begin to elevate your confidence level in creating intermediate level data visualizations. Throughout this course you will encounter numerous hands-on labs and a final project. With each lab, gain hands-on experience with creating basic and advanced charts, then continue through the course and begin creating dashboards with spreadsheets and IBM Cognos Analytics. You will then end this course by creating a set of data visualizations with IBM Cognos Analytics and creating an interactive dashboard that can be shared with peers, professional communities or prospective employers. This course does not require any prior data analysis, or computer science experience. All you need to get started is basic computer literacy, high school level math, access to a modern web browser such as Chrome or Firefox, the ability to create a Microsoft account to access Excel for the Web, and a basic understanding of Excel spreadsheets.

Outline

Visualizing Data Using Spreadsheets
Course Intro Video
Introduction to Charts
Interview: Using Visualizations to Tell a Data Story
Creating Basic Charts in Excel (Line, Pie, and Bar Charts)
Using the Excel PivotChart Feature
Optional Hands-on Labs
Summary and Highlights
Practice Quiz
Graded Quiz

Creating Visualizations and Dashboards with Spreadsheets
Creating Treemaps, Scatter Charts, and Histograms
Creating Filled Map Charts and Sparklines
Introduction to Dashboarding
Interview: Using Dashboards to Present Data Results
Creating a Simple Dashboard using Excel
Summary and Highlights
Summary and Highlights
Practice Quiz
Graded Quiz
Practice Quiz
Graded Quiz

Creating Visualizations and Dashboards with Cognos Analytics
Cognos Analytics: Introduction and How to Sign Up
Navigating in Cognos Analytics
Creating a Simple Dashboard in Cognos
Advanced Capabilities in Cognos Analytics Dashboards
Summary and Highlights
Practice Quiz
Graded Quiz

Final Project
Congratulations and Next Steps
Course Credits and Acknowledgements

Summary of User Reviews

Discover the art of data visualization and dashboards using Excel and Cognos in this highly-rated course on Coursera. Students praise the course for its comprehensive coverage and practical approach to data visualization.

Key Aspect Users Liked About This Course

Many users found the practical exercises and real-world examples to be very helpful in learning the concepts.

Pros from User Reviews

Comprehensive coverage of data visualization and dashboard creation
Practical exercises and real-world examples
Easy to follow and understand
Great instructor and teaching style
Course is well-structured and organized

Cons from User Reviews

Some users found the course to be too basic
Limited coverage of advanced topics
Not suitable for advanced users
Lack of interaction and feedback from instructors
Some users found the course to be too focused on Excel and Cognos

Recommended for you

Tableau - Business Intelligence and Analytics using Tableau

This training is a practical and a quantitative course. You will learn BI, Customer Analytics and Pricing Analytics Customer Analytics using R and Tableau...

Save Course

Excel with Interactive Excel Dashboards

Learn how to create amazing interactive Excel Dashboards that will wow your boss & take your career to the next level....

Save Course

Analyzing and Visualizing Data with Power BI 70-778 Practice

Analyzing and Visualizing Data with Microsoft Power BI 70-778 Certification Practice Exam with 300 Questions Enhance your certification score. Online practice exam to be completed in Specified Time Duration....

Save Course

Data Warehouse ETL Testing & Data Quality Management A-Z

ETL Testing and Data Quality Management for beginners with practical exercises and certificate of completion. Learn the essentials of ETL Data Warehouse Testing and Data Quality Management through this step-by-step tutorial....

Save Course