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.
Offered By
IBM Skills NetworkAbout this Course
278,701 recent views
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Beginner Level
Basic familiarity with using spreadsheet software like Excel.
Approx. 9 hours to complete
English
Subtitles: Arabic, French, Portuguese (European), Vietnamese, Russian, English, Spanish
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessWhat you will learn
Create basic charts and pivot charts in Excel.
Explain the important role charts play in telling a data-driven story.
Construct advanced charts and visualizations.
Build dashboards using Excel and Cognos Analytics.
Skills you will gain
- Microsoft Excel
- Data Analysis
- Data Visualization (DataViz)
- IBM Cognos Analytics
- Dashboard
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Beginner Level
Basic familiarity with using spreadsheet software like Excel.
Approx. 9 hours to complete
English
Subtitles: Arabic, French, Portuguese (European), Vietnamese, Russian, English, Spanish
Could your company benefit from training employees on in-demand skills?
Try Coursera for Business
Offered by
IBM Skills Network
IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world.
Syllabus - What you will learn from this course
2 hours to complete
Visualizing Data Using Spreadsheets
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.
2 hours to complete
5 videos (Total 24 min), 2 readings, 2 quizzes
2 hours to complete
Creating Visualizations and Dashboards with Spreadsheets
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.
2 hours to complete
5 videos (Total 31 min), 2 readings, 4 quizzes
3 hours to complete
Creating Visualizations and Dashboards with Cognos Analytics
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.
3 hours to complete
4 videos (Total 13 min), 1 reading, 2 quizzes
2 hours to complete
Final Project
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.
2 hours to complete
2 readings
Reviews
- 5 stars76.57%
- 4 stars18.64%
- 3 stars2.89%
- 2 stars1.29%
- 1 star0.59%
TOP REVIEWS FROM DATA VISUALIZATION AND DASHBOARDS WITH EXCEL AND COGNOS
by CSJul 25, 2021
Excellent!
I had never worked with a cloud Business Analytics tool. It was a great experience and thanks for the opportunity offered by Coursera and IBM.
by MRSep 16, 2021
Very well structured and well define in terms of course design. Learn a lot of new skilled and gain a great deal of knowledge regarding data analysis.
by ATAug 13, 2021
This course was not easy, I have never used IBM Cognos before. I was nervous logging into it and making sure I am doing it right. I end up using 2 monitors to see what I am doing.
by DBAug 17, 2022
Fantastic to have a 90 Day Free Trial for IBM Cognos! I will take another course as soon as possible to take advantage of this to learn it better.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Certificate?
More questions? Visit the Learner Help Center.
